ITC556 Database Systems (8)

This subject will provide a solid grounding in database design . It will examine 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 2 (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, Mathematics and Engineering

Enrolment Restrictions

Only available to postgraduate students
Not available to students who have completed ITC114

Incompatible Subjects

ITC114

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 Structured Query Language (SQL) commands to query a database; and
  • 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

Indicative Assessment

The following table summarises the assessment tasks for the online offering of ITC556 in Session 3 2021. Please note this is a guide only. Assessment tasks are regularly updated and can also differ to suit the mode of study (online or on campus).

Item Number
Title
Value %
1
Online quiz
5
2
Research and data modelling
15
3
Normalization
15
4
Query databases using sql
15
5
Final exam
50

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

Back