CS- 630 Database Systems

 

design a database from scratch for a small fictitious business such as a library, car rental, university, retail store, hospital, doctor’s office or any other business.

 

Requirements/Guidelines:

 

Part I - Modeling/Design

Your database must consist of 6 or more tables with proper relationships. The database must contain a transaction table (bridging entity). Remember 3NF for your design.

Represent your database diagrammatically (ER diagram – Crow’s Foot Notation).

 

Part II - Oracle 12c

Create tables using DDL queries.  Add appropriate data to each table.

Create simple/complex views for the end-users.

Design data retrieval queries using various joins, functions, set operators and nested queries.

Utilize various database objects like synonym, view, sequence and index.

Implement user access control for different objects.

Use PL/SQL blocks (Procedure/function/package/trigger) for data manipulation.

 

Part III - Documentation & Presentation

• Detailed Documentation.  Justify creation of each object and its use. Submit your table structures, records, constraint information, queries, programs as well as all supporting printouts.