CSC 384 - Database Design

CSC 275 or CSC 276 with a grade of C (2.0) or better, or CSC 175 and HCR 301. (3)

Introduction to data and database, DBMS; database system concepts and architecture. ER model for high level conceptual database design; design issues. Relational model concepts; relational constraints and violations; ER-to relational mapping. SQL*Plus environment; creation and modification of relations, DDL queries, data management and retrieval. PL/SQL overview. Functional dependencies; normal forms. ORACLE; basic structure, database structure and manipulation, storage organization. Graded ABCDE