We need someone who can extract for us all the countries and their corresponding timezones, the phone manufacturers, their corresponding phone models (with pictures) from [url removed, login to view]
The data should all be stored in a MySQL database with the following tables:
1. country: dwi_country (id bigint, name varchar);
2. timezone: dwi_timezone (id bigint, name varchar, country_id) --> country_id referencing to the [url removed, login to view]
3. phone manufacturers: dwi_phone_manufacturer (id bigint, name varchar, logo_url varchar, logo_data blob) --> logo_url will be a path on the file system where the logo will be stored, logo_data will be a blob containing the logo, this means that the logo will be both in the DB and in the file system
4. phone models: dwi_phone_model (id bigint, manufacturer_id bigint, model varchar, model_picture_url varchar, model_picture_data blob) --> manufacturer_id will reference as a FK to the [url removed, login to view], model_picture_url will be a path on the file system where the model picture will be stored, model_picture_data will be a blob containing the model picture, this means that the model picture will be both in the DB and in the file system
The columns names are clear and understandable already, so you will have to make it with them.
No bid of more than 50 USD will be accepted, no bid of more than 2 days will be accepted.