You are required to develop the ERD for a small business. You are given the freedom to select the business you want to model the data for. However, it is required that the ERD should contain not less than four entities. It is also recommended, that you avoid developing a model for a large business case that might require more than six entities.
You also need to develop the DDL SQL scripts to map the ERD model to a DBMS tables. These tables need also to be filled with sample proper data that demonstrate the case. Finally, it is required that you generate at least three SQL scripts that generate some useful reports about the business.
Submit a report containing the following:
1. Business case description.
2. ERD for the selected business case. Use Oracle Data Modeler or Visio