|Short Description:||Database Systems|
|Faculty or Section :||Faculty of Health, Engineering and Sciences|
|School or Department :||School of Sciences|
|Student contribution band :||Band 2|
|ASCED code :||020303 - Database Management|
|Grading basis :||Graded|
|Version produced :||9 December 2021|
Pre-requisite: CSC1401 or CIS1000
Enrolment is not permitted in CSC3400 if CIS2002 has been previously completed.
Recommended Pre-requisite: MAT1101 and CSC2401 and CSC2407 and CSC2408.
Students who have enrolled in or completed CSC8500 Advanced Relational Database Design and Technology cannot enrol in this course.
This course covers the fundamental issues of the relational model, relational languages, database design and query processing. It starts with a structured overview of database systems, their history and application. The relational model is then covered in detail. Relational languages such as the relational algebra and calculus are discussed before introducing the SQL language. Then we cover the Entity-Relationship model and discuss how ER diagrams are translated to the relational model. Topics on database design principles in this course further include functional dependencies and normalization. Students will gain a good understanding of database design theory and principles and be able to develop database systems and application programs on a DBMS.