Home Forums SQL Server 2008 Working with Oracle Need help/ push in right direction with assignment 3NF, Composite Key to SQL+ RE: Need help/ push in right direction with assignment 3NF, Composite Key to SQL+

  • November 13, 2017 at 4:00 pm

    #1967882

    Chris Harshman - Monday, November 13, 2017 3:12 PM

    OK, here's a couple of questions for you to think about:
    1.  Can you have an Equipment row without an Order?
    2.  How many Order rows can an Equipment row relate to?

    Thank you for the reply
    1. I just realised equipment table has the quantity so it can't exist without an order, however equipment itself exists in price table without an order.
    2. an Order can have 1 or more equipment and I am a bit confused to the link back will try figure it out and report back.