Schema Quesiton (1 Viewer)

[Haris]

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

 

[happyhunter]

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.