Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    4

    Quick Help with beginner database

    Invoice(Receipt_ID, Owner_Phone, Owner_Name, Date_IN, Date_Out, Service_code, Service_Code_Description, Service_Code_Fee, Number_of_pieces, Total_Number_of_Pieces, Total_$_due)



    Owner(Owner_ID, Owner_Phone, Owner_Name)
    Laundry(Laundry_ID, Number_of_Pieces, Owner_ID)
    Services(ServiceCode, Service_Code_Description, Service_Code_Fee)
    Invoice(Receipt_ID, Laundry_ID, Owner_ID, Total_Cash_Due, Date_In,Date_Out)

    My professor said that there was a problem with this when I had submitted it, but Im not sure what it is?

    my solution I think would be to add ServiceCode to invoice, but non-primary key

    So it would look something like

    Invoice(Receipt_ID, Laundry_ID, ServiceCode, Owner_ID, Total_Cash_Due, Date_In,Date_Out)

    Any advice would be appreciated thanks!

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Quote Originally Posted by GaDoomZ View Post
    My professor said that there was a problem with this when I had submitted it, but Im not sure what it is?
    Any advice would be appreciated thanks!
    Is ServiceCode the pk in Services table? If so, what would be the problem?

  3. #3
    Join Date
    Apr 2012
    Posts
    4
    Yeah I listed it as the PrimaryKey in Services table... He said the original was incorrect, and specially stated the Services and ServiceCode. So I assumed it was because I did not have a ServiceCode in the Invoice table

  4. #4
    Join Date
    Apr 2012
    Posts
    4
    bump anyone?

Posting Permissions

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