Draw an erd for situation showing entities and attributes

Assignment Help Database Management System
Reference no: EM131628953

Assignment

Case

Emerging Electric wishes to create a database to be used for data regarding Customers, Locations of service, and Rates applicable. After some initial analysis, it has been established that at a minimum the following entities and attributes are needed:

• 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.
• Customers are required to have service at least at one Location.
• Each Location is required to have at least one rate.

Deliverables

1. Draw an ERD for this situation showing entities, attributes, identifiers, and relationships with minimum and maximum cardinalities. This is the Conceptual Data Model. Examples can be found in Chapter 2 of the textbook. State any assumptions that you have made.

2. Build the Logical Relational Data Model. If many to many relationships exist in the Conceptual Data Model ERD you built above, I suggest you replace them with associative entities before mapping the ERD to a relational model.

Report Presentation

1. Report must be in a Microsoft Word document with both deliverables listed above.

2. Microsoft Word shapes can be used to build both the ERD and the Relational model diagram requested above; however, there are many more tools available. Regardless of the tool, diagrams must be pasted on the Word document.

3. Hand-drawn diagrams are not acceptable.

4. Important: start working on it immediately after day of class; you may not finish, but questions will pop up that you can then get answered in class.

Reference no: EM131628953

Questions Cloud

Arithmetic average return on crash-n-burn stock : What was the arithmetic average return on Crash-n-Burn’s stock over this five-year period?
Find the need to convert whole-life insurance policy : At 30 years old, Jaime Dawson finds the need to convert his whole-life insurance policy of $500,000 to extended term coverage with the same face value.
Calculate the dollar value of interest-bearing liabilities : Balance Sheet MHM Bank Assets Liabilities and Equity Cash and due from banks $ 1,950. Calculate the dollar value of MHM’s interest-bearing liabilities.
Review the case problem related to the vehicle : John Malinowsky has auto insurance with 100/300/100 liability coverage. His vehicle is 12 years old and is in model class 2. John lives in territory 1.
Draw an erd for situation showing entities and attributes : Draw an ERD for this situation showing entities, attributes, identifiers, and relationships with minimum and maximum cardinalities.
Write the equations of motion in matrix format : A 2DOF system is shown (M=1 lb-sec2/in, c=10 lb-se/in, k=10000 lb/in); Write the equations of motion in matrix format
What income withdrawal method : What income withdrawal method would you choose for a couple that just started retirement with a portfolio value of 1 million and can cover most expense?
Changed dramatically for families headed by asians : According to HFS Essay 1, financial patterns have changed dramatically for families headed by Asians. Asian families' median income has
Describe the main agents of socialization to contribute : Describe the main agents of socialization to contribute to social. reproduction.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd