• We have a few events lined up for the October school holidays!
    Watch this space...

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