Generate an erd diagram for the given scenario

Assignment Help Computer Engineering

Reference no: EM132116036

Question :

Generate an ERD diagram for the following scenario using Lucidchart. I need to know what the diagram should look like.

(I am not sure there should be any kind of relationship between entities.)

Scenario: Southlands Electric

Southlands Electric wishes to create a database with the following information:

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:

Customers can have one or more locations

Each location can have one or more rates, depending on the time of day

Reference no: EM132116036

Questions Cloud

Intermediate steps to four decimals when possible : Keep intermediate steps to four decimals when possible, then enter your answer to four decimals.

Write any fiction story of your own : Write any fiction story of your own in around 1000 words. Let your imagination flow and try to keep the story funny

What dose ttl logic circuit means : Why i have to use MAX232 when i want to conect Raspberry pi3 with GSM modul SIM808 ?

How might the customer or supplier react : Do research to determine the current status of the RockstarConsortium. Has it been successful? Has it stirred up any further controversy?

Generate an erd diagram for the given scenario : Location with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential)

What is the probability that both say service is poor : You select two customers without replacement to get more information on their satisfaction. What is the probability that both say service is poor?

Write java program for doubly link list : Write java program for doubly link list -Insert a node as a head in a Doubly Linked List.

Feelings about tuition-fee increases : "Which of the following choices best describes your feelings about tuition & fee increases?"

How is this loss allocated for tax purposes : HA3042 Taxation Law Assignment - Holmes Institute Australia. How is this loss allocated for tax purposes? If Joseph and Jane decide to sell the property

User Account

All Pages