CIS 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 organizationAlso Listed as CSC 384