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).

 

Subject Outlines
Current CSU students can view Subject Outlines for recent sessions. Please note that Subject Outlines and assessment tasks are updated each session.

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

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

Not available to students who have completed ITC114 or ITC423.

Subject Relationships

ITC423 Similar content
ITC114 Paired Subject

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

Contact

Current Students

For any enquiries about subject selection or course structure please contact Student Central or ask@csu.edu.au or phone on 1800 275 278.

Prospective Students

For further information about Charles Sturt University, or this course offering, please contact info.csu on 1800 275 278 (free call within Australia) or enquire online.

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

Back