Topic study hub
Database design and normalisation techniques
Official AQA 7517 section 4.10.3.
0
Objectives
5
Flashcards
7
Questions
36 min
Study time
AqaA LevelComputer ScienceFundamentals of databases
Choose a revision tool
Start revising Database design and normalisation techniques
Syllabus checklist
What you need to know
0 objective pages available
Database design and normalisation techniques1 objectives
- Database design and normalisation techniques: Normalise relations to third normal form. Students should know what properties are possessed by a relation in third normal form. Understand why databases are normalised.
Key terms
Third normal form (3NF)Transitive dependency
Exam tips
- State the dependency clearly: When explaining a normalisation decision, identify the key, state which attribute depends on which, and then explain why a relation should be split.
Common mistakes
- Confusing no duplicate rows with 3NF: Check the dependencies between attributes. A 3NF relation must be in second normal form and must not contain a dependency of one non-key attribute on another non-key attribute.
Practice preview
- Which statement describes a relation in third normal form (3NF)?
- What is a main reason for normalising a database?
- A relation has a composite key made from StudentID and CourseID. Which dependency would be appropriate for an attribute representing a student's grade for that course?
Continue by objective
Objectives are grouped by subtopic so students can jump straight to the exact skill they want to revise.
Related topics