QUESTION 2

1. The database table structure below captures Students that commute to the University by bike (Student Bike-Commuter table). Each student is assigned one Bike Storage Building where they can store their bike and access facilities like change rooms and a locker. A Bike Storage Building can have many students.

   What is the most appropriate Foreign Key and where should we place the Foreign Key in this table structure so that we can link the two tables?

   (30 words maximum)

   Student Bike-Commuter table
   Student_id	Student_name
   245	Bob Smith
   265	Xi Wang
   987	Anthony Marshall

   Bike Storage Building table
   Building_id	Location	Open hours
   001	Diamond Building	09:00-17:00
   002	Jade Building	06:00-24:00
   003	Blue Building	06:00-24:00
   004	Gold Building	09:00-17:00