Database Design and Implementation
Course: CIS 315
Description: Surveys database models. Design and implementation concepts for relational model: enterprise modeling; entity-relationship modeling; schema development including normalization, SQL data definition language (DDL), SQL data manipulation language (DML), and user-defined types, rules, and triggers to support the schema. Features to support integrity, ease of use, and control: concurrency, locking, distribution, performance.
Units: 3
Recommended prerequisite: CIS 230, CIS 250, CIS 260 with a minimum C grade, or consent of instructor for students from other disciplines. MATH 253 is recommended.
Format: Two hours lecture, two hours lab per week.