ITD105 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: | ITD105 |
---|---|
Equivalent(s): | IFB105 |
Credit points: | 12 |
Timetable | Details in HiQ, if available |
Availabilities |
|
CSP student contribution | $1,118 |
Domestic tuition unit fee | $4,104 |
International unit fee | $4,788 |
Unit Outline: College 1 2024, Kelvin Grove, Internal
Unit code: | ITD105 |
---|---|
Credit points: | 12 |
Equivalent: | IFB105 |
Coordinator: | Fariba Shadabi | fariba.shadabi@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 (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:
- 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 Management: 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 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
Students are expected to engage in learning and assessment at QUT with honesty, transparency and fairness. Maintaining academic integrity means upholding these principles and demonstrating valuable professional capabilities based on ethical foundations.
Failure to maintain academic integrity can take many forms. It includes cheating in examinations, plagiarism, self-plagiarism, collusion, and submitting an assessment item completed by another person (e.g. contract cheating). It can also include providing your assessment to another entity, such as to a person or website.
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.
Further details of QUT’s approach to academic integrity are outlined in the Academic integrity policy and the Student Code of Conduct. Breaching QUT’s Academic integrity policy is regarded as student misconduct and can lead to the imposition of penalties 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
This unit is designed to support your development of the following course/study area learning outcomes.ES21 Diploma in Esports
- Demonstrate foundational interdisciplinary knowledge relating to esports.
Relates to: ULO1, Take Home Exam - 1, Take Home Exam - 2 - Apply critical thinking and problem solving skills.
Relates to: Project (applied) - Communicate effectively in an academic and professional manner through written and oral genres integrating digital tools.
Relates to: Project (applied) - Apply teamwork knowledge and skills for effective collaboration.
Relates to: Project (applied) - 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
Unit Outline: College 2 2024, Kelvin Grove, Internal
Unit code: | ITD105 |
---|---|
Credit points: | 12 |
Equivalent: | IFB105 |
Coordinator: | Fariba Shadabi | fariba.shadabi@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 (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:
- 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 Management: 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 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
Students are expected to engage in learning and assessment at QUT with honesty, transparency and fairness. Maintaining academic integrity means upholding these principles and demonstrating valuable professional capabilities based on ethical foundations.
Failure to maintain academic integrity can take many forms. It includes cheating in examinations, plagiarism, self-plagiarism, collusion, and submitting an assessment item completed by another person (e.g. contract cheating). It can also include providing your assessment to another entity, such as to a person or website.
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.
Further details of QUT’s approach to academic integrity are outlined in the Academic integrity policy and the Student Code of Conduct. Breaching QUT’s Academic integrity policy is regarded as student misconduct and can lead to the imposition of penalties 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
This unit is designed to support your development of the following course/study area learning outcomes.ES21 Diploma in Esports
- Demonstrate foundational interdisciplinary knowledge relating to esports.
Relates to: ULO1, Take Home Exam - 1, Take Home Exam - 2 - Apply critical thinking and problem solving skills.
Relates to: Project (applied) - Communicate effectively in an academic and professional manner through written and oral genres integrating digital tools.
Relates to: Project (applied) - Apply teamwork knowledge and skills for effective collaboration.
Relates to: Project (applied) - 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
Unit Outline: College Summer 2024, Kelvin Grove, Internal
Unit code: | ITD105 |
---|---|
Credit points: | 12 |
Equivalent: | 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 (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:
- 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 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 Management: 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 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 that are 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 learned 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 that are 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 learned 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.
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
Students are expected to engage in learning and assessment at QUT with honesty, transparency and fairness. Maintaining academic integrity means upholding these principles and demonstrating valuable professional capabilities based on ethical foundations.
Failure to maintain academic integrity can take many forms. It includes cheating in examinations, plagiarism, self-plagiarism, collusion, and submitting an assessment item completed by another person (e.g. contract cheating). It can also include providing your assessment to another entity, such as to a person or website.
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.
Further details of QUT’s approach to academic integrity are outlined in the Academic integrity policy and the Student Code of Conduct. Breaching QUT’s Academic integrity policy is regarded as student misconduct and can lead to the imposition of penalties 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 out of the ordinary risks associated with the classroom/lecture activities in this unit.
Course Learning Outcomes
This unit is designed to support your development of the following course/study area learning outcomes.ES21 Diploma in Esports
- Demonstrate foundational interdisciplinary knowledge relating to esports.
Relates to: Take Home Exam 1, Take Home Exam 2 - Apply critical thinking and problem solving skills.
Relates to: Project (Applied) - Communicate effectively in an academic and professional manner through written and oral genres integrating digital tools.
Relates to: Project (Applied) - Apply teamwork knowledge and skills for effective collaboration.
Relates to: Project (Applied) - Apply knowledge of ethical and social practices in analysing and addressing real world problems and issues.
Relates to: Online Ethics Module Part 1
IT10 Diploma in Information Technology
- Demonstrate IT discipline knowledge
Relates to: Take Home Exam 1, Take Home Exam 2, Project (Applied) - Employ introductory IT methods
Relates to: Take Home Exam 1, Take Home Exam 2, Project (Applied) - Critically apply design and problem solving skills
Relates to: Take Home Exam 1, Take Home Exam 2, Project (Applied) - Communicate effectively in academic contexts
Relates to: Take Home Exam 2 - Understand personal values, attitudes and performance in your continuing professional development
Relates to: Take Home Exam 2, Project (Applied), Online Ethics Module Part 1 - Create considered and relevant IT solutions
Relates to: Project (Applied) - Work independently and within effective teams
Relates to: Project (Applied)