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.