CQUniversity Unit Profile

In Progress

Please note that this Unit Profile is still in progress. The content below is subject to change.
COIT20247 Database Design and Development
Database Design and Development
Save or Print as PDF
All details in this unit profile for COIT20247 have been officially approved by CQUniversity and represent a learning partnership between the University and you (our student).
The information will not be changed unless absolutely necessary and any change will be clearly indicated by an approved correction included in the profile.
General Information

Overview

In this unit, you will learn how to model, design, and build relational databases and manipulate them using Structured Query Language (SQL) in a modern database management system (DBMS) such as MySQL Server. You will build a practical database that typically meets the requirement of a large-scale commercial-level DBMS. In this unit, you will also learn the features of the latest developments including data integrity, security, distributed system databases, data warehousing, and concurrency control in multi-user database systems.

Details

Career Level: Postgraduate
Unit Level: Level 8
Credit Points: 6
Student Contribution Band: 8
Fraction of Full-Time Student Load: 0.125

Pre-requisites or Co-requisites

Antirequisite: COIS20026

Important note: Students enrolled in a subsequent unit who failed their pre-requisite unit, should drop the subsequent unit before the census date or within 10 working days of Fail grade notification. Students who do not drop the unit in this timeframe cannot later drop the unit without academic and financial liability. See details in the Assessment Policy and Procedure (Higher Education Coursework).

Offerings For Term 1 - 2025

Brisbane
Melbourne
Online
Rockhampton
Sydney

Attendance Requirements

All on-campus students are expected to attend scheduled classes - in some units, these classes are identified as a mandatory (pass/fail) component and attendance is compulsory. International students, on a student visa, must maintain a full time study load and meet both attendance and academic progress requirements in each study period (satisfactory attendance for International students is defined as maintaining at least an 80% attendance record).

Website

This unit has a website, within the Moodle system, which is available two weeks before the start of term. It is important that you visit your Moodle site throughout the term. Please visit Moodle for more information.

Class and Assessment Overview

Information for Class and Assessment Overview has not been released yet.

This information will be available on Monday 13 January 2025
CQUniversity Policies

All University policies are available on the CQUniversity Policy site.

You may wish to view these policies:


This list is not an exhaustive list of all University policies. The full list of University policies are available on the CQUniversity Policy site.

Previous Student Feedback

Feedback, Recommendations and Responses

Every unit is reviewed for enhancement each year. At the most recent review, the following staff and student feedback items were identified and recommendations were made.

Feedback from Unit Coordinator reflection

Feedback

Students struggle with getting started with SQL and ERDs.

Recommendation

Add more self-driven practical Moodle activities to allow students to practice SQL queries and database design.

Feedback from Unit Coordinator reflection

Feedback

Difficult to maintain academic integrity with the advances in GenAI.

Recommendation

Introduce invigilation to the final assessment.

Feedback from External Review

Feedback

Good practices in database design and implementation are not always clearly shown.

Recommendation

Emphasise good practices to students and ensure examples follow those practices.

Feedback from External Review

Feedback

Unclear breakdown of marks in assessments.

Recommendation

Revise the marking criteria to ensure expectations of students are clear.

Unit Learning Outcomes

Information for Unit Learning Outcomes has not been released yet.

This information will be available on Monday 13 January 2025
Alignment of Learning Outcomes, Assessment and Graduate Attributes

Information for Alignment of Learning Outcomes, Assessment and Graduate Attributes has not been released yet.

This information will be available on Monday 13 January 2025
Textbooks and Resources

Information for Textbooks and Resources has not been released yet.

This information will be available on Monday 17 February 2025
Academic Integrity Statement

Information for Academic Integrity Statement has not been released yet.

This unit profile has not yet been finalised.