Questionemerging electric wishes to produce a database with

Assignment Help Computer Engineering

Reference no: EM13349253

Question

Emerging Electric wishes to produce a database with the following entities and attributes:

1. Customer, with attributes Customer_ID, Name, Address (Street, City, State, Zip code), Telephone

2. Location, with attributes Location_ID, Address (Street, City, State, Zip code), Type (values of Business or Residential)

3. Rate; with attributes RateClass, Rateperkwh
After interviews with the owners, you have come up with the following business rules-

4. Customers can have one or more locations.

5. Each location is able to have one or more rates, depending on the time of day. Illustrate an ERD for this situation, and place least and utmost cardinalities on the diagram. State any assumption that you have made.

Reference no: EM13349253

Questions Cloud

Questionusing python programming 3 do not use many built in : questionusing python programming 3 do not use many built in functions mainly loops and list manipulations i.e. slicing

Questiondons lumber company on hudson river is one of the : questiondons lumber company on hudson river is one of the oldest retail lumber yards in new york state. it features a

Questionyou work at a high school the high school currently : questionyou work at a high school. the high school currently lost their it specialist and is in method of hiring a new

Question1 write down an application named coins that asks : question1. write down an application named coins that asks user to enter one integer representing a monetary value in

Questionemerging electric wishes to produce a database with : questionemerging electric wishes to produce a database with the following entities and attributes1. customer with

Questionfirst national banks president congratulates you on : questionfirst national banks president congratulates you on successfully managing her network addressing issues. she

Questioncomplete following divide-and-conquer algorithm to : questioncomplete following divide-and-conquer algorithm to determine if all integers in an array an are equal. the

Questionboolean calculator two continue solution program : questionboolean calculator two continue solution program from the preceding exercise by implementing following

Questionstructured and unstructured databest practices in : questionstructured and unstructured databest practices in it change frequently to address new problems and to simplify

User Account

All Pages