Database Project- Part II: ER Diagram of Prototype Database

Design a prototype database using an illustrative ER diagram, which meets the following criteria:

The design should include at least 4 tables

The tables should have primary keys and must be linked. The link will be through the mechanism of foreign keys (e.g., placing the key from one table as a field in a second table).

Data split into more than one table based on 1:1 or 1:M relationships

Note. Submit the design of your database as an ER diagram. You may use Word, PowerPoint, Creately, LucidCharts, or any other software of your choice to design this diagram. You are not required to design your prototype database in Microsoft Access.