Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please draw an EERD based on the following. Do make sure a primary key is identified for each entity. The customer can have the following:

Please draw an EERD based on the following. Do make sure a primary key is identified for each entity.

  1. The customer can have the following: ID , First Name, Last Name, Street, State, Zip Code, Email, Phone, and Has_bought. A customer can have multiple phone numbers
  2. The employee can have the following: SSN, FirstName, LastName, Street, State, ZipCode, Email, Phone_number, and quantity of employees.
  3. The installer can have the following: mileage rate, and inherits Employees attributes.
  4. The sales person can have the following: commission rate, and inherits Employees attributes.
  5. The manager has the following: Start Date attribute, and inherits Employees attributes.
  6. A credit card number has the following: Card Number, Exp-Date, Holder Name, Type, and CRV.
  7. A warehouse has the following: Code, Street, State, Zip Code, and PhoneNumber.
  8. A part entity has the following: SKU, Price, Quantity, and Description.
  9. A swing set has the following: Size, Type, C_id, S_ssn, and Discount_Rate.
  10. The location has the following: Code, Street, State, Zip Code, and PhoneNumber.
  11. A customer will pay with a credit card and a credit card belongs to a customer.
  12. A customer can 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

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

More Books

Students also viewed these Databases questions