Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

er model need help Draw ER diagrams for following Descriptions, all parts are connected to each other. Output of part A will be used in

er model need help

image text in transcribed
Draw ER diagrams for following Descriptions, all parts are connected to each other. Output of part A will be used in part B and will be expanded. Emerging Electric wishes to create a database with the following entities and attributes: A. Customer with customer id, Name, Telephone and Address where address contains Street, City, State and Zip code B. Location with attributes Location ID, Address (where address contains Street, city, state and zip code) and Type (where type can be Value of Business and Residential) After interviewing with the owners, you have come up with following business rules: 1. Customer can have one or more locations and viceversa Make sure all different types of attributes should be marked with different symbols to represent their type like Required, Optional, Derived, Stored, Single Valued, Multi-Values etc

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

A Short Course In Automorphic Functions

Authors: Joseph Lehner

1st Edition

0486799921, 9780486799926

More Books

Students also viewed these Mathematics questions

Question

6. What is desktop management and why is it important?

Answered: 1 week ago