CIS 266 — Database Design
This course is a survey of logical and physical database design theory. Students learn to analyze database system requirements and produce formal requirement specifications. Students will create models of database systems by identifying various system entities and their relationships. This includes eliminating anomalies using normalization and developing entity relationship (ER) and UML diagrams that represent the system s logical structure. Additional topics include cardinality, weak and strong entities, and orthogonality. Students will also use popular data modeling software tools.
Prerequisites: CIS 195