"I'm a Newbie to SQL. I need assistance with my Database layout. I want to create a electronic parts catolgue to hold all the parts of a mulitply vehicles. This is what I have so far. It seems that I will havedata redundency issue but can get around them. An ideas to simply this????

+----------------------------------+
| Tables_in_test4 |
+----------------------------------+
| vehicle |
| groupsection |
| groupsection_has_vehicle |
| parts |
| parts_has_subsection_has_vehicle |
| subsection |
| subsection_has_vehicle |
+----------------------------------+


vehicle

+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| ModelVin | varchar(20) | NO | PRI | NULL | |
| Type | varchar(25) | NO | | NULL | |
| Vin | varchar(15) | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+

groupsection
+-----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| SectionID | varchar(4) | NO | PRI | NULL | |
| Section | varchar(45) | NO | | NULL | |
| GroupID | varchar(4) | NO | PRI | NULL | |
| Group | varchar(45) | NO | | NULL | |
+-----------+-------------+------+-----+---------+-------+

subsection
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| SubSectionID | varchar(4) | NO | PRI | NULL | |
| SubSection | varchar(45) | NO | | NULL | |
+--------------+-------------+------+-----+---------+-------+

parts
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| PartsNo | varchar(15) | NO | PRI | NULL | |
| ItemNo | varchar(3) | NO | | NULL | |
| Desc | varchar(45) | NO | | NULL | |
| Qty | varchar(4) | NO | | NULL | |
| Remark | varchar(45) | YES | | NULL | |
| Pic | varchar(15) | NO | PRI | NULL | |
+---------+-------------+------+-----+---------+-------+



groupsection_has_vehicle

+------------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-------------+------+-----+---------+-------+
| GroupSection_SectionID | varchar(4) | NO | PRI | NULL | |
| GroupSection_GroupID | varchar(4) | NO | PRI | NULL | |
| Vehicle_ModelVin | varchar(20) | NO | PRI | NULL | |
+------------------------+-------------+------+-----+---------


subsection_has_vehicle

+-------------------------+-------------+------+-----+---------
| Field | Type | Null | Key | Default
+-------------------------+-------------+------+-----+---------
| SubSection_SubSectionID | varchar(4) | NO | PRI | NULL
| Vehicle_ModelVin | varchar(20) | NO | PRI | NULL
| GroupSection_SectionID | varchar(4) | NO | PRI | NULL
| GroupSection_GroupID | varchar(4) | NO | PRI | NULL
+-------------------------+-------------+------+-----+---------


parts_has_subsection_has_vehicle
+------------------------------------------------+-------------+------+-----+---
------+-------+
| Field | Type | Null | Key | De
fault | Extra |
+------------------------------------------------+-------------+------+-----+---
------+-------+
| Parts_PartsNo | varchar(15) | NO | PRI | NU
LL | |
| Parts_Pic | varchar(15) | NO | PRI | NU
LL | |
| SubSection_has_Vehicle_SubSection_SubSectionID | varchar(4) | NO | PRI | NU
LL | |
| SubSection_has_Vehicle_Vehicle_ModelVin | varchar(20) | NO | PRI | NU
LL | |
| SubSection_has_Vehicle_GroupSection_SectionID | varchar(4) | NO | PRI | NU
LL | |
| SubSection_has_Vehicle_GroupSection_GroupID | varchar(4) | NO | PRI | NU
LL | |
+------------------------------------------------+-------------+------+-----+---"