We need to build up our Car Parts website category structure.
We have a TecDoc database example from which the extract needs to be done.
For this Goal it is required:
1. SQL that returns all MANUFACTURERS
2. SQL that returns all MODELS based on selection from the SQL 1
3. SQL that returns all ENGINE TYPES based on selection from SQL 2
4. SQL that returns all available CATEGORIES and SUB CATEGORIES for the selection from SQL 3
The Database contains about 60 tables.
Unfortunately, we do not know how the information is stored in this relation database.
Our goal is to extract the information from it so that we can build the following Structure:
1. Car Manufacturers ( ex. BMW)
1.1.1 1st Series
188.8.131.52 E87 (02.2003 - 01.2013)
184.108.40.206 E81 (09.2006 - 12.2011)
220.127.116.11.1 List of Diesel Engines
18.104.22.168.2 List of Gasoline Engines
An example on what is expected can be found in the section "SPECIFY YOUR VEHICLE" of the following site:
[login to view URL]
Once the above has been extracted, we should extract All the Categories and Sub-Categories (probable subcategories as well) of Car Parts.
In case you have any questions / suggestions, please let us know.
38 freelancers are bidding on average €150 for this job
Hello Hope you are good. I have 6 year experience in web development and i build hundreds of database for my projects. i'm sure i'll provide you a normalize database which helps you a lot. Thanks
Hello, I have read the details provided and i am positive i can provide quality work,please contact me to discuss more on the project deadline and some other few things
Hello! I am a web developer.(MySQL expert) I have checked your project description. I can help you If you hire me, I am gonna do my best. I guarantee the good result. I will wait for your reply. Thank you.