Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: Relational Database

    I'm creting a database for school, but im having troubles. If tere are any good DB people here, could you please help.

    I am creating a database about Importing Japanese Cars involving the customers, Orders and Prices, for Japanese Sports (Made up company) and i got no idea how to do the relationships.

    I have the following Tables:

    <u>Customer</u>
    Customer ID
    Firstname
    Surname
    Postcode
    Address

    <u>Order</u>
    Order ID
    Customer ID
    Car ID

    (i think i need more in here)

    <u>Car</u>
    Car ID
    Model
    Make
    Colour
    Transmission
    Price
    Extras

    Now i dont know if i need a transaction table or not as i dont know much about these sorts of things. Now im in a real dilemma at the moment, sorry, im stressed out cause of exams and everything and i really need help, hehe.

    Thankyou, if you need any more information please reply back to this thread.

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    so far so good: everything looks fine

    (but do yourself a favour and DON'T use spaces (or hyphens) in field names - they'll come back to haunt you later).

    <u>Customer</u>
    Customer ID Primary Key
    Firstname
    Surname
    Postcode
    Address

    <u>Order</u>
    Order ID Primary Key
    Customer ID
    Car ID

    (i think i need more in here)

    <u>Car</u>
    Car ID Primary Key
    Model
    Make
    Colour
    Transmission
    Price
    Extras

    and use the lookup thingy when designing Order
    and use [ not <

    ...should work fine. izy

Posting Permissions

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