I have 3 table

  1. Partcar
  2. BarbellWheels
  3. Assembly

now, im confused how to manage this table to got connection, cause Partcar and Assembly is many-to-many relationship. But, BarbellWheels will merging with Partcar in Assembly. How to make this 3 table have many-to-many relationship, Partcar and BarbellWheels with Assembly.


there is 5 data on Partcar and must combine to 1 in Assembly and BarbellWheels will combine in Assembly with max 2 data on it. So, this is the link

this is the diagram

any advise? need some help here

EDIT : I forgot to mention the relationship between them. So, 2 tables partcar and BarbellWheels is Many-to-Many with Assembly.

  • 1
    Please explain what "But, BarbellWheels will merging with Partcar in Assembly" means. Or, what is the relationship between BarbellWheels and Partcar? What is the relationship between BarbellWheels and Assembly? – ypercubeᵀᴹ Mar 14 '18 at 7:40
  • @ypercubeᵀᴹ so, BarbellWheels and Partcar is different database but will combine in Assembly, there is no relationship between BarbellWheels and Partcar, they just got combine in Assembly, – Ainal Yaqin Mar 14 '18 at 8:01
  • 1
    Can a BarbellWheel be related to many Partcars or just one? Can a Partcar be related to many BarbellWheels or just one? – ypercubeᵀᴹ Mar 14 '18 at 8:05
  • @ypercubeᵀᴹ BarbellWheel 1 or many to Assembly cause Partcar must assembly 1st, Partcar many to many with Assembly, thats what im thinking. But, if i follow my supervisior, she said the Partcar and BarbellWheels will combine in Assembly. So, what do you think? – Ainal Yaqin Mar 14 '18 at 8:32
  • Your tables do not show the foreign keys that reference other tables. In other words you have not implemented the relationships. – Walter Mitty Mar 29 '18 at 10:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.