Results 1 to 3 of 3

Thread: database design

  1. #1
    Join Date
    Mar 2007
    Posts
    45

    database design

    Hello everyone,

    I am working on a computer inventory store database. The store will consist of the following items:

    Laptops, Desktops, Servers, PDA's

    few of the entities and attributes for a computer store:

    Code:
    Computers(ser_num, year, make, model, qoh, qty_sold, list_price, cost_price)
    I would also need a supplier for the items so I have:

    Code:
    Suppliers( sup_id, year, make, model, qoh, cost_price)
    looking for some other ideas and suggestions for this database?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    customers, orders, invoices...
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2007
    Posts
    45
    Here is what I have created so far. I am not worried about the attributes yet I am only interested in the entities and relationships for now:

    http://i244.photobucket.com/albums/gg5/robasc/computerstore.jpg?t=1268076962

Posting Permissions

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