E_R practice1 - Customers can have one or more locations....

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Emerging 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 attributes 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:
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Customers can have one or more locations. Each location can have one or more rates, depending on the time of day. Draw and E-R model for this situation and place minimum and maximum cardinalities on the diagram. Also, draw a database model. State any assumptions that you make....
View Full Document

This note was uploaded on 02/11/2012 for the course CIT 3013 taught by Professor Staff during the Spring '08 term at Arkansas State.

Ask a homework question - tutors are online