CS 561 Database Management Systems I

Introduction to the design and querying of relational databases. Topics include: relational schemas; keys and foreign key references; relational algebra (as an introduction to SQL); SQL in depth; Entity-Relationship (ER) database design; translating from ER models to relational schemas and from relational schemas to ER models; functional dependencies; and normalization. Undergraduate data structures and algorithms (CS 385 ) OR CS 590. Undergraduates not allowed to enroll.

Credits

3

Prerequisite

(CS 385 or CS 590) and (Grad Student or (Junior or Senior))

Distribution

Computer Science Program

Typically Offered Periods

Fall Semester Spring Semester Summer Session 1 Summer Session 2