1. [5 points] Define the following ER model concepts: Entities Attributes Key attribute Weak entity types Relationships 2 [5 points] Innovative Electric wishes to create a database with the following entities and attributes: Customer, with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone. Location, with attributs Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential). Rate, with attributes Rate Class and RatePerKWH. After interviews with the owners, you have come up with the following business rules: Customers can have one or more locations. Each location can have one or more rates, depending on the time of day. Using the notation in the textbook (i.e. rectangular boxes for entities and ovals for attributes) to draw an ER diagram for this situation and place minimum and maximum cardinalities on the diagram. State any assumptions that you have made. 3 [8 points] Cardinality ratios often dictate the detailed design of a database. The cardinality ratio depends on the real-world meaning of the entity types involved and is defined by the specific application. For the binary relationships below, suggest cardinality ratios based on common-sense meaning of the entity types. Clearly state any assumptions you make. Entity 1 Cardinality Ratio Entity 2 1. Student SocialSecurityCard 2. Student Teacher 3. Instructor Office 4. Country CurrentPresident 5. Course TextBook Item (that can be found in an order) Order 7. Student Class 8. Class Instructor 6. 4 [5 points] For Exercise 2 above, build the entity-relationship diagram using a data modeling tool such as Erwin, Rational Rose or others. Use a paragraph to explain the notation you used for model design. Submit your final model in either PDF, PNG, or JPEG