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)
