ITD105 Database Management

Unit Outline: College 1 2026, Kelvin Grove, Internal

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 (Structured Query Language) queries. Normalization, database security/administration, other special topics and ethical aspects related to information systems are also covered.

Learning Outcomes

On successful completion of this unit you will be able to:

1. Create a conceptual schema to model information in a domain.
2. Construct SQL commands to store, retrieve and manipulate data in a relational database.
3. Translate a conceptual schema into a relational database schema design.
4. Normalise a relational database schema to improve data integrity.
5. Analyse the social impacts, privacy and legal issues associated with managing data.
6. Apply ethical fundamentals, including the ACS Code of Ethics and Professional Conduct to industry scenarios.

Content

Learning Approaches

This unit takes a blended approach to learning and teaching. You will be provided with both eContent and timetabled activities such as tutorials, workshops and practicals. eContent will be clearly identified on your Canvas site for you to engage with on a weekly basis before your classes. eContent could include videos, readings, self-reflection and/or peer activities designed to enhance your learning experience. During the timetabled activities, the unit coordinator and/or your tutor will further explain content and you will be provided with opportunities to explore this content in a collaborative learning environment. After your weekly classes, you should continue to engage with unit resources to ensure you consolidate your understanding of unit content. Teaching team members will also be available for one-on-one consultations to assist you with your learning journey.

Feedback on Learning and Assessment

Students will receive feedback in various forms throughout the semester which may include:
• Informal: worked examples, such as verbal feedback in class, personal consultation
• Formal: in writing, such as checklists, rubrics, written commentary
• Direct: to individual students, either in written form or in consultation
• Indirect: to the whole class

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.

NOTE: Modification to assessment may be required based on mode of study.

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 is an assignment for the purposes of an extension.

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 students are required to complete the Mandatory Safety Induction

There are no extraordinary risks associated with the classroom/lecture activities in this unit.

Course Learning Outcomes

ES21 Diploma in Esports

1. Demonstrate foundational interdisciplinary knowledge relating to esports.
   Relates to: ULO1, Take Home Exam - 1, Take Home Exam - 2
2. Apply critical thinking and problem solving skills.
   Relates to: Project (applied)
3. Communicate effectively in an academic and professional manner through written and oral genres integrating digital tools.
   Relates to: Project (applied)
4. Apply teamwork knowledge and skills for effective collaboration.
   Relates to: Project (applied)
5. Apply knowledge of ethical and social practices in analysing and addressing real world problems and issues.
   Relates to: ULO5, ULO6, Online Ethics Module Part 1

IT10 Diploma in Information Technology

1. Demonstrate IT discipline knowledge
   Relates to: Take Home Exam - 1, Take Home Exam - 2
2. Employ introductory IT methods
   Relates to: Take Home Exam - 2
3. Critically apply design and problem solving skills
   Relates to: Take Home Exam - 1, Project (applied)
4. Communicate effectively in academic contexts
   Relates to: Project (applied)
5. Understand personal values, attitudes and performance in your continuing professional development
   Relates to: Online Ethics Module Part 1
6. Create considered and relevant IT solutions
   Relates to: Take Home Exam - 2

Unit Outline: College 2 2026, Kelvin Grove, Internal

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 (Structured Query Language) queries. Normalization, database security/administration, other special topics and ethical aspects related to information systems are also covered.

Learning Outcomes

On successful completion of this unit you will be able to:

1. Create a conceptual schema to model information in a domain.
2. Construct SQL commands to store, retrieve and manipulate data in a relational database.
3. Translate a conceptual schema into a relational database schema design.
4. Normalise a relational database schema to improve data integrity.
5. Analyse the social, privacy, and legal considerations in managing data, with emphasis on Aboriginal and Torres Strait Islander perspectives and respect for cultural beliefs.
6. Apply ethical fundamentals, including the ACS Code of Ethics and Professional Conduct to industry scenarios.

Content

Learning Approaches

This unit takes a blended approach to learning and teaching. You will be provided with both eContent and timetabled activities such as tutorials, workshops and practicals. eContent will be clearly identified on your Canvas site for you to engage with on a weekly basis before your classes. eContent could include videos, readings, self-reflection and/or peer activities designed to enhance your learning experience. During the timetabled activities, the unit coordinator and/or your tutor will further explain content and you will be provided with opportunities to explore this content in a collaborative learning environment. After your weekly classes, you should continue to engage with unit resources to ensure you consolidate your understanding of unit content. Teaching team members will also be available for one-on-one consultations to assist you with your learning journey.

Feedback on Learning and Assessment

Students will receive feedback in various forms throughout the semester which may include:
• Informal: worked examples, such as verbal feedback in class, personal consultation
• Formal: in writing, such as checklists, rubrics, written commentary
• Direct: to individual students, either in written form or in consultation
• Indirect: to the whole class

Assessment

Overview

Assessment in this unit includes applied projects on designing and implementing databases to provide you with the opportunity to demonstrate knowledge and skills acquired throughout the unit. The project task assesses your ability to apply knowledge gained in this unit to the development of a solution to a real-world problem. The final examination will assess your understanding of content addressed throughout the unit.

Unit Grading Scheme

7- point scale

Assessment Tasks

Assessment: Conceptual design of databases

This 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. 

The ethical and responsible use of generative artificial intelligence (GenAI) tools is authorised in this assessment. See the relevant assessment details in Canvas for specific guidelines.

This assignment is eligible for the 48-hour late submission period and assignment extensions.

Assessment: Database development

The project is a practical task that will require you to develop a solution to a real world scenario and reflect on the data management requirements of an organisation. 

The ethical and responsible use of generative artificial intelligence (GenAI) tools is authorised in this assessment. See the relevant assessment details in Canvas for specific guidelines.

This assignment is eligible for the 48-hour late submission period and assignment extensions.

Assessment: Final examination

This exam will include MCQs as well as written responses to questions on analysing and producing solutions for problem-solving tasks or case scenarios.

The use of generative artificial intelligence (GenAI) tools is prohibited during this assessment. 

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 students are required to complete the Mandatory Safety Induction

There are no extraordinary risks associated with the classroom/lecture activities in this unit.

Course Learning Outcomes

ES21 Diploma in Esports

1. Demonstrate foundational interdisciplinary knowledge relating to esports.
   Relates to: ULO1, Conceptual design of databases, Database development
2. Apply critical thinking and problem solving skills.
   Relates to: Final examination
3. Communicate effectively in an academic and professional manner through written and oral genres integrating digital tools.
   Relates to: Final examination
4. Apply teamwork knowledge and skills for effective collaboration.
   Relates to: Final examination
5. Apply knowledge of ethical and social practices in analysing and addressing real world problems and issues.
   Relates to: ULO5, ULO6, Online Ethics Module Part 1

IT10 Diploma in Information Technology

1. Demonstrate IT discipline knowledge
   Relates to: Conceptual design of databases, Database development, Final examination
2. Employ introductory IT methods
   Relates to: Database development, Final examination
3. Critically apply design and problem solving skills
   Relates to: Conceptual design of databases, Database development, Final examination
4. Communicate effectively in academic contexts
   Relates to: Final examination
5. Understand personal values, attitudes and performance in your continuing professional development
   Relates to: Online Ethics Module Part 1
6. Create considered and relevant IT solutions
   Relates to: Database development, Final examination