Students review the major components of the database environment and the evolution of database technologies. Database design techniques are then introduced using both the Entity Relationship model and an object-oriented approach. As students design and implement a case study project, they learn the relational database model and data normalization. Structured Query Language (SQL) is discussed in depth, including Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language, and data integrity checking. Client and Server architecture is also discussed. Prerequisite: C or better in COMP 1230 or COMP 1231 or COMP 2120
Students review the major components of the database environment and the evolution of database technologies. Database design techniques are then introduced using both the Entity Relationship model and an object-oriented approach. As students design and implement a case study project, they learn the relational database model and data normalization. Structured Query Language (SQL) is discussed in depth, including Data Definition Language (DDL), Data Manipulation Language (DML), Data Control Language, and data integrity checking. Client and Server architecture is also discussed. Prerequisite: C or better in COMP 1230 or COMP 1231 or COMP 2120