Unit Catalogue

Back to Unit Search

HIT234 - Database Concepts

2024

Sector

Higher Education

Discipline

Information Technology

Credit Points

Equivalent Units

(BIS234)

Prerequisites

Incompatible

Assumed Knowledge

Unit Description

This unit examines the design and use of relational databases. Relational design principles, including enhanced entity-relationship modelling and normalisation, as well as SQL the standard query language for relational databases is covered. An overview of security, database administration issues, special purpose databases and database integration is provided.

This unit is reliant on on-line materials. Students must have access to a reliable high-speed broadband connection.

Unit Learning Outcomes

1.	Critically analyse a range of complex situations to create appropriate data models.
2.	Apply normalisation techniques to convert data model to relational database.
3.	Effectively create and extract information from relational databases.
4.	Evaluate security and concurrency issues related to relational databases.
5.	Compare and contrast different data models.
6.	Work collaboratively in groups to plan and execute project work to solve complex database issues.

Assessment Overview

	Assessment Task	Value (of total mark)	Related Learning Outcome/s
1.	Database Online Quiz (30 minutes)	10%	1,4
2.	Group Assignment 1 (SQL Programming and DFD) (5 pages/per student)	25%	1,2,3,4,5,6
3.	Mid Semester Online Test (2 hours)	30%	1,2,3,4,5,6
4.	Assignment 2 (SQL Programming and DFD) (6 pages/per student)	35%	1,2,3,4,5,6

Unit Availability

Year	Semester	Att Mode	Location	Learning Method
2024	Semester 1	Internal	CDU Sydney	OLR
2024	Semester 1	Internal	Casuarina Campus	OLR
2024	Semester 1	External	External Studies	OLR

* Timetable will be displayed in new tab or window depending on your browser's configuration; ensure Pop-ups are allowed for this site to view the timetable.

OLR: Internet access is required for this unit as students are required to access study materials provided on-line through Learnline. Please log into Learnline on the first day of each teaching period. For more information about Learnline, please click here.

Critical Dates

Important Dates for Students

Fee Information:
Fees and Payments
Student Services and Amenities Fees
2024 Domestic Unit Fees (PDF)