Program Overview

Introduction to Database Systems

Subject Description

This subject aims to provide a solid grounding in database theory and application, and its place within the implementation of computer-based applications. There will be an emphasis on conceptual modeling to design a database that is implemented and queried using Structured Query Language (SQL).

Availability

The subject is available in the following sessions:

• Session 1 (30): On Campus at CSU Study Centre Sydney
• Session 2 (60):
  • On Campus at Albury-Wodonga Campus, Bathurst Campus, CSU Study Centre Melbourne, CSU Study Centre Sydney, Wagga Wagga Campus
  • Online at Albury-Wodonga Campus
• Session 3 (90):
  • On Campus at CSU Study Centre Melbourne, CSU Study Centre Sydney
  • Online at Albury-Wodonga Campus

Subject Information

Grading System

The grading system for this subject is HD/FL.

Duration

The subject duration is one session.

School

The subject is offered by the School of Computing and Mathematics.

Enrolment Restrictions

This subject is not available to students who have completed ITC423 or ITC556.

Subject Relationships

• ITC556 is a paired subject.
• ITC423 is a paired subject.

Incompatible Subjects

The subject is incompatible with ITC423 and ITC556.

Learning Outcomes

Upon successful completion of this subject, students should:

• Be able to apply database theory to the design and implementation of relational databases.
• Be able to analyse and model business database requirements using Entity Relationship Diagrams (ERD).
• Be able to analyse a database design and apply normalisation theory and techniques.
• Be able to implement a database design using Structured Query Language (SQL).
• Be able to query a database using SQL.

Syllabus

This subject will cover the following topics:

• Definition of a database, database management systems, and their importance to business organizations.
• The importance and use of data models to design databases to meet business requirements.
• Identifying and documenting business rules.
• The relational database model.
• The conceptual design of databases using Entity Relationship Diagrams (ERD).
• The use of database normalisation techniques to complete database design.
• The implementation of a database design using Structured Query Language (SQL).
• The querying of databases using SQL.