Business information database

Develop a system that can collect information about businesses and store that information in a database. This system should be written in Ruby (ideally using Rails) and the data should be stored in a MySQL database. • The information attributes that need to be collected is detailed in the table below. • Potential sources of this information are Google, Yelp, TrueLocal, ASIC etc. • The system needs to collect the information on an ongoing basis so new businesses are added and failed businesses are removed from the database. • Initial target locations for businesses are Sydney and Melbourne. Later we will want to add the Australian Capital cities, and eventually all of Australia. Successful delivery of this project will be achieved when: • The database contains information about 5000 or more business. • 60% of the businesses have contact information in the form of an email address and/or a phone number. • Random manual validation of the data shows it to be correct 85% of the time. Attribute Description Name Business Name data_source yelp', 'google_places', etc. Street Street address Suburb Suburb State State Postcode Postcode Country Australia' Website Website URL Facebook Facebook URL Email Contact email address Phone Phone number Lat Location latitude Lng Location longitude yelp_category_ids Yelp category IDs sub_category_ids Business Type (mapped to our subcategories)