Create an ER model (using IE Crows foot notation) with at least seven entities that depict any industry scenario or personal undertaking. Include no more than seven fields in each of the table structures. Make sure to show the maximum and minimum cardinalities for each relationship.

Describe the scenario and each entity. Identify the assumptions and business rules used in your model for each relationship. (For example, each customer can visit one or more stores.) (This part accounts 50% of the question B grade)

Logical Design: Convert the model into a set of tables (using database design steps covered in lecture 4) to choose the primary keys and add foreign keys using the following notation: For example: an employee table can be expressed as: employee (ssn, name, address, dept_no)