Is it a typo that the 1NF database OrderID 103 should have ProductID A1? OrderID ProductID ProductName OrderDate101 A1 Widgit 2024-03-01102 A2 Gadget 2024-03-01103 A3 Widgit 2024-03-15
A 3.2.5 Normal FormsHi Stewart Lee. In the 2NF section Table C also contains Quantity.
A 3.2.5 Normal FormsSorry Stewart there was some ghost content that was not showing in the editor that has bled through into the worksheet. I have removed it from the worksheet.
A 3.2.6 Database scenariosHi Michael Brooke, in the A3.2.6 Worksheet handout for Students it goes in the The Initial Data (Unnormalized) table S101, Mr. Webb, Ms Cloak but in the Student handout, for The Initial Data (Unnormalized) table S101, Mr. Webb I...
A 3.2.6 Database scenariosHi Michael Brooke, The Worksheet 2 Answers says in the stage 2NF: Table C (Orders/Linking): TeamID (FK), PartID (FK) However, this changes to in the stage 3NF: Table TeamParts (Linking): TeamID (FK), PartID (FK), Quantity
A 3.2.5 Normal FormsHi Zach. Sorry I am not sure which part you mean. In Part 2 there are three questions and the answer to the third one is [] as there is no 12 as you say.
B 2.4.2 Worksheet Answer KeyHi Chris. In the Teacher Support Material (Pg 62) it says "It is recommended that student work is annotated, or a separate document is created with comments and that a justification is given for the mark awarded for each criterion."
Teacher-Only Guide: Managing the IAUnder part 5. marking and moderation, it says "Help them understand your reasoning by annotating the student's PDF". In the past, we were not allowed to do this. Is this a change moving forward?
Teacher-Only Guide: Managing the IA
Stewart
Hi Michael, I was meant to say the is that feasible to changes the Table name from Table C (Orders/Linking) in 2NF to: Table TeamParts (Linking) in 3NF. I thought the table names stay the same in this instance.
A 3.2.5 Normal Forms