ITC114 Introduction to Database Systems (8)
Abstract
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). |
|
|
+ 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 ITC423,or ITC556 |
|
|
Incompatible subject(s) | Related subject(s) |
---|
ITC423 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 (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.
|
|
|
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.
- 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
|
|
|
Back
The information contained in the 2016 CSU Handbook was accurate at the date of publication: 06 September 2016. The University reserves the right to vary the information at any time without notice.