This is a query for anyone with the Hodder Gibson Practive Papers book.
I’ve been teaching my pupils to draw an ER diagram with table names inside rectangles, with lines connected between them with the “crow’s foot” end to indicate the one-to-many relationships.
This was always the case with Higher Information Systems and this is the way SCHOLAR and BBC Bitesize teach the topic. It’s also what the SQA included in the exemplar paper (Q12a answer).
However, in model paper 2 (section 2, Q2) and model paper 3 (section 2, Q2a answer) the ER diagrams are very different; more complex and much more time consuming to draw.
So my questions are…
Do the pupils need to know about this second type of ER diagram?
What type are they expected to draw if asked in the final exam?
Are either accepted?