Concepts and fundamentals of relational database systems. Students learn how to design relational databases starting from a conceptual data model, following accepted logical and physical design principles. Topics include normalisation, referential integrity, SQL, DDL and SQL DML & ODBC and data extraction/filtering techniques. Prerequisite(s): second-year standing in the Networking program.Lecture two hours a week, tutorial/laboratory two hours a week.
Concepts and fundamentals of relational database systems. Students learn how to design relational databases starting from a conceptual data model, following accepted logical and physical design principles. Topics include normalisation, referential integrity, SQL, DDL and SQL DML & ODBC and data extraction/filtering techniques. Prerequisite(s): second-year standing in the Networking program.Lecture two hours a week, tutorial/laboratory two hours a week.