ITCS 323: Database Systems: Design & Application: (3-0-3)

This course provides a comprehensive introduction to the fundamentals of database modelling, design, implementation and management with emphasis placed on key aspects of the relational model and relational systems (data structure, data manipulation and data integrity). The student will learn how to design and implement a simple relational database which entails modelling data requirements using appropriate techniques (basic ER diagram, logical model and normalised tables) and creating, maintaining and manipulating both a relational database (using SQL) and a relational database management system (MySQL). (Prerequisite: ITCS 303)