CSC 384 - Database Design

Formerly (480)CSC/CIS 275 with a grade of C (20) or better;CSC/CIS/MTH 230(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.Also Listed as CIS 384