ITC423 Database Systems (8)
CSU Discipline Area: Computing (COMPU)
Duration: One session
Abstract:
This subject will provide an in-depth study of Database Management theory and application in relational databases. There will be a strong emphasis on the conceptual modeling of database design to meet specified business requirements. This will lead to the implementation of a database design using Structured Query Language (SQL).
+ Subject Availability Modes and Locations
| Session 1 | |
|---|---|
| Internal | CSU Study Centre Melbourne |
| Internal | CSU Study Centre Sydney |
| Distance | Albury-Wodonga | Session 2 |
| Internal | CSU Study Centre Melbourne |
| Internal | CSU Study Centre Sydney |
| Distance | Albury-Wodonga | Session 3 |
| Internal | CSU Study Centre Melbourne |
| Internal | CSU Study Centre Sydney |
| Distance | Albury-Wodonga |
Continuing students should consult the SAL for current offering details: ITC423
Where differences exist between the Handbook and the SAL, the SAL should be taken as containing the correct subject offering details.
Enrolment restrictions:
Objectives:
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 Extended Entity Relationship Diagrams (EERD);
- 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 explain the use of transaction processing, security and database integrity in relation to relational databases.
Syllabus:
The 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.
- The conceptual design of databases using Extended Entity Relationship Diagrams.
- The use of normalisation theory to complete database design.
- The physical design and sizing of database systems.
- The syntax and use of SQL to create, query and manipulate a relational database.
- Database integrity, transactions, concurrency, recovery and security.
- Database Management Systems software and the role of the database administrator.
Residential School
This subject contains a optional 2 day residential school.
.
The information contained in the 2013 CSU Handbook was accurate at the date of publication: 24 April 2013. The University reserves the right to vary the information at any time without notice.