ITC556 Database Systems (8)

This subject will provide a solid grounding in database design . It will show the importance of database design in the development of applications that meet business needs. There will be an emphasis on modeling a database using Entity Relationship Diagrams (ERDs), optimising its design using normalisation techniques and implementing it and querying it using Structured Query Language (SQL).

Availability

Session 1 (30)
On Campus
CSU Study Centre Brisbane
CSU Study Centre Melbourne
CSU Study Centre Sydney
Session 2 (60)
On Campus
CSU Study Centre Brisbane
CSU Study Centre Melbourne
CSU Study Centre Sydney
Port Macquarie Campus
Online
Albury-Wodonga Campus
Session 3 (90)
On Campus
CSU Study Centre Brisbane
CSU Study Centre Melbourne
CSU Study Centre Sydney
Online
Albury-Wodonga Campus
Term 1 (75)
Online
Albury-Wodonga Campus
Term 3 (45)
Online
Albury-Wodonga Campus

Continuing students should consult the SAL for current offering details: ITC556. Where differences exist between the Handbook and the SAL, the SAL should be taken as containing the correct subject offering details.

Subject Information

Grading System

HD/FL

Duration

One session

School

School of Computing and Mathematics

Enrolment Restrictions

Available to postgraduate students only.

Not available to students who have completed ITC114 or ITC423.

Incompatible Subjects

ITC114, ITC423

Learning Outcomes

Upon successful completion of this subject, students should:
  • be able to model complex business rules using Entity Relationship Diagrams (ERDs);
  • be able to apply normalisation techniques to optimise a database design;
  • be able to use complex SQL commands to query a database;
  • be able to research a recent development in the field of database technology.

Syllabus

This subject will cover the following topics:
  • The role of database management systems and their importance to business organisations.
  • The importance and use of data models to design databases to meet business requirements.
  • The conceptual design of databases using Entity Relationship Diagrams.
  • The use of normalisation techniques to optimise database design.
  • The implementation of databases using Structured Query Language (SQL).
  • The querying of databases using complex SQL commands
  • The recent developments in the field of database technology

The information contained in the CSU Handbook was accurate at the date of publication: January 2020. The University reserves the right to vary the information at any time without notice.

Back