ITC114 Database Management Systems (8)
Abstract
This subject aims to provide a solid grounding in database management theory and application, and its place within the implementation of computer based applications. There will be an emphasis on conceptual modeling to design the database that is implemented and queried using Structured Query Language (SQL). |
|
|
+ Subject Availability Modes and Location
Session 1 | Internal | CSU Study Centre Sydney | Session 2 | Internal | Albury-Wodonga Campus | Internal | Bathurst Campus | Internal | CSU Study Centre Melbourne | Internal | CSU Study Centre Sydney | Internal | Wagga Wagga Campus | Distance | Albury-Wodonga Campus | Session 3 | Internal | CSU Study Centre Melbourne | Internal | CSU Study Centre Sydney | Distance | 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 informationDuration | Grading System | School: |
---|
One session | HD/FL | School of Computing and Mathematics |
|
|
Enrolment restrictions
Not available to students who have completed ITC202, ITC423, ITC443 or ITC556 |
|
|
Incompatible subject(s) | Related subject(s) |
---|
ITC202 ITC423 ITC443 ITC556 | ITC423 Paired Subject ITC556 Paired Subject
|
|
Learning OutcomesUpon 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 (EDR);
- 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.
|
|
|
SyllabusThe 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.
- Gathering user requirements for database design.
- The physical design and sizing of database systems.
- The conceptual design of databases using Entity Relationship Diagrams (ERD).
- The use of database normalisation techniques to complete database design.
- Database integrity, transactions, concurrency, recovery and security.
- Database Management Systems software and the role of the database administrator.
|
|
|
Back
The information contained in the 2015 CSU Handbook was accurate at the date of publication: 01 October 2015. The University reserves the right to vary the information at any time without notice.