Category Archives: Section 2

2014 – Q21 (a)

BigTech Gadgets are organising an exhibition to showcase cutting edge developments in technology. BigTech Gadgets want to store the details of products being demonstrated by companies.

Some sample data is shown in the table below.

2014 q21 a

 

To avoid data duplication, a database with two linked tables is proposed – EXHIBITOR table and PRODUCT table.

(i) List the field/attributes that should be included in each table. (2)

2014 q21 a2

 

(ii) Identify the foreign key used to link the two tables. (1)

Answer