Question: 1 E / R Diagrams and Constraints 1 . ( 2 0 points ) ( a ) ( 1 0 points ) Design an E

1 E/R Diagrams and Constraints1.(20 points)(a)(10 points) 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. A PairOfSkis has attribute sid (key) and model. A Snowboard has attribute sid (key) and model. A Skier owns zero or more PairOfSkis. The ownership relation has a pur-chase_price. A PairOfSkis is owned by at most one Skier. 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 or one Snowboard at the same time. A person cannot rent a PairOfSkis and a Snowboard at the same 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.
I want to know if i managed to do the assignement good, or i need some improvement
1 E / R Diagrams and Constraints 1 . ( 2 0 points

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!