Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2015
    Posts
    3

    Unanswered: Computer store DB

    Good Morning

    I am trying to make database in MS access 2013.

    It is kind of Computer store with this tables:

    Costumer:
    -ID
    -name
    -surname
    -street
    -city --------Relation to table CITY: -ID, -CITY
    -email

    Computer:
    -ID
    -price
    -brand----------relation to table Brands: -ID, -Brands

    -RAM(GB)-----------realtion to table RAMs: -ID, -Storage

    -CPU(Gh)------------------relation to table CPUs: -ID, -Speed


    ORDER:
    ID
    ID_costumer ---------------- from costumer.ID
    ID_computer -----------------from computer.ID
    date of purchase
    quantity (how many computer do you want ?)

    total cost -there I want calculated field (computer.price)*(order.quantity) but doesn´t work...


    So is it correct "model" ?
    how to correctly do that total cost ?

    Thank you
    Last edited by kirtap95; 11-19-15 at 14:07.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Is it a correct model, who knows?
    How accurate is this model meant to replicate a computer shop. How detailed should it be. How much of the real world should it replicate.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2015
    Posts
    3
    I thought if it is OK relations, etc.

    Now I have problem:

    In table orders I wanted field "total cost" any idea how I can do that ?

    and tried ´make form to add new costumer, is it possible to make this to start without previous inforations ?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Personally I dont think that your proposed model represents a real world case.
    Why?
    Well im not aware of any computer shop that sells just computers.
    Most computer shops sell computers and other related stuff.
    Big outlets may well shift boxes, but a smaller entity would probably configure a computer to meet customer requirements. Even at the most basic level options could be screen size and or type. Let alone processor type/speed, memory, video card case , motherboard and so on.
    To move onto your order
    Can a customer specify a different delivery address and or invoice address
    Can a customer order more than one type of computer in an order.
    Can a customer negotiate a discount on purchases.

    What actually is your business requirement
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2015
    Posts
    3
    thank you my friend I´d never use it in real life, it is just project into school, so wanted to know if it is OK for this purpose

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Is it fit for that?
    ...I dunno
    I guess it all depends what the assignment actually is
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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