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 |
|
Unit Outline: Semester 2 2020, Online
| 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:
- Conceptualise and present data models.
- Develop effective database designs.
- Realise the storage, retrieval (query formulation) and manipulation of data.
- Evaluate database systems, data models and physical data structures.
- Generate ethical and culturally sensitive solutions to data management problems.
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 takes a blended approach to learning and teaching. You will be provided with both eContent and timetabled activities such as tutorials and workshops. eContent will be clearly identified on your Blackboard 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
A variety of feedback will be provided in both timetabled activities and opportunities will be made available for one on one consultation. Written feedback will be provided on assessment submissions through a range of means including marking rubrics.
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 examination will allow you to demonstrate your understanding of all content covered in the unit.
Unit Grading Scheme
7- point scale
Assessment Tasks
Assessment: Portfolio
This assessment consists of exercises using examples 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 Blackboard.
Assessment: Project (applied)
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.
Assessment: Examination (online)
An open book examination, which covers the material presented throughout the semester.
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
There are no extraordinary risks associated with this unit
Unit Outline: 13 Week Teaching Period - 1 2020, 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:
- Conceptualise and present data models.
- Develop effective database designs.
- Realise the storage, retrieval (query formulation) and manipulation of data.
- Evaluate database systems, data models and physical data structures.
- Generate ethical and culturally sensitive solutions to data management problems.
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
NOTE: Based on the requirement to move this unit to On-line for this teaching period, some modifications to below have been made.
This unit engages you in a theory-to-practice approach to active learning in a collaborative learning spaces.
The unit adopts a blended learning approach which includes:
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 in a studio based, interactive and creative environment in collaborative learning spaces 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.
Reading: 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 Blackboard 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: Portfolio
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 Blackboard.
Relates to learning outcomes
1,2,3,4
Assessment: Project (applied)
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.
Relates to learning outcomes
1,2,3,4,5
Assessment: Examination (online)
An open book examination, which covers the material presented in the lectures, tutorials, readings and summaries throughout the semester.
Relates to learning outcomes
1,2,3,4,5
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
There are no extraordinary risks associated with the classroom/lecture activities in this unit
Unit Outline: 13 Week Teaching Period - 2 2020, 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:
- Conceptualise and present data models.
- Develop effective database designs.
- Realise the storage, retrieval (query formulation) and manipulation of data.
- Evaluate database systems, data models and physical data structures.
- Generate ethical and culturally sensitive solutions to data management problems.
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 Blackboard 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
Feedback in this unit is provided to you in the following ways:
- A range of formative exercises;
- Comments and feedback on your portfolio submissions;
- Generic comments made to the cohort using QUT Blackboard;
- Feedback and collaboration with peers.
Questions about the unit should be directed to the unit teaching team.
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: Portfolio
This assessment consists of exercises using examples 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 Blackboard.
Assessment: Project (applied)
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.
Assessment: Examination
An examination which covers the material presented throughout the semester.
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
There are no extraordinary risks associated with this unit.
Unit Outline: 13 Week Teaching Period - 3 2020, 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:
- Conceptualise and present data models.
- Develop effective database designs.
- Realise the storage, retrieval (query formulation) and manipulation of data.
- Evaluate database systems, data models and physical data structures.
- Generate ethical and culturally sensitive solutions to data management problems.
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 Blackboard 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: Portfolio
This assessment consists of exercises using examples 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 Blackboard.
Assessment: Project (applied)
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.
Assessment: Examination
An examination which covers the material presented throughout the semester.
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
There are no extraordinary risks associated with this unit.