Database Systems

Catalog description

This course surveys database systems database design and entity-relationship (ER) data model, basic features of the ER model, conceptual design with ER model, relational model, querying relational data, logical database design, views, relational algebra and calculus, SQL queries, constraints, and triggers, schema refinement, normal forms, normalization, physical database design, database tuning, database security, access control. The objective of this course is to provide a thorough understanding of the main concepts and principles of database management systems.