IFB105 Database Management
To view more information for this unit, select Unit Outline from the list below. Please note the teaching period for which the Unit Outline is relevant.
| Unit code: | IFB105 |
|---|---|
| Equivalent(s): | IFB130, ITD105 |
| Assumed Knowledge: | For PU51 students, PUB110 is the assumed knowledge for IFB105. |
| Credit points: | 12 |
| Timetable | Details in HiQ, if available |
| Availabilities |
|
| CSP student contribution | $1,164 |
| Domestic tuition unit fee | $4,356 |
| International unit fee | $5,172 |
Unit Outline: Semester 1 2025, Gardens Point, Internal
| Unit code: | IFB105 |
|---|---|
| Credit points: | 12 |
| Equivalent: | IFB130 |
| Equivalent: | ITD105 |
| Assumed Knowledge: | For PU51 students, PUB110 is the assumed knowledge for IFB105. |
| Coordinators: | Mythreyi Velmurugan | m.velmurugan@qut.edu.au Gowri Ramachandran | g.ramachandran@qut.edu.au Mark Walpole | m.walpole@qut.edu.au |
Overview
This is an introductory unit on database addressing the core concepts, requirements and practices of databases. It introduces conceptual data modeling to address a key area of concern of modeling structured data to build a comprehensive understanding of the data aspect of a problem. You will learn how to transform such data model into a relational database design as well as how to effectively retrieve data through SQL queries. Normalization, database security/administration, other special topics and ethical aspects related to information systems are also covered. IAB207 Rapid Web App Development, IAB303 Data Analytics for Business Insights and the Capstone units IFB398 Capstone 1 and IFB399 Capstone 2 build on this unit for data storage/retrieval and business insights. IAB206 Modern Data Management extends this unit earning to unstructured data such as graphs and documents which are also gaining popularity in the real world.
Learning Outcomes
On successful completion of this unit you will be able to:
- Create a conceptual schema to model information in a domain.
- Construct SQL commands to store, retrieve and manipulate data in a relational database.
- Translate a conceptual schema into a relational database schema design.
- Normalise a relational database schema to improve data integrity.
- Analyse the social impacts, privacy and legal issues associated with managing data.
- Apply ethical fundamentals, including the ACS Code of Ethics and Professional Conduct to industry scenarios.
Content
The content of this unit is split into three modules:
1. Conceptual Data Modelling: In this module you will understand data aspects of an information system to develop a conceptual data model using Object Role Modelling (ORM) technique and then translate conceptual data model to relational database schema.
2. Database Development and Managment: In this module you will learn to i) create and modify a database schema; ii) retrieve database content through SQL query formulation and iii) generate ethical and culturally sensitive solutions to data management problems.
3. Special Topics: The final module is structured in a way to allow you to contextualise the knowledge and skills taught in earlier modules within a specific industry context. You will explore topics such as database administration, distributed databases, transaction management, access control, data security, integrity, privacy, and ethical aspects related to information systems. You will also be exposed to the limitations of structured data representation and analysis.
Learning Approaches
This unit is available for you to study in either on-campus or online mode.The unit engages you in a theory-to-practice approach to active learning in on-campus or online collaborative learning spaces. Collaborative learning spaces can include Breakout rooms in Zoom or Canvas Collaborate or on-campus collaborative learning classrooms.
The unit adopts a blended learning approach which includes:
- Pre-Recorded Lectures: Where new theoretical and technical concepts will be explained in detail in the context of worked examples.
- Tutorials: Where you will practice and further explore each topic as well as complete related practical activities with other students. These sessions will also be used to reflect on assessment tasks and provide formative feedback to students.
- Lectorials: One brief online video that summarises the week's content and discussed in class.
- Readings: You will also be provided with textbook readings in most weeks which you are expected to complete. You will have the opportunity to reflect on your learning and progress in the tutorials and through the portfolio assessment item.
Feedback on Learning and Assessment
Feedback in this unit is provided to you in the following ways:
- A range of formative exercises will be discussed in tutorials;
- Comments and feedback on your portfolio submissions;
- Generic comments made to the cohort using QUT Canvas and Facebook;
- Feedback and collaboration with peers.
Questions about the unit should be directed to the unit teaching staff.
Assessment
Overview
Progressive portfolio submissions are designed to help you guide and reflect on your learning progress and give you the ability to demonstrate the acquisition of the skills throughout the unit. They also provide you with an opportunity to test your skills before the final exam, and receive immediate feedback on your performance. The project assessment task will examine your ability to use the knowledge gained in this unit, as well as prior knowledge and experience, to respond to a real-world problem. The written examination will allow you to demonstrate your understanding of all content covered in the unit.
Unit Grading Scheme
7- point scale
Assessment Tasks
Assessment: Take Home Exam - 1
This assessment consists of exercises using examples both in and out of class strategically timed to optimise your learning. These exercises cover the core operational knowledge and skills of the unit and provide you with an opportunity to critically reflect on the skills you have learnt in the unit. Further details on how the task is divided will be posted on Canvas.
Assessment: Take Home Exam - 2
This assessment consists of exercises using examples both in and out of class strategically timed to optimise your learning. These exercises cover the core operational knowledge and skills of the unit and provide you with an opportunity to critically reflect on the skills you have learnt in the unit. Further details on how the task is divided will be posted on Canvas.
Assessment: Project (Applied)
Project based on contemporary and authentic industry examples
The project is a practical task that will require you to develop a solution to a real world use case and reflect on the data management requirements of an organisation. The submission is divided into two parts due at different times during the semester.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
Assessment: Online Ethics Module Part 1
In this self contained online Ethics module (Part 1) you will learn about the Australian Computer Society's Code of Professional Conduct and how it is applied in the workplace. You will then need to pass an online quiz to test your knowledge of the topics covered. You must pass the quiz in order to pass this unit, however you may attempt the quiz an unlimited number of times until you pass.
Threshold Assessment:
As an IT professional you will be legally bound by a code of ethics and professional conduct. Knowledge of these codes is therefore essential for all IT graduates. You must pass this Online Ethics Module in order to pass this unit, i.e. regardless of how well you do in the other assessment items, you cannot pass this unit if you fail this assessment item. You may however attempt this assessment items an unlimited number of times until you pass.
Academic Integrity
Academic integrity is a commitment to undertaking academic work and assessment in a manner that is ethical, fair, honest, respectful and accountable.
The Academic Integrity Policy sets out the range of conduct that can be a failure to maintain the standards of academic integrity. This includes, cheating in exams, plagiarism, self-plagiarism, collusion and contract cheating. It also includes providing fraudulent or altered documentation in support of an academic concession application, for example an assignment extension or a deferred exam.
You are encouraged to make use of QUT’s learning support services, resources and tools to assure the academic integrity of your assessment. This includes the use of text matching software that may be available to assist with self-assessing your academic integrity as part of the assessment submission process.
Breaching QUT’s Academic Integrity Policy or engaging in conduct that may defeat or compromise the purpose of assessment can lead to a finding of student misconduct (Code of Conduct – Student) and result in the imposition of penalties under the Management of Student Misconduct Policy, ranging from a grade reduction to exclusion from QUT.
Resources
Risk Assessment Statement
All commencing SEF students are required to complete the Mandatory Safety Induction
There are no extraordinary risks associated with the classroom/lecture activities in this unit.
Standards/Competencies
This unit is designed to support your development of the following standards\competencies.
Australian Computer Society Core Body of Knowledge
1: ICT Professional Knowledge
- Ethics
Relates to: ULO6, Online Ethics Module Part 1 - Professional expectations
Relates to: ULO6 - Social issues/legal issues/privacy
Relates to: ULO5
3: Technology Resources
Engineers Australia Stage 1 Competency Standard for Professional Engineer
1: Knowledge and Skill Base
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied)
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied)
Relates to: Project (Applied)
Relates to: Project (Applied), Online Ethics Module Part 1
2: Engineering Application Ability
Relates to: Project (Applied)
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied)
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied)
3: Professional and Personal Attributes
Relates to: Project (Applied), Online Ethics Module Part 1
Relates to: Project (Applied)
Course Learning Outcomes
This unit is designed to support your development of the following course/study area learning outcomes.IN01 Bachelor of Information Technology
- Demonstrate well-developed IT discipline knowledge
Relates to: ULO4, Take Home Exam - 2, Project (Applied) - Employ appropriate IT Methods
Relates to: ULO3, Take Home Exam - 1 , Project (Applied) - Critically apply design and problem solving skills
Relates to: ULO2, Take Home Exam - 2, Project (Applied) - Purposefully appraise personal values, attitudes and performance in your continuing professional development
Relates to: ULO5, ULO6, Take Home Exam - 2, Project (Applied), Online Ethics Module Part 1 - Communicate effectively in professional contexts
Relates to: ULO1, Take Home Exam - 1 , Project (Applied)
PU51 Bachelor of Health Information Management
- Critically evaluate and apply theoretical and technical perspectives on health information management (HIM), applicable to professional practice to solve routine and emergent problems. [Knowledge, Practice]
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied) - Initiate effective approaches for engaging in critical thinking, decision making and problem solving that reflect diverse perspectives and culturally safe and responsive practice, encompassing evidence-based HIM solutions. [Practice, Values/Disposition
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied) - Employ digital capabilities in accessing, evaluating, utilising and communicating digital health information across a range of stakeholders, and intra- and inter-professional contexts that demonstrate independence, accountability, creativity and initiative as a HIM professional. [Practice, Values/Disposition]
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied) - Exercise judgement in the context of HIM, informed by sustainable, legal, ethical, and professional perspectives that promote social inclusivity, multidisciplinary collaboration and reflective practice. [Values/Disposition, Knowledge, Practice]
Relates to: Project (Applied) - Reflect critically on performance and feedback to identify self improvements and action learning opportunities, while building productive professional relationships across diverse stakeholders. [Practice, Values/Disposition]
Relates to: Take Home Exam - 1 , Take Home Exam - 2
Unit Outline: Semester 1 2025, Online
| Unit code: | IFB105 |
|---|---|
| Credit points: | 12 |
| Equivalent: | IFB130 |
| Equivalent: | ITD105 |
| Assumed Knowledge: | For PU51 students, PUB110 is the assumed knowledge for IFB105. |
Overview
This is an introductory unit on database addressing the core concepts, requirements and practices of databases. It introduces conceptual data modeling to address a key area of concern of modeling structured data to build a comprehensive understanding of the data aspect of a problem. You will learn how to transform such data model into a relational database design as well as how to effectively retrieve data through SQL queries. Normalization, database security/administration, other special topics and ethical aspects related to information systems are also covered. IAB207 Rapid Web App Development, IAB303 Data Analytics for Business Insights and the Capstone units IFB398 Capstone 1 and IFB399 Capstone 2 build on this unit for data storage/retrieval and business insights. IAB206 Modern Data Management extends this unit earning to unstructured data such as graphs and documents which are also gaining popularity in the real world.
Learning Outcomes
On successful completion of this unit you will be able to:
- Create a conceptual schema to model information in a domain.
- Construct SQL commands to store, retrieve and manipulate data in a relational database.
- Translate a conceptual schema into a relational database schema design.
- Normalise a relational database schema to improve data integrity.
- Analyse the social impacts, privacy and legal issues associated with managing data.
- Apply ethical fundamentals, including the ACS Code of Ethics and Professional Conduct to industry scenarios.
Content
The content of this unit is split into three modules:
1. Conceptual Data Modelling: In this module you will understand data aspects of an information system to develop a conceptual data model using Object Role Modelling (ORM) technique and then translate conceptual data model to relational database schema.
2. Database Development and Managment: In this module you will learn to i) create and modify a database schema; ii) retrieve database content through SQL query formulation and iii) generate ethical and culturally sensitive solutions to data management problems.
3. Special Topics: The final module is structured in a way to allow you to contextualise the knowledge and skills taught in earlier modules within a specific industry context. You will explore topics such as database administration, distributed databases, transaction management, access control, data security, integrity, privacy, and ethical aspects related to information systems. You will also be exposed to the limitations of structured data representation and analysis.
Learning Approaches
This unit is available for you to study in either on-campus or online mode.The unit engages you in a theory-to-practice approach to active learning in on-campus or online collaborative learning spaces. Collaborative learning spaces can include Breakout rooms in Zoom or Canvas Collaborate or on-campus collaborative learning classrooms.
The unit adopts a blended learning approach which includes:
- Pre-Recorded Lectures: Where new theoretical and technical concepts will be explained in detail in the context of worked examples.
- Tutorials: Where you will practice and further explore each topic as well as complete related practical activities with other students. These sessions will also be used to reflect on assessment tasks and provide formative feedback to students.
- Lectorials: One brief online video that summarises the week's content and discussed in class.
- Readings: You will also be provided with textbook readings in most weeks which you are expected to complete. You will have the opportunity to reflect on your learning and progress in the tutorials and through the portfolio assessment item.
Feedback on Learning and Assessment
Feedback in this unit is provided to you in the following ways:
- A range of formative exercises will be discussed in tutorials;
- Comments and feedback on your portfolio submissions;
- Generic comments made to the cohort using QUT Canvas and Facebook;
- Feedback and collaboration with peers.
Questions about the unit should be directed to the unit teaching staff.
Assessment
Overview
Progressive portfolio submissions are designed to help you guide and reflect on your learning progress and give you the ability to demonstrate the acquisition of the skills throughout the unit. They also provide you with an opportunity to test your skills before the final exam, and receive immediate feedback on your performance. The project assessment task will examine your ability to use the knowledge gained in this unit, as well as prior knowledge and experience, to respond to a real-world problem. The written examination will allow you to demonstrate your understanding of all content covered in the unit.
Unit Grading Scheme
7- point scale
Assessment Tasks
Assessment: Take Home Exam - 1
This assessment consists of exercises using examples both in and out of class strategically timed to optimise your learning. These exercises cover the core operational knowledge and skills of the unit and provide you with an opportunity to critically reflect on the skills you have learnt in the unit. Further details on how the task is divided will be posted on Canvas.
Assessment: Take Home Exam - 2
This assessment consists of exercises using examples both in and out of class strategically timed to optimise your learning. These exercises cover the core operational knowledge and skills of the unit and provide you with an opportunity to critically reflect on the skills you have learnt in the unit. Further details on how the task is divided will be posted on Canvas.
Assessment: Project (Applied)
Project based on contemporary and authentic industry examples
The project is a practical task that will require you to develop a solution to a real world use case and reflect on the data management requirements of an organisation. The submission is divided into two parts due at different times during the semester.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
Assessment: Online Ethics Module Part 1
In this self contained online Ethics module (Part 1) you will learn about the Australian Computer Society's Code of Professional Conduct and how it is applied in the workplace. You will then need to pass an online quiz to test your knowledge of the topics covered. You must pass the quiz in order to pass this unit, however you may attempt the quiz an unlimited number of times until you pass.
Threshold Assessment:
As an IT professional you will be legally bound by a code of ethics and professional conduct. Knowledge of these codes is therefore essential for all IT graduates. You must pass this Online Ethics Module in order to pass this unit, i.e. regardless of how well you do in the other assessment items, you cannot pass this unit if you fail this assessment item. You may however attempt this assessment items an unlimited number of times until you pass.
Academic Integrity
Academic integrity is a commitment to undertaking academic work and assessment in a manner that is ethical, fair, honest, respectful and accountable.
The Academic Integrity Policy sets out the range of conduct that can be a failure to maintain the standards of academic integrity. This includes, cheating in exams, plagiarism, self-plagiarism, collusion and contract cheating. It also includes providing fraudulent or altered documentation in support of an academic concession application, for example an assignment extension or a deferred exam.
You are encouraged to make use of QUT’s learning support services, resources and tools to assure the academic integrity of your assessment. This includes the use of text matching software that may be available to assist with self-assessing your academic integrity as part of the assessment submission process.
Breaching QUT’s Academic Integrity Policy or engaging in conduct that may defeat or compromise the purpose of assessment can lead to a finding of student misconduct (Code of Conduct – Student) and result in the imposition of penalties under the Management of Student Misconduct Policy, ranging from a grade reduction to exclusion from QUT.
Resources
Risk Assessment Statement
All commencing SEF students are required to complete the Mandatory Safety Induction
There are no extraordinary risks associated with the classroom/lecture activities in this unit.
Standards/Competencies
This unit is designed to support your development of the following standards\competencies.
Australian Computer Society Core Body of Knowledge
1: ICT Professional Knowledge
- Ethics
Relates to: ULO6, Online Ethics Module Part 1 - Professional expectations
Relates to: ULO6 - Social issues/legal issues/privacy
Relates to: ULO5
3: Technology Resources
Engineers Australia Stage 1 Competency Standard for Professional Engineer
1: Knowledge and Skill Base
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied)
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied)
Relates to: Project (Applied)
Relates to: Project (Applied), Online Ethics Module Part 1
2: Engineering Application Ability
Relates to: Project (Applied)
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied)
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied)
3: Professional and Personal Attributes
Relates to: Project (Applied), Online Ethics Module Part 1
Relates to: Project (Applied)
Course Learning Outcomes
This unit is designed to support your development of the following course/study area learning outcomes.IN01 Bachelor of Information Technology
- Demonstrate well-developed IT discipline knowledge
Relates to: ULO4, Take Home Exam - 2, Project (Applied) - Employ appropriate IT Methods
Relates to: ULO3, Take Home Exam - 1 , Project (Applied) - Critically apply design and problem solving skills
Relates to: ULO2, Take Home Exam - 2, Project (Applied) - Purposefully appraise personal values, attitudes and performance in your continuing professional development
Relates to: ULO5, ULO6, Take Home Exam - 2, Project (Applied), Online Ethics Module Part 1 - Communicate effectively in professional contexts
Relates to: ULO1, Take Home Exam - 1 , Project (Applied)
PU51 Bachelor of Health Information Management
- Critically evaluate and apply theoretical and technical perspectives on health information management (HIM), applicable to professional practice to solve routine and emergent problems. [Knowledge, Practice]
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied) - Initiate effective approaches for engaging in critical thinking, decision making and problem solving that reflect diverse perspectives and culturally safe and responsive practice, encompassing evidence-based HIM solutions. [Practice, Values/Disposition
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied) - Employ digital capabilities in accessing, evaluating, utilising and communicating digital health information across a range of stakeholders, and intra- and inter-professional contexts that demonstrate independence, accountability, creativity and initiative as a HIM professional. [Practice, Values/Disposition]
Relates to: Take Home Exam - 1 , Take Home Exam - 2, Project (Applied) - Exercise judgement in the context of HIM, informed by sustainable, legal, ethical, and professional perspectives that promote social inclusivity, multidisciplinary collaboration and reflective practice. [Values/Disposition, Knowledge, Practice]
Relates to: Project (Applied) - Reflect critically on performance and feedback to identify self improvements and action learning opportunities, while building productive professional relationships across diverse stakeholders. [Practice, Values/Disposition]
Relates to: Take Home Exam - 1 , Take Home Exam - 2
Unit Outline: Semester 2 2025, Gardens Point, Internal
| Unit code: | IFB105 |
|---|---|
| Credit points: | 12 |
| Equivalent: | IFB130 |
| Equivalent: | ITD105 |
| Assumed Knowledge: | For PU51 students, PUB110 is the assumed knowledge for IFB105. |
| Coordinators: | Mark Walpole | m.walpole@qut.edu.au Gowri Ramachandran | g.ramachandran@qut.edu.au Mythreyi Velmurugan | m.velmurugan@qut.edu.au |
Overview
This is an introductory unit on database addressing the core concepts, requirements and practices of databases. It introduces conceptual data modeling to address a key area of concern of modeling structured data to build a comprehensive understanding of the data aspect of a problem. You will learn how to transform such data model into a relational database design as well as how to effectively retrieve data through SQL queries. Normalization, database security/administration, other special topics and ethical aspects related to information systems are also covered. IAB207 Rapid Web App Development, IAB303 Data Analytics for Business Insights and the Capstone units IFB398 Capstone 1 and IFB399 Capstone 2 build on this unit for data storage/retrieval and business insights. IAB206 Modern Data Management extends this unit earning to unstructured data such as graphs and documents which are also gaining popularity in the real world.
Learning Outcomes
On successful completion of this unit you will be able to:
- Create a conceptual schema to model information in a domain.
- Construct SQL commands to store, retrieve and manipulate data in a relational database.
- Translate a conceptual schema into a relational database schema design.
- Normalise a relational database schema to improve data integrity.
- Analyse the social impacts, privacy and legal issues associated with managing data.
- Apply ethical fundamentals, including the ACS Code of Ethics and Professional Conduct to industry scenarios.
Content
The content of this unit is split into three modules:
1. Conceptual Data Modelling: In this module you will understand data aspects of an information system to develop a conceptual data model showing the relationships between objects in a domain and then translate conceptual data model to relational database schema.
2. Database Development and Managment: In this module you will learn to i) create and modify a database schema; ii) retrieve database content through SQL query formulation and iii) generate ethical and culturally sensitive solutions to data management problems.
3. Special Topics: The final module is structured in a way to allow you to contextualise the knowledge and skills taught in earlier modules within a specific industry context. You will explore topics such as database administration, distributed databases, transaction management, access control, data security, integrity, privacy, and ethical aspects related to information systems. You will also be exposed to the limitations of structured data representation and analysis.
Learning Approaches
This unit is available for you to study in either on-campus or online mode.The unit engages you in a theory-to-practice approach to active learning in on-campus or online collaborative learning spaces. Collaborative learning spaces can include Breakout rooms in Zoom or Canvas Collaborate or on-campus collaborative learning classrooms.
The unit adopts a blended learning approach which includes:
- Pre-Recorded Lectures: Where new theoretical and technical concepts will be explained in detail in the context of worked examples.
- Tutorials: Where you will practice and further explore each topic as well as complete related practical activities with other students. These sessions will also be used to reflect on assessment tasks and provide formative feedback to students.
- Lectorials: One brief online video that summarises the week's content and discussed in class.
- Readings: You will also be provided with textbook readings in most weeks which you are expected to complete. You will have the opportunity to reflect on your learning and progress in the tutorials and through the portfolio assessment item.
Feedback on Learning and Assessment
Feedback in this unit is provided to you in the following ways:
- A range of formative exercises will be discussed in tutorials;
- Comments and feedback on your portfolio submissions;
- Generic comments made to the cohort using QUT Canvas and Facebook;
- Feedback and collaboration with peers.
Questions about the unit should be directed to the unit teaching staff.
Assessment
Overview
This unit includes applied projects on designing and implementing databases, to give you the ability to demonstrate the acquisition of the skills throughout the unit. They also provide you with an opportunity to test your skills before the final exam, and receive feedback on your performance. The project assessment task will examine your ability to use the knowledge gained in this unit, as well as prior knowledge and experience, to respond to a real-world problem. The written examination will allow you to demonstrate your understanding of all content covered in the unit.
Unit Grading Scheme
7- point scale
Assessment Tasks
Assessment: Conceptual Design of Databases
Project based on contemporary and authentic industry examples. The project is a practical task that will require you to design a solution to a real world use case and reflect on the data management requirements of an organisation.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
Assessment: Database Development
Project based on contemporary and authentic industry examples. The project is a practical task that will require you to develop a solution to a real world use case and reflect on the data management requirements of an organisation. You will also be required to take part in a short, live interview to demonstrate your solution to the assessment task.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
Assessment: Final Exam
An exam consisting of several MCQs, as well as short answer questions on analysing and producing solutions for problem-solving tasks or case scenarios.
Assessment: Online Ethics Module Part 1
In this self contained online Ethics module (Part 1) you will learn about the Australian Computer Society's Code of Professional Conduct and how it is applied in the workplace. You will then need to pass an online quiz to test your knowledge of the topics covered. You must pass the quiz in order to pass this unit, however you may attempt the quiz an unlimited number of times until you pass.
Threshold Assessment:
As an IT professional you will be legally bound by a code of ethics and professional conduct. Knowledge of these codes is therefore essential for all IT graduates. You must pass this Online Ethics Module in order to pass this unit, i.e. regardless of how well you do in the other assessment items, you cannot pass this unit if you fail this assessment item. You may however attempt this assessment items an unlimited number of times until you pass.
Academic Integrity
Academic integrity is a commitment to undertaking academic work and assessment in a manner that is ethical, fair, honest, respectful and accountable.
The Academic Integrity Policy sets out the range of conduct that can be a failure to maintain the standards of academic integrity. This includes, cheating in exams, plagiarism, self-plagiarism, collusion and contract cheating. It also includes providing fraudulent or altered documentation in support of an academic concession application, for example an assignment extension or a deferred exam.
You are encouraged to make use of QUT’s learning support services, resources and tools to assure the academic integrity of your assessment. This includes the use of text matching software that may be available to assist with self-assessing your academic integrity as part of the assessment submission process.
Breaching QUT’s Academic Integrity Policy or engaging in conduct that may defeat or compromise the purpose of assessment can lead to a finding of student misconduct (Code of Conduct – Student) and result in the imposition of penalties under the Management of Student Misconduct Policy, ranging from a grade reduction to exclusion from QUT.
Resources
This unit makes use of the textbook listed below and a comprehensive Canvas site that provides access to a range of additional resources to support your learning in this unit.
Resource Materials
Recommended text(s)
Halpin, T. & Morgan, T. (2024). Information Modeling and Relational Databases, 3rd edition. Cambridge: Morgan Kaufmann
Risk Assessment Statement
All commencing SEF students are required to complete the Mandatory Safety Induction
There are no extraordinary risks associated with the classroom/lecture activities in this unit.
Standards/Competencies
This unit is designed to support your development of the following standards\competencies.
Australian Computer Society Core Body of Knowledge
1: ICT Professional Knowledge
- Ethics
Relates to: ULO6, Online Ethics Module Part 1 - Professional expectations
Relates to: ULO6 - Social issues/legal issues/privacy
Relates to: ULO5
3: Technology Resources
Engineers Australia Stage 1 Competency Standard for Professional Engineer
1: Knowledge and Skill Base
Relates to: Conceptual Design of Databases, Database Development, Final Exam
Relates to: Conceptual Design of Databases, Database Development, Final Exam
Relates to: Final Exam
Relates to: Final Exam, Online Ethics Module Part 1
2: Engineering Application Ability
Relates to: Final Exam
Relates to: Conceptual Design of Databases, Database Development, Final Exam
Relates to: Conceptual Design of Databases, Database Development, Final Exam
3: Professional and Personal Attributes
Relates to: Final Exam, Online Ethics Module Part 1
Relates to: Final Exam
Course Learning Outcomes
This unit is designed to support your development of the following course/study area learning outcomes.IN01 Bachelor of Information Technology
- Demonstrate well-developed IT discipline knowledge
Relates to: ULO4, Database Development, Final Exam - Employ appropriate IT Methods
Relates to: ULO3, Conceptual Design of Databases, Final Exam - Critically apply design and problem solving skills
Relates to: ULO2, Database Development, Final Exam - Purposefully appraise personal values, attitudes and performance in your continuing professional development
Relates to: ULO5, ULO6, Database Development, Final Exam, Online Ethics Module Part 1 - Communicate effectively in professional contexts
Relates to: ULO1, Conceptual Design of Databases, Final Exam
PU51 Bachelor of Health Information Management
- Critically evaluate and apply theoretical and technical perspectives on health information management (HIM), applicable to professional practice to solve routine and emergent problems. [Knowledge, Practice]
Relates to: Conceptual Design of Databases, Database Development, Final Exam - Initiate effective approaches for engaging in critical thinking, decision making and problem solving that reflect diverse perspectives and culturally safe and responsive practice, encompassing evidence-based HIM solutions. [Practice, Values/Disposition
Relates to: Conceptual Design of Databases, Database Development, Final Exam - Employ digital capabilities in accessing, evaluating, utilising and communicating digital health information across a range of stakeholders, and intra- and inter-professional contexts that demonstrate independence, accountability, creativity and initiative as a HIM professional. [Practice, Values/Disposition]
Relates to: Conceptual Design of Databases, Database Development, Final Exam - Exercise judgement in the context of HIM, informed by sustainable, legal, ethical, and professional perspectives that promote social inclusivity, multidisciplinary collaboration and reflective practice. [Values/Disposition, Knowledge, Practice]
Relates to: Final Exam - Reflect critically on performance and feedback to identify self improvements and action learning opportunities, while building productive professional relationships across diverse stakeholders. [Practice, Values/Disposition]
Relates to: Conceptual Design of Databases, Database Development
Unit Outline: Semester 2 2025, Online
| Unit code: | IFB105 |
|---|---|
| Credit points: | 12 |
| Equivalent: | IFB130 |
| Equivalent: | ITD105 |
| Assumed Knowledge: | For PU51 students, PUB110 is the assumed knowledge for IFB105. |
Overview
This is an introductory unit on database addressing the core concepts, requirements and practices of databases. It introduces conceptual data modeling to address a key area of concern of modeling structured data to build a comprehensive understanding of the data aspect of a problem. You will learn how to transform such data model into a relational database design as well as how to effectively retrieve data through SQL queries. Normalization, database security/administration, other special topics and ethical aspects related to information systems are also covered. IAB207 Rapid Web App Development, IAB303 Data Analytics for Business Insights and the Capstone units IFB398 Capstone 1 and IFB399 Capstone 2 build on this unit for data storage/retrieval and business insights. IAB206 Modern Data Management extends this unit earning to unstructured data such as graphs and documents which are also gaining popularity in the real world.
Learning Outcomes
On successful completion of this unit you will be able to:
- Create a conceptual schema to model information in a domain.
- Construct SQL commands to store, retrieve and manipulate data in a relational database.
- Translate a conceptual schema into a relational database schema design.
- Normalise a relational database schema to improve data integrity.
- Analyse the social impacts, privacy and legal issues associated with managing data.
- Apply ethical fundamentals, including the ACS Code of Ethics and Professional Conduct to industry scenarios.
Content
The content of this unit is split into three modules:
1. Conceptual Data Modelling: In this module you will understand data aspects of an information system to develop a conceptual data model showing the relationships between objects in a domain and then translate conceptual data model to relational database schema.
2. Database Development and Managment: In this module you will learn to i) create and modify a database schema; ii) retrieve database content through SQL query formulation and iii) generate ethical and culturally sensitive solutions to data management problems.
3. Special Topics: The final module is structured in a way to allow you to contextualise the knowledge and skills taught in earlier modules within a specific industry context. You will explore topics such as database administration, distributed databases, transaction management, access control, data security, integrity, privacy, and ethical aspects related to information systems. You will also be exposed to the limitations of structured data representation and analysis.
Learning Approaches
This unit is available for you to study in either on-campus or online mode.The unit engages you in a theory-to-practice approach to active learning in on-campus or online collaborative learning spaces. Collaborative learning spaces can include Breakout rooms in Zoom or Canvas Collaborate or on-campus collaborative learning classrooms.
The unit adopts a blended learning approach which includes:
- Pre-Recorded Lectures: Where new theoretical and technical concepts will be explained in detail in the context of worked examples.
- Tutorials: Where you will practice and further explore each topic as well as complete related practical activities with other students. These sessions will also be used to reflect on assessment tasks and provide formative feedback to students.
- Lectorials: One brief online video that summarises the week's content and discussed in class.
- Readings: You will also be provided with textbook readings in most weeks which you are expected to complete. You will have the opportunity to reflect on your learning and progress in the tutorials and through the portfolio assessment item.
Feedback on Learning and Assessment
Feedback in this unit is provided to you in the following ways:
- A range of formative exercises will be discussed in tutorials;
- Comments and feedback on your portfolio submissions;
- Generic comments made to the cohort using QUT Canvas and Facebook;
- Feedback and collaboration with peers.
Questions about the unit should be directed to the unit teaching staff.
Assessment
Overview
This unit includes applied projects on designing and implementing databases, to give you the ability to demonstrate the acquisition of the skills throughout the unit. They also provide you with an opportunity to test your skills before the final exam, and receive feedback on your performance. The project assessment task will examine your ability to use the knowledge gained in this unit, as well as prior knowledge and experience, to respond to a real-world problem. The written examination will allow you to demonstrate your understanding of all content covered in the unit.
Unit Grading Scheme
7- point scale
Assessment Tasks
Assessment: Conceptual Design of Databases
Project based on contemporary and authentic industry examples. The project is a practical task that will require you to design a solution to a real world use case and reflect on the data management requirements of an organisation.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
Assessment: Database Development
Project based on contemporary and authentic industry examples. The project is a practical task that will require you to develop a solution to a real world use case and reflect on the data management requirements of an organisation. You will also be required to take part in a short, live interview to demonstrate your solution to the assessment task.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
Assessment: Final Exam
An exam consisting of several MCQs, as well as short answer questions on analysing and producing solutions for problem-solving tasks or case scenarios.
Assessment: Online Ethics Module Part 1
In this self contained online Ethics module (Part 1) you will learn about the Australian Computer Society's Code of Professional Conduct and how it is applied in the workplace. You will then need to pass an online quiz to test your knowledge of the topics covered. You must pass the quiz in order to pass this unit, however you may attempt the quiz an unlimited number of times until you pass.
Threshold Assessment:
As an IT professional you will be legally bound by a code of ethics and professional conduct. Knowledge of these codes is therefore essential for all IT graduates. You must pass this Online Ethics Module in order to pass this unit, i.e. regardless of how well you do in the other assessment items, you cannot pass this unit if you fail this assessment item. You may however attempt this assessment items an unlimited number of times until you pass.
Academic Integrity
Academic integrity is a commitment to undertaking academic work and assessment in a manner that is ethical, fair, honest, respectful and accountable.
The Academic Integrity Policy sets out the range of conduct that can be a failure to maintain the standards of academic integrity. This includes, cheating in exams, plagiarism, self-plagiarism, collusion and contract cheating. It also includes providing fraudulent or altered documentation in support of an academic concession application, for example an assignment extension or a deferred exam.
You are encouraged to make use of QUT’s learning support services, resources and tools to assure the academic integrity of your assessment. This includes the use of text matching software that may be available to assist with self-assessing your academic integrity as part of the assessment submission process.
Breaching QUT’s Academic Integrity Policy or engaging in conduct that may defeat or compromise the purpose of assessment can lead to a finding of student misconduct (Code of Conduct – Student) and result in the imposition of penalties under the Management of Student Misconduct Policy, ranging from a grade reduction to exclusion from QUT.
Resources
This unit makes use of the textbook listed below and a comprehensive Canvas site that provides access to a range of additional resources to support your learning in this unit.
Resource Materials
Recommended text(s)
Halpin, T. & Morgan, T. (2024). Information Modeling and Relational Databases, 3rd edition. Cambridge: Morgan Kaufmann
Risk Assessment Statement
All commencing SEF students are required to complete the Mandatory Safety Induction
There are no extraordinary risks associated with the classroom/lecture activities in this unit.
Standards/Competencies
This unit is designed to support your development of the following standards\competencies.
Australian Computer Society Core Body of Knowledge
1: ICT Professional Knowledge
- Ethics
Relates to: ULO6, Online Ethics Module Part 1 - Professional expectations
Relates to: ULO6 - Social issues/legal issues/privacy
Relates to: ULO5
3: Technology Resources
Engineers Australia Stage 1 Competency Standard for Professional Engineer
1: Knowledge and Skill Base
Relates to: Conceptual Design of Databases, Database Development, Final Exam
Relates to: Conceptual Design of Databases, Database Development, Final Exam
Relates to: Final Exam
Relates to: Final Exam, Online Ethics Module Part 1
2: Engineering Application Ability
Relates to: Final Exam
Relates to: Conceptual Design of Databases, Database Development, Final Exam
Relates to: Conceptual Design of Databases, Database Development, Final Exam
3: Professional and Personal Attributes
Relates to: Final Exam, Online Ethics Module Part 1
Relates to: Final Exam
Course Learning Outcomes
This unit is designed to support your development of the following course/study area learning outcomes.IN01 Bachelor of Information Technology
- Demonstrate well-developed IT discipline knowledge
Relates to: ULO4, Database Development, Final Exam - Employ appropriate IT Methods
Relates to: ULO3, Conceptual Design of Databases, Final Exam - Critically apply design and problem solving skills
Relates to: ULO2, Database Development, Final Exam - Purposefully appraise personal values, attitudes and performance in your continuing professional development
Relates to: ULO5, ULO6, Database Development, Final Exam, Online Ethics Module Part 1 - Communicate effectively in professional contexts
Relates to: ULO1, Conceptual Design of Databases, Final Exam
PU51 Bachelor of Health Information Management
- Critically evaluate and apply theoretical and technical perspectives on health information management (HIM), applicable to professional practice to solve routine and emergent problems. [Knowledge, Practice]
Relates to: Conceptual Design of Databases, Database Development, Final Exam - Initiate effective approaches for engaging in critical thinking, decision making and problem solving that reflect diverse perspectives and culturally safe and responsive practice, encompassing evidence-based HIM solutions. [Practice, Values/Disposition
Relates to: Conceptual Design of Databases, Database Development, Final Exam - Employ digital capabilities in accessing, evaluating, utilising and communicating digital health information across a range of stakeholders, and intra- and inter-professional contexts that demonstrate independence, accountability, creativity and initiative as a HIM professional. [Practice, Values/Disposition]
Relates to: Conceptual Design of Databases, Database Development, Final Exam - Exercise judgement in the context of HIM, informed by sustainable, legal, ethical, and professional perspectives that promote social inclusivity, multidisciplinary collaboration and reflective practice. [Values/Disposition, Knowledge, Practice]
Relates to: Final Exam - Reflect critically on performance and feedback to identify self improvements and action learning opportunities, while building productive professional relationships across diverse stakeholders. [Practice, Values/Disposition]
Relates to: Conceptual Design of Databases, Database Development