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

9618_w24_qp_12_sc_6.a

9618_w24_qp_12_sc_6.a Question Image
9618_w24_qp_12_sc_6.a Question Image

9618_w24_qp_11_sc_2.a

9618_w24_qp_11_sc_2.a Question Image
9618_w24_qp_11_sc_2.a Question Image

9618_w23_qp_11_sc_3.b

9618_w23_qp_11_sc_3.b Question Image
9618_w23_qp_11_sc_3.b Question Image

9618_s21_qp_11_sc_7.a

9618_s21_qp_11_sc_7.a Question Image
9618_s21_qp_11_sc_7.a Question Image

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

9618_w24_qp_12_sc_6.a

9618_w24_qp_12_sc_6.a Question Image
9618_w24_qp_12_sc_6.a Question Image

9618_w24_qp_11_sc_2.a

9618_w24_qp_11_sc_2.a Question Image
9618_w24_qp_11_sc_2.a Question Image

9618_w23_qp_11_sc_3.b

9618_w23_qp_11_sc_3.b Question Image
9618_w23_qp_11_sc_3.b Question Image

9618_s23_qp_13_sc_4.a

9618_s23_qp_13_sc_4.a Question Image
9618_s23_qp_13_sc_4.a Question Image

9618_s21_qp_11_sc_7.a

9618_s21_qp_11_sc_7.a Question Image
9618_s21_qp_11_sc_7.a Question Image

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

9618_w25_qp_12_sc_4.a

9618_w25_qp_12_sc_4.a Question Image
9618_w25_qp_12_sc_4.a Question Image

9618_w25_qp_11_sc_2.d

9618_w25_qp_11_sc_2.d Question Image
9618_w25_qp_11_sc_2.d Question Image

9618_s25_qp_12_sc_5.a

9618_s25_qp_12_sc_5.a Question Image
9618_s25_qp_12_sc_5.a Question Image

9618_s25_qp_12_sc_5.b

9618_s25_qp_12_sc_5.b Question Image
9618_s25_qp_12_sc_5.b Question Image

9618_s25_qp_11_sc_5.b

9618_s25_qp_11_sc_5.b Question Image
9618_s25_qp_11_sc_5.b Question Image

9618_s25_qp_11_sc_5.c

9618_s25_qp_11_sc_5.c Question Image
9618_s25_qp_11_sc_5.c Question Image

9618_s25_qp_11_sc_5.d

9618_s25_qp_11_sc_5.d Question Image
9618_s25_qp_11_sc_5.d Question Image

9618_w24_qp_13_sc_4.a

9618_w24_qp_13_sc_4.a Question Image
9618_w24_qp_13_sc_4.a Question Image

9618_w24_qp_13_sc_4.d

9618_w24_qp_13_sc_4.d Question Image
9618_w24_qp_13_sc_4.d Question Image

9618_w24_qp_12_sc_6.b.i

9618_w24_qp_12_sc_6.b.i Question Image
9618_w24_qp_12_sc_6.b.i Question Image

9618_w24_qp_11_sc_2.c

9618_w24_qp_11_sc_2.c Question Image
9618_w24_qp_11_sc_2.c Question Image

9618_s24_qp_13_sc_4.a

9618_s24_qp_13_sc_4.a Question Image
9618_s24_qp_13_sc_4.a Question Image

9618_s24_qp_13_sc_4.d

9618_s24_qp_13_sc_4.d Question Image
9618_s24_qp_13_sc_4.d Question Image

9618_s24_qp_12_sc_4.a

9618_s24_qp_12_sc_4.a Question Image
9618_s24_qp_12_sc_4.a Question Image

9618_s24_qp_12_sc_4.d

9618_s24_qp_12_sc_4.d Question Image
9618_s24_qp_12_sc_4.d Question Image

9618_w23_qp_12_sc_2.a

9618_w23_qp_12_sc_2.a Question Image
9618_w23_qp_12_sc_2.a Question Image

9618_s23_qp_13_sc_4.b

9618_s23_qp_13_sc_4.b Question Image
9618_s23_qp_13_sc_4.b Question Image

9618_s23_qp_12_sc_2.b

9618_s23_qp_12_sc_2.b Question Image
9618_s23_qp_12_sc_2.b Question Image

9618_s23_qp_11_sc_2.b.i

9618_s23_qp_11_sc_2.b.i Question Image
9618_s23_qp_11_sc_2.b.i Question Image

9618_w22_qp_13_sc_2.a

9618_w22_qp_13_sc_2.a Question Image
9618_w22_qp_13_sc_2.a Question Image

9618_w22_qp_12_sc_5.c

9618_w22_qp_12_sc_5.c Question Image
9618_w22_qp_12_sc_5.c Question Image

9618_w22_qp_11_sc_4.c.i

9618_w22_qp_11_sc_4.c.i Question Image
9618_w22_qp_11_sc_4.c.i Question Image

9618_w21_qp_11_sc_5.a

9618_w21_qp_11_sc_5.a Question Image
9618_w21_qp_11_sc_5.a Question Image

9618_s21_qp_12_sc_1.a

9618_s21_qp_12_sc_1.a Question Image
9618_s21_qp_12_sc_1.a Question Image

9618_s21_qp_11_sc_7.b.i

9618_s21_qp_11_sc_7.b.i Question Image
9618_s21_qp_11_sc_7.b.i Question Image

9618_s21_qp_11_sc_7.b.ii

9618_s21_qp_11_sc_7.b.ii Question Image
9618_s21_qp_11_sc_7.b.ii Question Image

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

9618_w25_qp_13_sc_5.a

9618_w25_qp_13_sc_5.a Question Image
9618_w25_qp_13_sc_5.a Question Image

9618_w25_qp_11_sc_2.a

9618_w25_qp_11_sc_2.a Question Image
9618_w25_qp_11_sc_2.a Question Image

9618_s25_qp_13_sc_6.a

9618_s25_qp_13_sc_6.a Question Image
9618_s25_qp_13_sc_6.a Question Image

9618_s25_qp_11_sc_5.a

9618_s25_qp_11_sc_5.a Question Image
9618_s25_qp_11_sc_5.a Question Image

9618_w24_qp_11_sc_2.b.i

9618_w24_qp_11_sc_2.b.i Question Image
9618_w24_qp_11_sc_2.b.i Question Image

9618_w23_qp_13_sc_3.b.i

9618_w23_qp_13_sc_3.b.i Question Image
9618_w23_qp_13_sc_3.b.i Question Image

9618_w23_qp_11_sc_3.a

9618_w23_qp_11_sc_3.a Question Image
9618_w23_qp_11_sc_3.a Question Image

9618_w22_qp_11_sc_4.a

9618_w22_qp_11_sc_4.a Question Image
9618_w22_qp_11_sc_4.a Question Image

9618_w21_qp_12_sc_6.a.ii

9618_w21_qp_12_sc_6.a.ii Question Image
9618_w21_qp_12_sc_6.a.ii Question Image

Show understanding of the normalisation process

9618_s25_qp_12_sc_5.a

9618_s25_qp_12_sc_5.a Question Image
9618_s25_qp_12_sc_5.a Question Image

9618_s25_qp_11_sc_5.d

9618_s25_qp_11_sc_5.d Question Image
9618_s25_qp_11_sc_5.d Question Image

9618_w24_qp_13_sc_4.c.ii

9618_w24_qp_13_sc_4.c.ii Question Image
9618_w24_qp_13_sc_4.c.ii Question Image

9618_s24_qp_11_sc_6.a

9618_s24_qp_11_sc_6.a Question Image
9618_s24_qp_11_sc_6.a Question Image

9618_w23_qp_12_sc_2.c

9618_w23_qp_12_sc_2.c Question Image
9618_w23_qp_12_sc_2.c Question Image

9618_s23_qp_13_sc_4.c

9618_s23_qp_13_sc_4.c Question Image
9618_s23_qp_13_sc_4.c Question Image

9618_s23_qp_11_sc_2.b.ii

9618_s23_qp_11_sc_2.b.ii Question Image
9618_s23_qp_11_sc_2.b.ii Question Image

9618_w22_qp_12_sc_5.a

9618_w22_qp_12_sc_5.a Question Image
9618_w22_qp_12_sc_5.a Question Image

9618_w22_qp_11_sc_4.b

9618_w22_qp_11_sc_4.b Question Image
9618_w22_qp_11_sc_4.b Question Image

9618_w21_qp_12_sc_6.a.i

9618_w21_qp_12_sc_6.a.i Question Image
9618_w21_qp_12_sc_6.a.i Question Image

9618_s21_qp_11_sc_7.b.ii

9618_s21_qp_11_sc_7.b.ii Question Image
9618_s21_qp_11_sc_7.b.ii Question Image

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

9618_w25_qp_11_sc_2.b

9618_w25_qp_11_sc_2.b Question Image
9618_w25_qp_11_sc_2.b Question Image

9618_s21_qp_12_sc_1.b

9618_s21_qp_12_sc_1.b Question Image
9618_s21_qp_12_sc_1.b Question Image

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

9618_w24_qp_13_sc_4.c.ii

9618_w24_qp_13_sc_4.c.ii Question Image
9618_w24_qp_13_sc_4.c.ii Question Image

9618_w24_qp_12_sc_6.b.i

9618_w24_qp_12_sc_6.b.i Question Image
9618_w24_qp_12_sc_6.b.i Question Image

9618_s24_qp_13_sc_4.d

9618_s24_qp_13_sc_4.d Question Image
9618_s24_qp_13_sc_4.d Question Image

9618_s24_qp_12_sc_4.d

9618_s24_qp_12_sc_4.d Question Image
9618_s24_qp_12_sc_4.d Question Image

9618_s24_qp_11_sc_6.a

9618_s24_qp_11_sc_6.a Question Image
9618_s24_qp_11_sc_6.a Question Image

9618_w23_qp_12_sc_2.c

9618_w23_qp_12_sc_2.c Question Image
9618_w23_qp_12_sc_2.c Question Image

9618_s23_qp_13_sc_4.c

9618_s23_qp_13_sc_4.c Question Image
9618_s23_qp_13_sc_4.c Question Image

9618_w22_qp_12_sc_5.a

9618_w22_qp_12_sc_5.a Question Image
9618_w22_qp_12_sc_5.a Question Image