Skip to content
ExamSpine

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]