ITC114 Introduction to Database Systems (8)

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

Session 2 (60)
On Campus
Bathurst Campus
Port Macquarie Campus
Online
Albury-Wodonga Campus
Session 3 (90)
On Campus
CSU Study Centre Melbourne
CSU Study Centre Sydney
Online
Albury-Wodonga Campus

Continuing students should consult the SAL for current offering details: ITC114. 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

Available to undergraduate students only.

Not available to students who have completed  ITC423,or ITC556

Incompatible Subjects

ITC423, 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

Indicative Assessment

The following table summarises the assessment tasks for the online offering of ITC114 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 1
5
2
Create an erd
12
3
Online quiz 2
5
4
Normalisation
12
5
Query databases using sql
16
6
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