DATABASE MODELS
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: Healthcare, Food and Beverage,
Banking, Hospitality, Energy, Shipping, or Human Resources. The one exception is
Education. Do NOT use Education as your industry.
Please note: 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. You can use Word, Excel, or any other tool you like to draw out the diagrams. If
you wish, you can even draw it on papers and scan it, or if necessary take a picture of your
drawing and upload that.
Requirements for the data model:
1. Your database model should consist of at least 5 entities
2. Each entity should consist of at least 3 attributes (up to 7 is encouraged)
3. Provide at least two records (as examples) for each entity to illustrate how data would be
stored
4. Identify relationships between entities (you can use either of the two methods I described
in class)
You must do all four items to get full credit for the project. Assume that the database model is for a
relational database.
