Database Concepts

8.1

What the syllabus asks of you

Show understanding of the limitations of using a file- based approach for the storage and retrieval of data
Describe the features of a relational database that address the limitations of a file-based approach
Show understanding of and use the terminology associated with a relational database model
Use an entity-relationship (E-R) diagram to document a database design
Show understanding of the normalisation process
Explain why a given set of database tables are, or are not, in 3NF
Produce a normalised database design for a description of a database, a given set of data, or a given set of tables

Read the notes first

Chapter 8: Database concepts

Open the notes →

Drill this topic

All 14 questions on Database Concepts, untimed — answer on paper, then mark yourself against the mark scheme.

Start drill →

Make a worksheet

Choose the years and how many questions, then print it with the answers on separate pages.

Make a worksheet →

14 questions

These are structured questions, answered in working rather than by picking an option, so they are not listed here one by one. The drill above puts each in front of you with its mark scheme to check against.