◀

8 Databases · 5 Q

1 9618_s21_qp_11_Q7(a) 3 marks

Bobby and Kim are discussing databases.

(a) Bobby tells Kim that a file-based approach is usually better than a relational database.

Explain why Bobby is incorrect.

2 9618_s21_qp_11_Q7(b)(i) 3 marks

(b)(i) Bobby has a shop that sells products to customers. His database will store data about his customers, their payment details, orders and the products he sells.

Give one example of each of the following relationships from Bobby's database.

one-to-one:

one-to-many:

many-to-many:

3 9618_s21_qp_11_Q7(b)(ii) 1 mark

(b)(ii) Tick (✓) one box to identify the relationship that cannot be directly implemented in a normalised relational database.

RelationshipTick (✓)
one-to-one
one-to-many
many-to-many
4 9618_s21_qp_11_Q7(b)(iii) 1 mark

(b)(iii) Bobby wants to name his database SHOPORDERS.

Write a Data Definition Language (DDL) statement to define a new database with the name SHOPORDERS.

5 9618_s21_qp_11_Q7(c) 3 marks

(c) A database has a data dictionary.

Give three items that are stored in a data dictionary.