CSC8500 Advanced Relational Database Design and Technology
|Short Description:||Adv Relational Database Design|
|Faculty or Section :||Faculty of Health, Engineering and Sciences|
|School or Department :||School of Agric, Comp and Environ Sciences|
|Student contribution band :||Band 2|
|ASCED code :||020303 - Database Management|
|Grading basis :||Graded|
|Version produced :||24 February 2019|
Pre-requisite: Students must be enrolled in one of the following Programs: GDTI or GCSC or MCTN or GCSC or GDSI or MSCN.
Recommended Pre-requisite: MAT1101 and CSC2401 and CSC2407 and CSC2408.
Students who have enrolled in or completed CSC3400 Database Systems cannot enrol in this course.
Students will require access to e-mail and have internet access to UConnect for this course.
This course covers the fundamental issues of the relational model, relational languages, database design, query processing and some advanced data management and data mining techniques. 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 include functional dependencies and normalisation. Students will gain a good understanding of database design theory and principles, be able to select, develop and troubleshoot database systems, and implement data-centric applications for performing advanced data management and/or data mining tasks.