Database Design
Download as PDF
Overview
Subject area
CST
Catalog Number
3504
Course Title
Database Design
Description
"This course provides a general introduction to database design. The three main phases in database design are covered; that is conceptual, using Entity Relational Diagram (ERD) and Unified Modeling Language (UML); logical, using relational model, and physical, using a Database Management Systems. The basics of relational data model (concepts of relation, attribute, primary key, and foreign key) are reviewed, and mapping the conceptual model to the relational model is discussed. Advanced concepts of relational theory; normalization and denormalization are included. Physical implementation is described with the help of a particular Relational Database Management System (RDBMS). The students must be familiar with SQL."
Pre- or Corequisite
029397
Liberal Arts
No
Department(s)
Credits
Minimum
3
Max
3
Components
Name
Laboratory
Contact Hours
2
Name
Lecture
Contact Hours
2