Hi to ALL! ,

I'm new here and to DB design, doing some self-study on Database. I've some design question to ask.

Example: if I’m designing program ASP.net program with search function and a DB which can store many Products (PC) and which Product have many Drivers.

How to do i design the DB? I understand that i need to use a linking table in-between but somehow I don't get it.


Following is my design which i think is wrong

Product
PID - PK
PName
and etc

PDLink
PID - FK
DriID - FK

Driver
DriID - PK
DriDesc
DriName
DriType
and etc


Thanks alot in adv

your design is fine

So how do I write my program? cause if one PC can have many drivers and one driver is share by many PC? This is the part that i don't understand. Thxs for your reply anyway.