Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can somebody help to answer this questionin erdplus diagram Requirements for the Jones Dozers Construction Equipment Company 1. Jones Dozers want to keep track of

can somebody help to answer this questionin erdplus diagram
image text in transcribed
Requirements for the Jones Dozers Construction Equipment Company 1. Jones Dozers want to keep track of Equipment, Rental, Sales Reps, Equipment Detalis, and Siles 3. For Rental they will keep track of the rental price, date rented and a rental transaction identifici (unique) 4. For Equipment Detail, they will keep track of equipment detall identifier (unique), make model and type. 5. For Sale, they will keep track of the sales transaction identifier (unique), sales price and date. 6. For Customer, they will keep track of a customer identifier (unique), customer name, and customer category. 7. For Sales Rep, they will keep track of a unique sales rep identifer, sales rep name which comprises of first name and last name and rank of the sales rep. 8. Each equipment has one and only one equipment detall, Each equipment detal can be associated with more than one equipment. 9. Each equipment can have many rentals. Each rental is limited to one and only one equipment. 10. Each equipment can be sold via one sale or no sale at all. Each sole must have one and ony one equipment sold. 11. Each rental is conducted by one sales rep. Each sales rep conducts many or no rentals: 12. Each customer can have many rentals or no rentals at all. Each rental involves only one customer. 13. Each customer is involved in many sales or no sales. Each sales involves only one cuttomer: 14. Each sale must be conducted by one sales rep. Each sales rep conducts many or no sales 15. Each sales rep can mentor zero to three proteges, Each sales rep an have one mentor or none

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

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions

Question

18. If you have power, then people will dislike and fear you.

Answered: 1 week ago