This course introduces students to database concepts. It reviews the underlying data structures that make up databases; trees, simple networks and complex networks, link lists and inverted list (indexes). Database design techniques are introduced using both the Entity Relationship model as well as an object oriented approach to designing database systems. The relational database model and data normalization will be taught as students design and implement a case study project. Data description language, data manipulation language (updates, queries, reports), and data integrity checking are also covered. Case study work will be completed using a relevant and current relational Database Management System, DBMS, software product.
Corequisite: COMP 223