Results 1 to 3 of 3

Thread: Database Design

  1. #1
    Join Date
    Sep 2004
    Location
    Florida
    Posts
    13

    Unanswered: Database Design

    Lets say your creating a database. This database is going to hold orders. Here are the parameters of an order.

    • OrderNumber (ID SOMEHOW)
    • ClientID
    • The clientId is unique
  2. But each client could have potentially infinate number of orders. How to handle?
  • ClientName

  • Unique
  • Address

  • not unique
  • eachItem

  • uniqueID
  • price per item

  • not unique
  • numberSold (per line item)

  • not unique
  • subtotal
  • total
  • payment method

  • I would also like to have multiple line items per invoice order number.
    These are the things I would like to keep in a database for my self, how would you go about designing the database to accomplish this goal? Please someone help! BTW I am using access; its a small database right now.
    Reply With Quote Reply With Quote

  • #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Quote Originally Posted by simpleSoft
    But each client could have potentially infinate number of orders. How to handle?
    Orders(order_id*, customer_id, etc)
    Customer(customer_id*, etc)

    To manage multiple line items:

    Order(order_id*, customer_id, etc)
    Product(product_id*, desc, etc)
    Order_line(order_id*, product_id*, qty, etc)
    Last edited by r123456; 11-13-04 at 21:02.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  • #3
    Join Date
    Sep 2004
    Location
    Florida
    Posts
    13
    Order, Product, and Order_Line are all table names?

    And this one is kind of just for fun? Is there a way that the database can auto tally up what was purchased and put it in a field simalar to the way Excel can with functions?
    btw I am new to using access so that is why I am asking, what may seem, stupid questions for you.

  • Posting Permissions

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