Results 1 to 2 of 2

Thread: Schema Quesiton

  1. #1
    Cadet
    Join Date
    May 2014
    HSC
    2016
    Gender
    Male
    Posts
    30
    Rep Power
    4

    Question Schema Quesiton

    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

  2. #2
    Cadet happyhunter's Avatar
    Join Date
    Jul 2013
    HSC
    2015
    Gender
    Male
    Posts
    88
    Rep Power
    4

    Re: Schema Quesiton

    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.
    HSC - 2015 - ATAR Goal: 80+ ATAR Achieved: 87.30

    UNSW: Bachelor of Information Systems

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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