Create a program/script/plugin to gather data from 3 Websites : [login to view URL], [login to view URL] and 99firms.com.
All the data should be properly formatted and put into mysql relational database.
The resulting database should contain list of all the companies, with all their details and categories.
We will provide sample mysql database structure. You can use it as a reference. If some columns or tables are missing, you can add them. Databse should be highly normalized.
All the data of all the companies from these 3 sites should be collected. No data, or part of data should be missed, and it should be stored with relations.
PHP Script is preferred, as we need to integrate it into laravel. If not possible, You can use any technology for this. For us, data is more important.
You can add a column to mention that the data is from which site.
Also, remove duplicates, and merge the information from duplicates
Total timeline of project is 7 Days