var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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!
Is ServiceCode the pk in Services table? If so, what would be the problem?
Originally Posted by
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