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.

 

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)

 

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

(i)

EXHIBITOR

• exhibitor code
• company name
• area
• stand number

PRODUCT

• exhibitor code
• product ref
• item name
• price

1 mark for each table, must be 100% correct for each mark.

(ii) Exhibitor Code (1 mark)

If the wrong field is used as the Primary/Foreign key in both of the above tables and is then used as the answer for part (ii), award 1 mark as candidate has stated a field that appears in both tables.