IFQ554 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: | IFQ554 |
|---|---|
| Equivalent(s): | IFN554 |
| Credit points: | 6 |
| Timetable | Details in HiQ, if available |
| Availabilities |
|
| Domestic tuition unit fee | $1,602 |
| International unit fee | $2,166 |
Unit Outline: Session-1B 2022, QUT Online, Online
| Unit code: | IFQ554 |
|---|---|
| Credit points: | 6 |
| Equivalent: | IFN554 |
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.
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 is an assignment for the purposes of an extension.
Assessment: Database Management
Implement the proposed design and solution in a database management system to demonstrate the fulfilment of the requirements.
This is an assignment for the purposes of an extension.
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: Session-3B 2022, QUT Online, Online
| Unit code: | IFQ554 |
|---|---|
| Credit points: | 6 |
| Equivalent: | IFN554 |
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.
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 is an assignment for the purposes of an extension.
Assessment: Database Management
Implement the proposed design and solution in a database management system to demonstrate the fulfilment of the requirements.
This is an assignment for the purposes of an extension.
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.