تم الحل ✓
categoryهندسة الحاسبات
schoolبكالوريوس
event_available2026-07-15
السؤال
Transcribed Image Text:
Design an E/R diagram describing the following domain:
⚫ A Person has attributes pid (key) and name.
A Skier is a type of Person with attribute aptitude.
A Snowboarder is a type of Skier.
wwwwwwww
wwwww
⚫ A PairOfSkis has attribute sid (key) and model.
A Snowboard has attribute sid (key) and model.
www
A Skier owns zero or more PairOfSkis. The ownership relation has a purchase price. A
www.
PairOfSkis is owned by at most one Skier.
2
⚫ A Snowboarder owns zero or more Snowboards. The ownership relation has a purchase price. A
Snowboard is owned by at most one Snowboarder.
a Person can rent a PairOfSkis or a Snowboard. A person cannot rent more than one PairOfSkis
wwwwwwww
wwwwwwwwwwwwww wwww www.
or one Snowboard at the same time. A person cannot rent a PairOfSkis and a Snowboard at the same
www
wwwwww
www.wwwwwww
time either. A piece of equipment can be rented by at most one person at a time. The rental comes with
a start date and an end date.
wwwwwww
wwwwww.
check_circle الجواب — حل مفصل خطوة بخطوة
hourglass_top
🔒
الحل الكامل متاح للمشتركين
اشترك في أرشيف الأسئلة لعرض هذا الحل وآلاف الحلول المفصلة خطوة بخطوة من معلمين معتمدين.