CIS 256 Database Design

In this course, students learn how to produce a detailed database model that provides an appropriate storage structure for data to be used in a system while ensuring data integrity and suitability for general-purpose queries. A systematic database design process for creating a well-designed database is introduced and various database models including conceptual, physical, and logical are discussed. Special attention is paid to the use of Entity Relation (ER) modeling using practical business examples, relational databases, database normalization, and structured query languages for data manipulation. Prerequisite: CIS130.

Credits

4.5

Prerequisite

CIS130 D- O CIS130 TC O CIS130 CR