I'm creating this database to keep track of my inventory.
1 question is about the tables as follows
1st table = tblMFG (key = mfg_id)
2nd table = tblModel <- this is the main table
3rd table = tblParts (key=part_id)
I know that mfg can make many models = 1 to many
Now my question is for model to parts to model
1 model can have many parts but that one part can be used on many
model. So is the relationship many to many ?
2nd question is that i have 2 more tables to create but not sure if I should incorporate them in tblModel
4th table = tblPower (key = power_id) (but each model can only be 1 type
of power. So its not really redundant)( maybe can make a
drop down list/check box if a good idea)
5th table = tblPDF (key = PDF_id) (each model has its own pdf) (it will be
a hyperlink to somewhere on hdd)
So should i just make 2 tables for the above or just add to the tblModel table since each model will only have one type of power and only one pdf file for now.
If any question feel free to PM or ask.
Thank you for all the help....