COS 455 - Database Systems

This course studies the fundamentals of database modeling and design, the languages and facilities provided by a database management system, and programmatic interfaces to the database (including web access). Emphasis is on the relational database model. Some NoSQL databases will also be examined. Theoretical topics include data modeling using the entity-relationship model, schema definition, relational algebra, functional dependencies and normal forms, queries, data storage, and physical design. In addition, there is a laboratory component that uses the MySQL database. In the laboratory, the topics include SQL query language, the design of a database, design and testing of queries. Course Typically Offered: Odd spring.

Prerequisite(s): 12 credits of Computer Science including COS 142.

Credits: 3