Exploration of Database

Exploration of Database

1. Companion Card Venue

   • Pros
     • Convient for disabled user
       • Able to attract more users from the assistant of siabled user
       • Increase the chance of disabled tourism
     • Includes detailed data
       • Phone number of the location
       • Category
         • Useful for filter purposes
       • Address
       • Id
         • Primary Key
       • Website
   • Cons
     • Limited user market
       • Non-disabled people not required
     • No location name
       • Hard to identify the location

2. National Public Toliet Map

   • Pros
     • Very detailed data
       • Ambulant
       • Babychange
       • Accessibility
       • Longitude and latitude
   • Cons
     • Not as neccessary for tourism
       • Hard to attract target audience
     • Too much data may be hard to handle
       • Increase in the possibility of data anomaly
       • Some data are unessarry and hard to interprete

3. Business Discount Directory for Senior and Carer Cardholders

   • Pros
     • Detailed Data
       • Detailed info such as discount amount
         • Useful for filter purposes
       • Address
       • Website Link
         • Easy for user to access
   • Cons
     • No Primary key
       • Hard to identify each row of data
     • Replication in Data
       • May Cause Data anomaly

4. Townsville Inclusive Parks

   • Pros
     • Detailed data
       • Disability facilities
         • Filter purposes
       • Accessibility
       • Specifc address
     • Untapped market
       • Less competitor
   • Cons
     • No primary key
       • Increase the chance of data anomaly
     • Insuffiecient of data
       • No specifc latitude and longitude was included

5. Indigenous tourism experiences

   • Cons
     • Insufficient of data
       • Only two columns
       • No Specific Address
       • No Primary Key
   • Pros
     • Untapped Market
       • Less competitor

6. Australian heritage database

   • Pros
     • Broad database
       • Contains data from wide range of list
     • Advanced search option
       • Convient for filter purposes
   • Cons
     • No csv format
       • Hard to use and intepret
     • Insufficient data
       • Only three columns

7. Brisbane City Council Events Locations

   • Pros
     • Includes detailed data
       • Specific venue name
       • Venue type
         • For filter purposes
   • Cons
     • No primary key
       • May result in data anomaly
     • No specific event name
       • Harder for user to interpret

8. Brisbane City Council Events

   • Pros
     • Detailed data
       • Website links
         • Easy for user to access
       • Events details
       • Specific events state
         • Effective for filter purposes
   • Cons
     • Replication in data
       • Templates data contains many replications
     • Hard to process primary key
       • The event ID contains too much decimal place