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+

  • twgrops - Monday, November 13, 2017 4:12 PM

    ah I had a little look and I understand i need a composite key however I am not allowed to mix it up like that I have to follow the guides they give us and it has got to be 4 tables which is what I have got however I think I went wrong somewhere in normalisation

    I think in Thom's example he didn't write out the Client table because it's fine as is.  I also think he has better table names, and that helps to think about the relationships between items better.  The table you call Price is what he calls Equipment, and the table you call Equipment is what he calls Equipment Order.

    It's probably easiest to think of it in terms of 3 entities, Client, Order, Equipment.  I assume the following relationships exist:
    -  A client can have 0 or more orders, and each order only belongs to 1 client
    -  An order can have 1 or more equipments on it, and each equipment can be on 0 or more orders
    -  Since order and equipment have a many-to-many relationship, there needs to be an intersection table between them