Lukket

Build Category Structure from MySQL DB Dump

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 Models

1.1.1 1st Series

1.1.1.1 E87 (02.2003 - 01.2013)

1.1.1.2 E81 (09.2006 - 12.2011)

1.1.1.2.1 List of Diesel Engines

1.1.1.2.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.

Evner: MySQL, Datasøgning, Databehandling

Se mere: build cms php mysql, create category structure using mysql php, php mysql limited dump testing, mysql category structure, php mysql category structure, mysql script dump tables, build java forms mysql, build inventory database mysql, directory structure mysql php, import mysql 323 dump, hierarchy category structure mysql, sql query tree structure mysql recursive, good mysql category structure, Build web page showing rainfall data from mysql db

Om arbejdsgiveren:
( 0 bedømmelser ) Sofia, Bulgaria

Projekt ID: #20420939

37 freelancere byder i gennemsnit €150 på dette job

hits

I have read through the requirements and am confident of delivering well. Please share the database dump (with some sample data) so that I can study the requirements in its context. Will there be shopping cart functio Flere

€250 EUR in 5 dage
(734 bedømmelser)
8.7
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Flere

€220 EUR in 5 dage
(212 bedømmelser)
7.6
Brightinfotech3

Greetings !! Myself Richa have more than 10 year experience in web development with PHP and php frameworks as well as designing.I read your job description and understand that you are looking good developer who has Flere

€130 EUR in 2 dage
(19 bedømmelser)
5.5
alexwmsoft

100% Completion Rate and 5 Stars Hi, there. My name is Lee, and I am an experienced web developer. I read your job description, and I am interested in your project. I have 6+ years of experiences in developing websit Flere

€140 EUR in 7 dage
(17 bedømmelser)
5.5
hamidejaz024

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

€140 EUR in 3 dage
(45 bedømmelser)
5.4
naravila

Dear Client! I read your description carefully and I am really interested in your project. I am a senior web developer and I have rich experience in PHP. As I am an expert, I know what you really want. I am sure that Flere

€140 EUR in 7 dage
(9 bedømmelser)
5.3
BlackEagle86

Hi, High talented Wordpress , Mobile and Web expert is here! I have read your proposal very carefully and I have come to learn that this job is very suitable for me. I have 7+ years of experience for Mobile app and Web Flere

€140 EUR in 7 dage
(5 bedømmelser)
5.1
dsendra

Hi, I am interested in this project, I specialize in data-mining and data extraction services since 2004. I have powerful data extraction tools or can develop my own. I have extensive experience with SQL and T-SQL si Flere

€250 EUR in 5 dage
(29 bedømmelser)
4.9
dchaidaris

Hello, If you have the database I can extract all the information that you need. Please contact me to inform me in more detail.

€140 EUR in 7 dage
(25 bedømmelser)
4.6
johncodifies

Hello! I can certainly move the categories into WordPress for you. Some questions, please: - Can I see the SQL file please? - Is there an existing WordPress site where the categories are to be imported? - Is the Word Flere

€65 EUR in 2 dage
(17 bedømmelser)
4.5
markninja

Hi, As per your given job description, you want to develop Category Structure from MySQL DB Dump I am available to start your project right [login to view URL], I have questions which I want you to answer. Here are the Flere

€140 EUR in 2 dage
(7 bedømmelser)
4.7
Valuesolutions

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

€140 EUR in 7 dage
(6 bedømmelser)
4.2
dreammate0621

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.

€140 EUR in 7 dage
(7 bedømmelser)
4.4
GauravNargotra

Hi, Hope you are doing well! I have read your job description along and assure you that I am a perfect fit for the job. I have experience with PHP from last 6 years and I have excellent web development skills (HTML5 Flere

€140 EUR in 7 dage
(4 bedømmelser)
4.2
MobileKing1225

Hello Dear. I am very interesting for your project. I am a senior Web developer with high skills in Laravel/Ci/Django/Symfony/Yii/Cakephp framework & Wordpress, Python, Payment Api, WebSite Desgin,eCommerce and mainten Flere

€140 EUR in 7 dage
(8 bedømmelser)
4.0
kashivw

Hello, I am a veteran (25+ years) database developer with real industry experience using MySQL (4.x thru 8.x), Oracle (v6 thru 12c) and SQL Server (v7 thru 17). Serious SQL and database architecture, design skills. Sp Flere

€210 EUR in 7 dage
(9 bedømmelser)
4.2
softcoats

Hi, Please check this link:- [login to view URL] I am Full stack developer having 6 years experience in technologies like Html 5, Css3, Bootstrap, JavaScript, jQuery, JS frameworks, Php, Laravel, WordPress. Lookin Flere

€250 EUR in 7 dage
(4 bedømmelser)
3.9
nidhi1509

Hi, I have 7+ year of experience working in Top IT companies as a Database Developer specifically in MySql and Oracle database. I expertise in writing complex Sql queries, procedures, functions, triggers, views etc. I Flere

€222 EUR in 10 dage
(9 bedømmelser)
3.8
thelastsummer

I am expert in Web designing/developing.I believe that I can be the best productive candidate for this requirement. My skills include : * PHP, CMS, WordPress, Laravel, Codeigniter, yii, Magento, Joomla, Ecommerce, HTM Flere

€140 EUR in 7 dage
(2 bedømmelser)
3.9
faizansaleem1598

Hello, I am a skilled developer with the required expertise. I have read the description of your project and I am sure i can make it done for you. Let's discuss project details in chat. Do visit my recent Projects, Flere

€100 EUR in 7 dage
(5 bedømmelser)
3.3