Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Unanswered: Database design help

    i would like to store the computer parts in a database in which each part are tied with purchase order so that i can look at the warranty status of any part that i like

    let say a computer1 has hard disk, ram, cdrom, processor

    so all those devices in computer1 can be considered as one component and each of them are tied to purchase order if each of the are bought separately.

    but how do i store in database where some computers can be a component where it itself ties with a purchase order. which mean there is some computer are bought from Dell, HP and etc and not being buildup from parts

    so how to design this database that tied with purchase order?

    thanx.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sounds like a homework assignment

    what have you done so far?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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