Data Set Usage

Data Set Usage

1. Library

   • Library Location
     • Link to other data tables by using the primary as a foreign key
     • Output the exact coordinates to mark map
     • Link information together within the table through primary Location ID1
     • Could be used to process the location inputted by the player
   • Library Information/Details
     • Could be connected to Library Location through foreign key
     • Data that are less useful could be cleaned
     • The library information could be summarised into a paragraph
     • The address of the library could be included

2. Bus Stop

   • Bus Stop Locations
     • Will also output the exact coordinates to mark map
     • Data that are less useful will be cleaned using data-cleaning strategies
     • Link to Bus stop information/Details by using Location ID2 as primary key
     • Could also be used to process the location inputted by the player (for bus)
   • Translink Details
     • Used to consider the ID of each bus stop and hence could be linked to location ID2
     • Can be used to further extend the bus location and information
   • Bus Stop Information/Details
     • The bus stop information could be combined to produce summarised details
     • Data are less useful will be cleaned once more using various data-cleaning techniques
     • The date of last audit could be included but not displayed for the user but instead for the staff members to see