Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Emerging Electric wishes to create a database with the following entities and attributes: - Customer, with attributes Customer ID, Name, Address (Street, City, State, Zip

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 Residentiai). - 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_2

Step: 3

blur-text-image_3

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

T Sql Window Functions For Data Analysis And Beyond

Authors: Itzik Ben Gan

2nd Edition

0135861446, 978-0135861448

Students also viewed these Databases questions

Question

How is legality different from ethics?

Answered: 1 week ago

Question

What is the business opportunity in the creation of virtual humans?

Answered: 1 week ago