Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need picture of diagram this is thr complete assignment Emerging Electric wishes to create a database with the following entities and attributes: - Customer, with

need picture of diagram image text in transcribed
image text in transcribed
this is thr complete assignment
image text in transcribed
image text in transcribed
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: - Customers can have one or more locations. - Each location can have one or more rates, depending on the time of day. Draw an ERD for this situation and place minimum and maximum cardinalities on the diagram. Also, draw a data model for this situation using the tool you have been told to use in your course. State any assumptions that you have made. 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: - Customers can have one or more locations. - Each location can have one or more rates, depending on the time of day. Draw an ERD for this situation and place minimum and maximum cardinalities on the diagram. Also, draw a data model for this situation using the tool you have been told to use in your course. State any assumptions that you have made

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

More Books

Students also viewed these Databases questions