Answer it
P1 a3 bike share relationships
3 marksYou mark it yourself against the marking points
A city bike-share scheme is designing a database. These facts are true of the scheme.
- Every rider has exactly one membership card, and every card belongs to exactly one rider.
- A station has many docks, and each dock is at exactly one station.
- Over a year, a rider rides many different bikes, and each bike is ridden by many different riders.
Identify the type of relationship (one-to-one, one-to-many or many-to-many) between each pair of entities.
(a) Rider and MembershipCard [1]
(b) Station and Dock [1]
(c) Rider and Bike [1]
[3]