Question: Work in a team to design a database from scratch for a small fictitious business such as a library, car rental, university, retail store, hospital,

Work in a team to 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 Due: July 10 Your database must consist of 6 or more tables with proper relationships. The database must contain a transaction table (bridging entity). Remember BNF for your design. Represent your database diagrammatically (ER diagram - Crow's Foot Notation). Part II - Oracle 12c Due: July 24 Create tables using DDL queries. Add appropriate data to each table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
