Database Systems I

This course is an introduction to the concepts, approaches, tools, and methodology of database design and database query languages. Covers the entity-relationship model, the relational model, relational algebra, relational calculus, commercial languages (such as SQL), functional dependencies, normal forms, and design theory. Other topics may include database constraints, recursive queries, and alternative database models.

Prerequisite: course 101.

The syllabus, homeworks, lab assignments, announcements, etc. will be announced through Piazza. If you are enrolled in CMPS180, please make sure you enroll in this CMPS180 Piazza page.

Instructors and Assistants