Database Concepts

Show understanding of the limitations of using a file-based approach for the storage and retrieval of data

9608_s21_qp_12_sc_4.a

9608_s21_qp_12_sc_4.a Question Image

Answer

9608_s21_qp_12_sc_4.a Mark Scheme Image

9608_s20_qp_11_sc_7.a

9608_s20_qp_11_sc_7.a Question Image

Answer

9608_s20_qp_11_sc_7.a Mark Scheme Image

9608_w19_qp_12_sc_4.a.i

9608_w19_qp_12_sc_4.a.i Question Image

Answer

9608_w19_qp_12_sc_4.a.i Mark Scheme Image

9608_s19_qp_12_sc_5.a.i

9608_s19_qp_12_sc_5.a.i Question Image

Answer

9608_s19_qp_12_sc_5.a.i Mark Scheme Image

9608_s19_qp_11_sc_2.b.i

9608_s19_qp_11_sc_2.b.i Question Image

Answer

9608_s19_qp_11_sc_2.b.i Mark Scheme Image

9608_w16_qp_12_sc_9.a

9608_w16_qp_12_sc_9.a Question Image

Answer

9608_w16_qp_12_sc_9.a Mark Scheme Image

9608_s16_qp_12_sc_8.a.iv

9608_s16_qp_12_sc_8.a.iv Question Image

Answer

9608_s16_qp_12_sc_8.a.iv Mark Scheme Image

9608_s16_qp_11_sc_8.a.iv

9608_s16_qp_11_sc_8.a.iv Question Image

Answer

9608_s16_qp_11_sc_8.a.iv Mark Scheme Image

Describe the features of a relational database that address the limitations of a file-based approach

9608_s20_qp_11_sc_7.a

9608_s20_qp_11_sc_7.a Question Image

Answer

9608_s20_qp_11_sc_7.a Mark Scheme Image

9608_w19_qp_12_sc_4.a.i

9608_w19_qp_12_sc_4.a.i Question Image

Answer

9608_w19_qp_12_sc_4.a.i Mark Scheme Image

9608_s19_qp_12_sc_5.a.ii

9608_s19_qp_12_sc_5.a.ii Question Image

Answer

9608_s19_qp_12_sc_5.a.ii Mark Scheme Image

9608_w16_qp_12_sc_9.a

9608_w16_qp_12_sc_9.a Question Image

Answer

9608_w16_qp_12_sc_9.a Mark Scheme Image

9608_s16_qp_12_sc_8.a.iv

9608_s16_qp_12_sc_8.a.iv Question Image

Answer

9608_s16_qp_12_sc_8.a.iv Mark Scheme Image

9608_s16_qp_11_sc_8.a.iv

9608_s16_qp_11_sc_8.a.iv Question Image

Answer

9608_s16_qp_11_sc_8.a.iv Mark Scheme Image

Show understanding of and use the terminology associated with a relational database model

9608_s21_qp_13_sc_8.b

9608_s21_qp_13_sc_8.b Question Image

Answer

9608_s21_qp_13_sc_8.b Mark Scheme Image

9608_s21_qp_11_sc_5.a

9608_s21_qp_11_sc_5.a Question Image

Answer

9608_s21_qp_11_sc_5.a Mark Scheme Image

9608_s21_qp_11_sc_5.b

9608_s21_qp_11_sc_5.b Question Image

Answer

9608_s21_qp_11_sc_5.b Mark Scheme Image

9608_s20_qp_13_sc_6.a

9608_s20_qp_13_sc_6.a Question Image

Answer

9608_s20_qp_13_sc_6.a Mark Scheme Image

9608_s20_qp_12_sc_6.b

9608_s20_qp_12_sc_6.b Question Image

Answer

9608_s20_qp_12_sc_6.b Mark Scheme Image

9608_w19_qp_13_sc_3.a.i

9608_w19_qp_13_sc_3.a.i Question Image

Answer

9608_w19_qp_13_sc_3.a.i Mark Scheme Image

9608_w19_qp_13_sc_3.a.ii

9608_w19_qp_13_sc_3.a.ii Question Image

Answer

9608_w19_qp_13_sc_3.a.ii Mark Scheme Image

9608_w19_qp_13_sc_3.a.iii

9608_w19_qp_13_sc_3.a.iii Question Image

Answer

9608_w19_qp_13_sc_3.a.iii Mark Scheme Image

9608_w19_qp_11_sc_4.d.i

9608_w19_qp_11_sc_4.d.i Question Image

Answer

9608_w19_qp_11_sc_4.d.i Mark Scheme Image

9608_w19_qp_11_sc_4.d.ii

9608_w19_qp_11_sc_4.d.ii Question Image

Answer

9608_w19_qp_11_sc_4.d.ii Mark Scheme Image

9608_w19_qp_11_sc_4.d.iii

9608_w19_qp_11_sc_4.d.iii Question Image

Answer

9608_w19_qp_11_sc_4.d.iii Mark Scheme Image

9608_w19_qp_11_sc_4.d.iv

9608_w19_qp_11_sc_4.d.iv Question Image

Answer

9608_w19_qp_11_sc_4.d.iv Mark Scheme Image

9608_s19_qp_13_sc_3.b

9608_s19_qp_13_sc_3.b Question Image

Answer

9608_s19_qp_13_sc_3.b Mark Scheme Image

9608_s19_qp_11_sc_2.c.i

9608_s19_qp_11_sc_2.c.i Question Image

Answer

9608_s19_qp_11_sc_2.c.i Mark Scheme Image

9608_s19_qp_11_sc_2.c.ii

9608_s19_qp_11_sc_2.c.ii Question Image

Answer

9608_s19_qp_11_sc_2.c.ii Mark Scheme Image

9608_w18_qp_11_sc_7.b

9608_w18_qp_11_sc_7.b Question Image

Answer

9608_w18_qp_11_sc_7.b Mark Scheme Image

9608_s18_qp_12_sc_7.a.i

9608_s18_qp_12_sc_7.a.i Question Image

Answer

9608_s18_qp_12_sc_7.a.i Mark Scheme Image

9608_s18_qp_12_sc_7.b

9608_s18_qp_12_sc_7.b Question Image

Answer

9608_s18_qp_12_sc_7.b Mark Scheme Image

9608_w17_qp_13_sc_7.a.i

9608_w17_qp_13_sc_7.a.i Question Image

Answer

9608_w17_qp_13_sc_7.a.i Mark Scheme Image

9608_w17_qp_13_sc_7.b

9608_w17_qp_13_sc_7.b Question Image

Answer

9608_w17_qp_13_sc_7.b Mark Scheme Image

9608_w17_qp_13_sc_7.c.i

9608_w17_qp_13_sc_7.c.i Question Image

Answer

9608_w17_qp_13_sc_7.c.i Mark Scheme Image

9608_w17_qp_13_sc_7.d.ii

9608_w17_qp_13_sc_7.d.ii Question Image

Answer

9608_w17_qp_13_sc_7.d.ii Mark Scheme Image

9608_w17_qp_12_sc_7.a.i

9608_w17_qp_12_sc_7.a.i Question Image

Answer

9608_w17_qp_12_sc_7.a.i Mark Scheme Image

9608_w17_qp_12_sc_7.a.ii

9608_w17_qp_12_sc_7.a.ii Question Image

Answer

9608_w17_qp_12_sc_7.a.ii Mark Scheme Image

9608_w17_qp_12_sc_7.b

9608_w17_qp_12_sc_7.b Question Image

Answer

9608_w17_qp_12_sc_7.b Mark Scheme Image

9608_w17_qp_12_sc_7.c.ii

9608_w17_qp_12_sc_7.c.ii Question Image

Answer

9608_w17_qp_12_sc_7.c.ii Mark Scheme Image

9608_s17_qp_13_sc_1.a

9608_s17_qp_13_sc_1.a Question Image

Answer

9608_s17_qp_13_sc_1.a Mark Scheme Image

9608_s17_qp_13_sc_1.b.i

9608_s17_qp_13_sc_1.b.i Question Image

Answer

9608_s17_qp_13_sc_1.b.i Mark Scheme Image

9608_s17_qp_13_sc_1.b.ii

9608_s17_qp_13_sc_1.b.ii Question Image

Answer

9608_s17_qp_13_sc_1.b.ii Mark Scheme Image

9608_s17_qp_13_sc_1.c.i

9608_s17_qp_13_sc_1.c.i Question Image

Answer

9608_s17_qp_13_sc_1.c.i Mark Scheme Image

9608_s17_qp_13_sc_1.c.ii

9608_s17_qp_13_sc_1.c.ii Question Image

Answer

9608_s17_qp_13_sc_1.c.ii Mark Scheme Image

9608_s17_qp_12_sc_1.a

9608_s17_qp_12_sc_1.a Question Image

Answer

9608_s17_qp_12_sc_1.a Mark Scheme Image

9608_s17_qp_12_sc_1.b.ii

9608_s17_qp_12_sc_1.b.ii Question Image

Answer

9608_s17_qp_12_sc_1.b.ii Mark Scheme Image

9608_s17_qp_12_sc_1.b.iii

9608_s17_qp_12_sc_1.b.iii Question Image

Answer

9608_s17_qp_12_sc_1.b.iii Mark Scheme Image

9608_s17_qp_11_sc_1.a

9608_s17_qp_11_sc_1.a Question Image

Answer

9608_s17_qp_11_sc_1.a Mark Scheme Image

9608_s17_qp_11_sc_1.b.i

9608_s17_qp_11_sc_1.b.i Question Image

Answer

9608_s17_qp_11_sc_1.b.i Mark Scheme Image

9608_s17_qp_11_sc_1.b.ii

9608_s17_qp_11_sc_1.b.ii Question Image

Answer

9608_s17_qp_11_sc_1.b.ii Mark Scheme Image

9608_s17_qp_11_sc_1.c.i

9608_s17_qp_11_sc_1.c.i Question Image

Answer

9608_s17_qp_11_sc_1.c.i Mark Scheme Image

9608_s17_qp_11_sc_1.c.ii

9608_s17_qp_11_sc_1.c.ii Question Image

Answer

9608_s17_qp_11_sc_1.c.ii Mark Scheme Image

9608_w16_qp_13_sc_1.a

9608_w16_qp_13_sc_1.a Question Image

Answer

9608_w16_qp_13_sc_1.a Mark Scheme Image

9608_w16_qp_13_sc_1.b

9608_w16_qp_13_sc_1.b Question Image

Answer

9608_w16_qp_13_sc_1.b Mark Scheme Image

9608_w16_qp_11_sc_1.a

9608_w16_qp_11_sc_1.a Question Image

Answer

9608_w16_qp_11_sc_1.a Mark Scheme Image

9608_w16_qp_11_sc_1.b

9608_w16_qp_11_sc_1.b Question Image

Answer

9608_w16_qp_11_sc_1.b Mark Scheme Image

9608_s16_qp_13_sc_5.c.ii

9608_s16_qp_13_sc_5.c.ii Question Image

Answer

9608_s16_qp_13_sc_5.c.ii Mark Scheme Image

9608_s16_qp_13_sc_5.c.iii

9608_s16_qp_13_sc_5.c.iii Question Image

Answer

9608_s16_qp_13_sc_5.c.iii Mark Scheme Image

9608_s16_qp_12_sc_8.b.i

9608_s16_qp_12_sc_8.b.i Question Image

Answer

9608_s16_qp_12_sc_8.b.i Mark Scheme Image

9608_s16_qp_12_sc_8.b.ii

9608_s16_qp_12_sc_8.b.ii Question Image

Answer

9608_s16_qp_12_sc_8.b.ii Mark Scheme Image

9608_s16_qp_11_sc_8.b.i

9608_s16_qp_11_sc_8.b.i Question Image

Answer

9608_s16_qp_11_sc_8.b.i Mark Scheme Image

9608_s16_qp_11_sc_8.b.ii

9608_s16_qp_11_sc_8.b.ii Question Image

Answer

9608_s16_qp_11_sc_8.b.ii Mark Scheme Image

9608_s15_qp_12_sc_9.c.i

9608_s15_qp_12_sc_9.c.i Question Image

Answer

9608_s15_qp_12_sc_9.c.i Mark Scheme Image

9608_s15_qp_11_sc_9.c.i

9608_s15_qp_11_sc_9.c.i Question Image

Answer

9608_s15_qp_11_sc_9.c.i Mark Scheme Image

Use an entity-relationship (E-R) diagram to document a database design

9608_w21_qp_11_sc_9.a

9608_w21_qp_11_sc_9.a Question Image

Answer

9608_w21_qp_11_sc_9.a Mark Scheme Image

9608_s21_qp_13_sc_8.a

9608_s21_qp_13_sc_8.a Question Image

Answer

9608_s21_qp_13_sc_8.a Mark Scheme Image

9608_s21_qp_11_sc_5.a

9608_s21_qp_11_sc_5.a Question Image

Answer

9608_s21_qp_11_sc_5.a Mark Scheme Image

9608_s20_qp_11_sc_7.b

9608_s20_qp_11_sc_7.b Question Image

Answer

9608_s20_qp_11_sc_7.b Mark Scheme Image

9608_w19_qp_12_sc_4.b.i

9608_w19_qp_12_sc_4.b.i Question Image

Answer

9608_w19_qp_12_sc_4.b.i Mark Scheme Image

9608_s19_qp_13_sc_3.c

9608_s19_qp_13_sc_3.c Question Image

Answer

9608_s19_qp_13_sc_3.c Mark Scheme Image

9608_w18_qp_11_sc_7.a

9608_w18_qp_11_sc_7.a Question Image

Answer

9608_w18_qp_11_sc_7.a Mark Scheme Image

9608_s18_qp_13_sc_2.a

9608_s18_qp_13_sc_2.a Question Image

Answer

9608_s18_qp_13_sc_2.a Mark Scheme Image

9608_s18_qp_12_sc_7.a.ii

9608_s18_qp_12_sc_7.a.ii Question Image

Answer

9608_s18_qp_12_sc_7.a.ii Mark Scheme Image

9608_w17_qp_13_sc_7.a.ii

9608_w17_qp_13_sc_7.a.ii Question Image

Answer

9608_w17_qp_13_sc_7.a.ii Mark Scheme Image

9608_w17_qp_12_sc_7.a.ii

9608_w17_qp_12_sc_7.a.ii Question Image

Answer

9608_w17_qp_12_sc_7.a.ii Mark Scheme Image

9608_s17_qp_13_sc_1.a

9608_s17_qp_13_sc_1.a Question Image

Answer

9608_s17_qp_13_sc_1.a Mark Scheme Image

9608_s17_qp_13_sc_1.c.iii

9608_s17_qp_13_sc_1.c.iii Question Image

Answer

9608_s17_qp_13_sc_1.c.iii Mark Scheme Image

9608_s17_qp_12_sc_1.a

9608_s17_qp_12_sc_1.a Question Image

Answer

9608_s17_qp_12_sc_1.a Mark Scheme Image

9608_s17_qp_12_sc_1.b.i

9608_s17_qp_12_sc_1.b.i Question Image

Answer

9608_s17_qp_12_sc_1.b.i Mark Scheme Image

9608_s17_qp_11_sc_1.c.iii

9608_s17_qp_11_sc_1.c.iii Question Image

Answer

9608_s17_qp_11_sc_1.c.iii Mark Scheme Image

9608_w16_qp_12_sc_9.b

9608_w16_qp_12_sc_9.b Question Image

Answer

9608_w16_qp_12_sc_9.b Mark Scheme Image

9608_s16_qp_13_sc_5.c.i

9608_s16_qp_13_sc_5.c.i Question Image

Answer

9608_s16_qp_13_sc_5.c.i Mark Scheme Image

Show understanding of the normalisation process

9608_s21_qp_12_sc_4.b

9608_s21_qp_12_sc_4.b Question Image

Answer

9608_s21_qp_12_sc_4.b Mark Scheme Image

9608_w19_qp_12_sc_4.a.ii

9608_w19_qp_12_sc_4.a.ii Question Image

Answer

9608_w19_qp_12_sc_4.a.ii Mark Scheme Image

9608_s19_qp_13_sc_3.d

9608_s19_qp_13_sc_3.d Question Image

Answer

9608_s19_qp_13_sc_3.d Mark Scheme Image

9608_s18_qp_12_sc_7.c

9608_s18_qp_12_sc_7.c Question Image

Answer

9608_s18_qp_12_sc_7.c Mark Scheme Image

9608_s15_qp_12_sc_9.a

9608_s15_qp_12_sc_9.a Question Image

Answer

9608_s15_qp_12_sc_9.a Mark Scheme Image

9608_s15_qp_12_sc_9.b

9608_s15_qp_12_sc_9.b Question Image

Answer

9608_s15_qp_12_sc_9.b Mark Scheme Image

9608_s15_qp_12_sc_9.c.iii

9608_s15_qp_12_sc_9.c.iii Question Image

Answer

9608_s15_qp_12_sc_9.c.iii Mark Scheme Image

9608_s15_qp_11_sc_9.a

9608_s15_qp_11_sc_9.a Question Image

Answer

9608_s15_qp_11_sc_9.a Mark Scheme Image

9608_s15_qp_11_sc_9.b

9608_s15_qp_11_sc_9.b Question Image

Answer

9608_s15_qp_11_sc_9.b Mark Scheme Image

9608_s15_qp_11_sc_9.c.iii

9608_s15_qp_11_sc_9.c.iii Question Image

Answer

9608_s15_qp_11_sc_9.c.iii Mark Scheme Image

Explain why a given set of database tables are, or are not, in 3NF

9608_s20_qp_12_sc_6.a

9608_s20_qp_12_sc_6.a Question Image

Answer

9608_s20_qp_12_sc_6.a Mark Scheme Image

9608_s19_qp_13_sc_3.d

9608_s19_qp_13_sc_3.d Question Image

Answer

9608_s19_qp_13_sc_3.d Mark Scheme Image

9608_s18_qp_13_sc_2.c

9608_s18_qp_13_sc_2.c Question Image

Answer

9608_s18_qp_13_sc_2.c Mark Scheme Image

9608_s15_qp_12_sc_9.c.ii

9608_s15_qp_12_sc_9.c.ii Question Image

Answer

9608_s15_qp_12_sc_9.c.ii Mark Scheme Image

9608_s15_qp_11_sc_9.c.ii

9608_s15_qp_11_sc_9.c.ii Question Image

Answer

9608_s15_qp_11_sc_9.c.ii Mark Scheme Image

Produce a normalised database design for a description of a database, a given set of data, or a given set of tables

9608_w19_qp_13_sc_3.a.i

9608_w19_qp_13_sc_3.a.i Question Image

Answer

9608_w19_qp_13_sc_3.a.i Mark Scheme Image

9608_w19_qp_13_sc_3.a.ii

9608_w19_qp_13_sc_3.a.ii Question Image

Answer

9608_w19_qp_13_sc_3.a.ii Mark Scheme Image

9608_w19_qp_13_sc_3.a.iii

9608_w19_qp_13_sc_3.a.iii Question Image

Answer

9608_w19_qp_13_sc_3.a.iii Mark Scheme Image

9608_w19_qp_11_sc_4.d.i

9608_w19_qp_11_sc_4.d.i Question Image

Answer

9608_w19_qp_11_sc_4.d.i Mark Scheme Image

9608_w19_qp_11_sc_4.d.ii

9608_w19_qp_11_sc_4.d.ii Question Image

Answer

9608_w19_qp_11_sc_4.d.ii Mark Scheme Image

9608_w19_qp_11_sc_4.d.iii

9608_w19_qp_11_sc_4.d.iii Question Image

Answer

9608_w19_qp_11_sc_4.d.iii Mark Scheme Image

9608_w17_qp_13_sc_7.b

9608_w17_qp_13_sc_7.b Question Image

Answer

9608_w17_qp_13_sc_7.b Mark Scheme Image

9608_w17_qp_13_sc_7.c.ii

9608_w17_qp_13_sc_7.c.ii Question Image

Answer

9608_w17_qp_13_sc_7.c.ii Mark Scheme Image

9608_w17_qp_12_sc_7.b

9608_w17_qp_12_sc_7.b Question Image

Answer

9608_w17_qp_12_sc_7.b Mark Scheme Image

9608_w17_qp_12_sc_7.e

9608_w17_qp_12_sc_7.e Question Image

Answer

9608_w17_qp_12_sc_7.e Mark Scheme Image

9608_s17_qp_13_sc_1.b.i

9608_s17_qp_13_sc_1.b.i Question Image

Answer

9608_s17_qp_13_sc_1.b.i Mark Scheme Image

9608_s17_qp_13_sc_1.c.ii

9608_s17_qp_13_sc_1.c.ii Question Image

Answer

9608_s17_qp_13_sc_1.c.ii Mark Scheme Image

9608_s17_qp_11_sc_1.b.i

9608_s17_qp_11_sc_1.b.i Question Image

Answer

9608_s17_qp_11_sc_1.b.i Mark Scheme Image

9608_s17_qp_11_sc_1.c.ii

9608_s17_qp_11_sc_1.c.ii Question Image

Answer

9608_s17_qp_11_sc_1.c.ii Mark Scheme Image

9608_s15_qp_12_sc_9.b

9608_s15_qp_12_sc_9.b Question Image

Answer

9608_s15_qp_12_sc_9.b Mark Scheme Image

9608_s15_qp_12_sc_9.c.iii

9608_s15_qp_12_sc_9.c.iii Question Image

Answer

9608_s15_qp_12_sc_9.c.iii Mark Scheme Image

9608_s15_qp_11_sc_9.c.iii

9608_s15_qp_11_sc_9.c.iii Question Image

Answer

9608_s15_qp_11_sc_9.c.iii Mark Scheme Image