ZIMSEC A-Level Computer Science
8.4Relational database modelling: analysis and normalisation
Relational database modelling: analysis and normalisation in ZIMSEC A-Level Computer Science: what the syllabus expects you to know, the learning objectives and how to practise.
Subtopic45 practice questions2 lessons
Overview
Normalisation up to second normal form is required by the syllabus.
Learning objectives
What the syllabus expects you to be able to do.
- 8.4.1Design database applications using entity-relationship diagrams (ERDs) and convert ERDs to a relational schema in standard normal form.
- 8.4.2Normalise database tables up to second normal form.
Lessons
- Full access
Entity-relationship diagrams and database design
45 min
- Full access
Normalisation to third normal form
50 min
Join to read every lesson, or see what Full access includes.
Sample question
A sample question on this topic. Answer it, check it, then read the worked answer.
Turn Relational database modelling: analysis and normalisation into a strength.
Practise with instant marking, see your mastery grow and get a study plan built around your exam date.