Back to the full dot-point answer
Northern IrelandSoftware Systems DevelopmentQuick questions
A2 1 Systems Approaches and Database Concepts
Quick questions on Entity relationship modelling and normalisation to 3NF - CCEA A-Level Software Systems Development
4short Q&A pairs drawn directly from our worked dot-point answer. For full context and worked exam questions, read the parent dot-point page.
What is not resolving a many-to-many?Show answer
An M:N relationship (Students to Courses) must be broken into two 1:M relationships via a link table; leaving it as a direct M:N is wrong and causes duplication.
What is q1?Show answer
Name the three types of relationship cardinality. [3 marks]
What is q2?Show answer
State the condition for a table to be in first normal form. [2 marks]
What is q3?Show answer
State what is removed when a table is taken from second normal form to third normal form. [1 mark]
Have a question we have not covered?
This dot-point answer is short enough that we have not extracted many short questions yet. Read the full dot-point answer or ask Mo, our study assistant, in the chat for follow ups.