IFN554 Databases
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: | IFN554 |
|---|---|
| Prerequisite(s): | (Admission to IN20 or IN18 or IN19 or IN23 or IN27 or IN26 or BS11 or KC88 or IV53 or IV55 or IV56 or IV58) or (192cps in SV03 or MV05 or BV06 or EV08). |
| Equivalent(s): | IFQ554 |
| Credit points: | 6 |
| Timetable | Details in HiQ, if available |
| Availabilities |
|
| CSP student contribution | $559 |
| Domestic tuition unit fee | $1,764 |
| International unit fee | $2,412 |
Unit Outline: Semester 1 - 5 Week A 2024, Gardens Point, Internal
| Unit code: | IFN554 |
|---|---|
| Credit points: | 6 |
| Pre-requisite: | (Enrolment in IN20 or IN18 or IN19 or IN23 or IN27 or IN26 or BS11 or KC88 or IV53 or IV55 or IV56 or IV58) or (192cps in SV03 or MV05 or BV06 or EV08). |
| Equivalent: | IFQ554 |
| Coordinators: | Gowri Ramachandran | g.ramachandran@qut.edu.au |
Overview
This is a foundational unit addressing the core concepts, principles and skills required for understanding, designing and managing databases. It introduces a conceptual approach to modeling the data aspect of business domains, how to transform a conceptual data model into a relational database design, and how to retrieve and manipulate data through standard database querying techniques. Relevant societal and ethical aspects of database management are also covered. The knowledge and skills involved in developing and managing databases effectively are essential for IT Professional, Business Analyst, and Data Scientist nowadays.
Learning Outcomes
On successful completion of this unit you will be able to:
- Demonstrate knowledge of conceptual data modeling principles to understand, analyse and capture an abstraction of the complex data aspect of business domains (CLO1)
- Develop rigorous database design underpinned by conceptual data model (CLO2)
- Apply standard querying techniques to the retrieval and manipulation of data (CLO3)
- Generate effective, ethical and culturally sensitive solutions to database management problems (CLO6, CLO7)
- Apply visual and written communication techniques to explain how the proposed design and solution meets data management needs (CLO5, CLO7)
Content
In this unit, you will be exposed to the core concepts, principles, techniques, and practices required to model an abstraction of complex data aspects of business domains, to design, develop and manage database in the context of database management systems, and to establish ethical and culturally sensitive solutions to database management problems. The content of the unit is designed to focus on the following three main topics:
Topic 1. Conceptual data modeling: You will learn to develop a conceptual data model of the data aspect of business domains using Object Role Modeling (ORM) technique, and then translate such conceptual data model to a relational database schema.
Topic 2. Database design, development and management: You will learn to design a database from a relational database schema, and then retrieve and manipulate data in the database via creating, reading, updating, and deleting (CRUD) operations realised by SQL query formulation.
Topic 3. Societal and ethical issues: You will explore topics addressing societal and ethical concerns related to databases, such as data privacy, access control, data ethics, etc., which are required for developing ethical and culturally sensitive solutions to database management problems.
Learning Approaches
This unit includes weekly lectures and workshops organised in the form of one-and-half hour lecture and oneand- half hour workshop. It aims to cultivate student learning and development through a theory-to-practice approach. The lectures will focus on dissemination of core body of knowledge, where theoretical and technical concepts and principles will be introduced and explained using working examples. The workshops will engage students in formative exercises and practical activities that build directly on the foundational materials presented in the lectures. In some weeks, students will also be provided with additional readings and practices expected to complete as homework for further reinforcement or advancement of the knowledge and skills learned during the lectures and workshops. Throughout the teaching period, students will be guided through practical activities and assessment tasks, and encouraged to use online facilities such as online discussion boards for questions and answers in addition to face-to-face and email communication with the teaching team.
Feedback on Learning and Assessment
Feedback in this unit is provided to students in many ways including mainly as the follows:
- A range of formative exercises will be discussed and ongoing feedback will be provided during workshops;
- Consultation times can be booked with members of the teaching team throughout the teaching period;
- Guidance and constructive comments to assessment tasks will be provided during lectures and workshops;
- You will be given opportunities reflect on assessment tasks and receive formative feedback during some workshop sessions;
- A marking guide will be available for the assessment;
- A detailed marking of and individualised written feedback will be provided on your assessment items;
- Feedback will also be provided to the cohort based on common areas for improvement identified throughout the workshops, consultations and Q&A discussions.
Assessment
Overview
You will be presented with data management requirements of an organisation in the context of a case study (which is informed by a real world use case). To address these requirements, you will need to design a database and develop a solution for management of the database; and to demonstrate the fulfilment of the above requirements, you will need to implement the proposed design and solution in a database management system. The assessment consists of two parts. The first part is concerned with database design which comprises a conceptual data model and the corresponding database schema; the second part is concerned with database management which focuses on data retrieval and manipulation; and where applicable, relevant societal and ethics considerations also need to be taken into account when carrying out database design and management tasks. You will be working individually on the assignment. To help you progress and stay on track with the assignment along the teaching period, you are expected to submit the first part of the assignment in the middle of the teaching period for review and to receive formative feedback from the teaching team. Submission of the overall assessment deliverables is due at the end of the teaching period.
Unit Grading Scheme
7- point scale
Assessment Tasks
Assessment: Database Design
Design a database and develop a solution to address data management requirements in a case study.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
Assessment: Database Management
Implement the proposed design and solution in a database management system to demonstrate the fulfilment of the requirements.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
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
- Any software required for design and management of databases in this unit is either free or will be made available in the computer labs that are allocated to the workshops of the unit.
- There is no prescribed textbook for this unit. However, this unit will, where appropriate, make use of the selected chapters from textbooks, journals and magazines. Students are encouraged to obtain a copy of these materials from the library. Where possible, materials will be made available online through the Course Materials Database.
Risk Assessment Statement
There are no unusual health or safety risks associated with this unit.
Unit Outline: Semester 2 - 5 Week C 2024, Gardens Point, Internal
| Unit code: | IFN554 |
|---|---|
| Credit points: | 6 |
| Pre-requisite: | (Enrolment in IN20 or IN18 or IN19 or IN23 or IN27 or IN26 or BS11 or KC88 or IV53 or IV55 or IV56 or IV58) or (192cps in SV03 or MV05 or BV06 or EV08). |
| Equivalent: | IFQ554 |
| Coordinators: | Naha Naha | ranesh.naha@qut.edu.au |
Overview
This is a foundational unit addressing the core concepts, principles and skills required for understanding, designing and managing databases. It introduces a conceptual approach to modeling the data aspect of business domains, how to transform a conceptual data model into a relational database design, and how to retrieve and manipulate data through standard database querying techniques. Relevant societal and ethical aspects of database management are also covered. The knowledge and skills involved in developing and managing databases effectively are essential for IT Professional, Business Analyst, and Data Scientist nowadays.
Learning Outcomes
On successful completion of this unit you will be able to:
- Demonstrate knowledge of conceptual data modeling principles to understand, analyse and capture an abstraction of the complex data aspect of business domains (CLO1)
- Develop rigorous database design underpinned by conceptual data model (CLO2)
- Apply standard querying techniques to the retrieval and manipulation of data (CLO3)
- Generate effective, ethical and culturally sensitive solutions to database management problems (CLO6, CLO7)
- Apply visual and written communication techniques to explain how the proposed design and solution meets data management needs (CLO5, CLO7)
Content
In this unit, you will be exposed to the core concepts, principles, techniques, and practices required to model an abstraction of complex data aspects of business domains, to design, develop and manage database in the context of database management systems, and to establish ethical and culturally sensitive solutions to database management problems. The content of the unit is designed to focus on the following three main topics:
Topic 1. Conceptual data modeling: You will learn to develop a conceptual data model of the data aspect of business domains using Object Role Modeling (ORM) technique, and then translate such conceptual data model to a relational database schema.
Topic 2. Database design, development and management: You will learn to design a database from a relational database schema, and then retrieve and manipulate data in the database via creating, reading, updating, and deleting (CRUD) operations realised by SQL query formulation.
Topic 3. Societal and ethical issues: You will explore topics addressing societal and ethical concerns related to databases, such as data privacy, access control, data ethics, etc., which are required for developing ethical and culturally sensitive solutions to database management problems.
Learning Approaches
This unit includes weekly lectures and workshops organised in the form of one-and-half hour lecture and oneand- half hour workshop. It aims to cultivate student learning and development through a theory-to-practice approach. The lectures will focus on dissemination of core body of knowledge, where theoretical and technical concepts and principles will be introduced and explained using working examples. The workshops will engage students in formative exercises and practical activities that build directly on the foundational materials presented in the lectures. In some weeks, students will also be provided with additional readings and practices expected to complete as homework for further reinforcement or advancement of the knowledge and skills learned during the lectures and workshops. Throughout the teaching period, students will be guided through practical activities and assessment tasks, and encouraged to use online facilities such as online discussion boards for questions and answers in addition to face-to-face and email communication with the teaching team.
Feedback on Learning and Assessment
Feedback in this unit is provided to students in many ways including mainly as the follows:
- A range of formative exercises will be discussed and ongoing feedback will be provided during workshops;
- Consultation times can be booked with members of the teaching team throughout the teaching period;
- Guidance and constructive comments to assessment tasks will be provided during lectures and workshops;
- You will be given opportunities reflect on assessment tasks and receive formative feedback during some workshop sessions;
- A marking guide will be available for the assessment;
- A detailed marking of and individualised written feedback will be provided on your assessment items;
- Feedback will also be provided to the cohort based on common areas for improvement identified throughout the workshops, consultations and Q&A discussions.
Assessment
Overview
You will be presented with data management requirements of an organisation in the context of a case study (which is informed by a real world use case). To address these requirements, you will need to design a database and develop a solution for management of the database; and to demonstrate the fulfilment of the above requirements, you will need to implement the proposed design and solution in a database management system. The assessment consists of two parts. The first part is concerned with database design which comprises a conceptual data model and the corresponding database schema; the second part is concerned with database management which focuses on data retrieval and manipulation; and where applicable, relevant societal and ethics considerations also need to be taken into account when carrying out database design and management tasks. You will be working individually on the assignment. To help you progress and stay on track with the assignment along the teaching period, you are expected to submit the first part of the assignment in the middle of the teaching period for review and to receive formative feedback from the teaching team. Submission of the overall assessment deliverables is due at the end of the teaching period.
Unit Grading Scheme
7- point scale
Assessment Tasks
Assessment: Database Design
Design a database and develop a solution to address data management requirements in a case study.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
Assessment: Database Management
Implement the proposed design and solution in a database management system to demonstrate the fulfilment of the requirements.
This assignment is eligible for the 48-hour late submission period and assignment extensions.
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
- Any software required for design and management of databases in this unit is either free or will be made available in the computer labs that are allocated to the workshops of the unit.
- There is no prescribed textbook for this unit. However, this unit will, where appropriate, make use of the selected chapters from textbooks, journals and magazines. Students are encouraged to obtain a copy of these materials from the library. Where possible, materials will be made available online through the Course Materials Database.
Risk Assessment Statement
There are no unusual health or safety risks associated with this unit.