Back to the full dot-point answer
WalesComputer ScienceQuick questions
Unit 1 Fundamentals of Computer Science
Quick questions on Organisation of data: files, relational databases, normalisation and SQL - WJEC A-Level Computer Science
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 normalisation?Show answer
Normalisation is the process of organising tables to remove redundancy (repeated data) and the anomalies redundancy causes: the insert anomaly (cannot add data without unrelated data), the update anomaly (a change must be made in many places) and the delete anomaly (removing one fact loses another). It splits repeating or dependent data into separate, linked tables.
What is q1?Show answer
State the SQL keyword used to filter the rows returned by a query. [1 mark]
What is q2?Show answer
Give one example of a validation check and state what it tests. [2 marks]
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.