تم الحل ✓
categoryقواعد البيانات وإدارة البيانات
schoolبكالوريوس
event_available2026-07-15
السؤال
Transcribed Image Text:
Create a simple ERD for a car dealership. Convert the diagram to a PDF file. The dealership sells both new
and used cars, and it operates a service facility. Base your design on the following business rules:
A salesperson may sell many cars, but each car is sold by only one salesperson.
• A customer may buy many cars, but each car is bought by only one customer.
Asalesperson writes a single invoice for each car he or she sells.
A customer gets an invoice for each car he or she buys.
A customer may come in just to have his or her car serviced; that is, a customer need not buy a car to
be classified as a customer.
• When a customer takes one or more cars in for repair or service, one service ticket is written for each
car.
The car dealership maintains a service history for each of the cars serviced. The service records are
referenced by the car's serial number.
A car brought in for service can be worked on by many mechanics, and each mechanic may work on
many cars.
A car that is serviced may or may not need parts (e.g., adjusting a carburetor or cleaning a fuel injector
nozzle does not require providing new parts).
Previous
1
check_circle الجواب — حل مفصل خطوة بخطوة
hourglass_top
🔒
الحل الكامل متاح للمشتركين
اشترك في أرشيف الأسئلة لعرض هذا الحل وآلاف الحلول المفصلة خطوة بخطوة من معلمين معتمدين.