DATABASE MODELS

Your team assignment is to design a database. You do NOT need to build a database using a database tool like MS Access. Instead, you will design a database by creating a database model. As you may recall from class, a database model describes which manner data can be stored, organized and manipulated.

Assume you are the owner of a company or organization. Your task is to design a database to store information relevant to your business operation. You can be in any industry you like. Examples of industries could include, but are not limited to, Education, Healthcare, Food and Beverage, Banking, Hospitality, Energy, Shipping, or Human Resources. Decide as a team on your industry.

Requirements for the data model:

-Your database model should consist of at least 5 entities

-Each entity should consist of at least 3 attributes (up to 7 is encouraged)

-Provide at least two records (as examples) for each entity to illustrate how data would be stored

-Identify relationships between entities

Assume that the database model is for a relational database.