Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    2

    Question Need Help{NooB QN}

    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 Im 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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    your design is fine
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2009
    Posts
    2
    Quote Originally Posted by r937
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •