Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started