Question: 1 E / R Diagrams and Constraints 1 . ( 2 0 points ) ( a ) ( 1 0 points ) Design an E
ER Diagrams and Constraints pointsa points Design an ER 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 purchaseprice. A PairOfSkis is owned by at most one Skier. A Snowboarder owns zero or more Snowboards. The ownership relation has a purchaseprice. 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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
