Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Database set up

Posted on 2016-07-25
5
Medium Priority
?
115 Views
Last Modified: 2016-07-25
Hello experts.
I need help to setup a part of my database.
I want to store the features of vechicles with main and subcategories and after that show for each vechile-category (car, truck,trailer...) there features.
I m using mysql and coldfusion server language.
Any help?
an example-tree  is below:
screen shot of excel
0
Comment
Question by:Panos
  • 3
  • 2
5 Comments
 
LVL 30

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 2000 total points
ID: 41727390
I assume you look for ideas on how to model this?

First criticism: If you enumerate "no climatization", you'd also need "no On-board computer", "no CD player", etc. leave that out, if a vehicle has no climatisation a record of that feature will simply not be added.

The schema should avoid features excluding each other, eg a car either has automatic or manual aircondition, but sensors are not excluding cameras and you might have front, rear, or both cemeras. So actually there is not much exclusion.

You'd need a list of features with feature categorization, so there is a categorization tree, which mainly is about interior/exterior and then different system categories like parking system, multimedia, navigation. The leaf nodes are not categories, they are the core features.


TFeatures
id, name, featurecategory

TFeaturecategories
id, name, parentcategory (NULL for root categories)

TVehicleFeatures
id, vehicleid, Featureid

Bye, Olaf.
0
 
LVL 2

Author Comment

by:Panos
ID: 41727498
Hi.
Thank you for your post.
Can you please explain your last line:
The leaf nodes are not categories, they are the core features
0
 
LVL 30

Accepted Solution

by:
Olaf Doschke earned 2000 total points
ID: 41727675
Well, that's like Product Categories and Products. If you build a tree of categories, the products sort in as leaf nodes in this tree, they belong to the tree, if you like, but they are products and not product categories.

Likewise you have a list of features (=products) and feature categories (=product categories). It is good practice to keep these separate.

Bye, Olaf.

Edit: A littel fix on my propose TFeatures table:
id, name, featurecategoryid

So a feature should be assigned to some featurecategory on the outmost leaf levels of categories. It thereby also is a feature in the category of parent and parentparent featurecategories, etc.

So eg the feature "Front Parking Sensor" is a feature of the Featurecategoiy Parking Sensors. Parking Sensors are an Interior Feature (according to your tree). I'd not consider "Front Parking Sensors" a feature category, as there are no further categories like Left and Right Front Parking Sensors, you can assign this feature to a certain make/model of a specific sensor, therefore it's a feature and not a feature category anymore.

You might only think of the concrete sensors and other devices/modules to be at the leafe nodes of this feature tree, that may also work.
0
 
LVL 2

Author Comment

by:Panos
ID: 41727837
Thank you very much
0
 
LVL 2

Author Closing Comment

by:Panos
ID: 41727846
Thank you
Regards
Panos
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question