Databases

Catalog description

The course covers modeling an application and logical database design, the relational model and relational data definition and data manipulation languages, design of relational databases and normalization theory, physical database design, query processing and optimization, transaction processing focusing on concurrency and recovery. The labs emphasize experiential learning of database systems and applications and an insight into various database management systems and query languages. Prerequisite: CSCI-SHU 210 Data Structures. Fulfillment: Computer Science Major Electives; Data Science Major Required Data Management Courses; Computer Systems Engineering elective.