Loading…
7 of 7 objectives have lessons · 0 studied · 0 secure
What Cambridge says you should be able to do, in our words. Codes are the topic number plus the objective’s position.
Understand the limitations of using a file-based approach to store and retrieve data.
Taught in: File-based storage and its limitations · 6 questions
Describe the features of a relational database that address the limitations of a file-based approach.
Taught in: Relational databases and the DBMS · 7 questions
Understand and use the terminology associated with a relational database model.
Including entity, table, record, field, tuple, attribute, primary key, candidate key, secondary key, foreign key, relationship (one-to-many, one-to-one, many-to-many), referential integrity and indexing.
Taught in: Relationships and E-R diagrams, Tables, records, fields and keys · 11 questions
Use an entity-relationship (E-R) diagram to document a database design.
Taught in: Relationships and E-R diagrams · 5 questions
Understand the normalisation process.
First Normal Form (1NF), Second Normal Form (2NF) and Third Normal Form (3NF).
Taught in: Normalisation, 1NF and 2NF, Third Normal Form and judging a design · 10 questions
Explain why a given set of database tables is, or is not, in 3NF.
Taught in: Third Normal Form and judging a design · 4 questions
Produce a normalised database design for a description of a database, a given set of data or a given set of tables.
Taught in: Third Normal Form and judging a design · 2 questions