• We need YOUR help for the next generation of students! Upload your notes and exams on our Notes & Resources page!
  • You must be a registered member to download resources

Schema Quesiton (1 Viewer)

Haris

Member
Joined
May 6, 2014
Messages
30
Gender
Male
HSC
2016
When doing the 2013 past paper question 24 B ask to construct a schema, I did so however I had all my related tables in my customer table instead of invoice, so instead of having employee_ID,Order_ID and such in the invoice table I had it in the customer table, is this this correct.
Sample answer
Capture.PNG
 

happyhunter

Member
Joined
Jul 30, 2013
Messages
88
Gender
Male
HSC
2015
I don't 100% understand but it seems like the Customer would not know the Employee_ID and it would only be need by the employee and the invoice itself.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top