Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please draw an EERD based on following user requirements. Please make sure identify a primary key in each entity. 1. A Customer has following attributes:

Please draw an EERD based on following user requirements.

Please make sure identify a primary key in each entity.

1. A Customer has following attributes: ID , First Name, Last Name, Street, State, Zip Code, Email, Phone, and Has_bought. A customer can have multiple phone numbers 2. An Employee has following attributes: Ssn, FirstName, LastName, Street, State, ZipCode, Email, Phone_number, and number of employees.

3. An Installer has following attributes: milage rate, and inherits Employees attributes.

4. A Sales Person has following attributes: commission rate, and inherits Employees attributes.

5. A Manager has a Start Date attribute, and inherits Employees attributes.

6. A Credit Card has following attibutes: Card Number, Exp-Date, Holder Name, Type, and CRV

. 7. A Ware House has following attributes: Code, Street, State, Zip Code, and PhoneNumber.

8. A part entity has following attributes: SKU, Price, Quantity, and Description.

9. A swing set has following attributes: Size, Type, C_id, S_ssn, and Discount_Rate.

10. Location has following attributes: Code, Street, State, Zip Code, and PhoneNumber.

11. A customer pays with a credit card and a credit card belongs to a customer.

12. A customer may buy multiple swing sets and a swing set is sold to one customer.

13. An employee may works with one or more customers and a customer will be served by one employee.

14. Employees are divided into three types: Installer, Salesperson, and Manager.

15. A customer can make appointment with an installer and a salesperson.

16. Parts are stored in one or more warehouses and a warehouse can store many different parts.

17. Warehouses can be located in many different locations, and a location can have many warehouses.

18. A salesperson may sell many swing sets or none and a swing set will be sold by one sales person.

19. A swing set is composed of many parts and a part can be used in many different swing sets.

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

Database Management System MCQs Multiple Choice Questions And Answers

Authors: Arshad Iqbal

1st Edition

1073328554, 978-1073328550

More Books

Students also viewed these Databases questions

Question

Acceptance of the key role of people in this process of adaptation.

Answered: 1 week ago

Question

preference for well defined job functions;

Answered: 1 week ago