Back to the full dot-point answer
EnglandComputer ScienceQuick questions
1.3 Exchanging data
Quick questions on Relational databases, keys and normalisation to 3NF - OCR A-Level Computer Science H446
3short 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 q1?Show answer
State two problems caused by storing data in a single flat-file table. [2 marks]
What is q2?Show answer
Explain how a many-to-many relationship is implemented in a relational database. [2 marks]
What is q3?Show answer
State the condition a table must meet to be in third normal form, beyond being in 2NF. [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.