When the visitor selects the tech zone button on the kiosk, a list of companies exhibiting in that area is displayed.
Describe what happens within the database when this button is selected. (2)
Category Archives: Structures and Links (databases)
2014 – Q21 (c)
The Stand Number must contain the number of the exhibition stand to be used by the company.
Name the type of validation that should be implemented on this field. (1)
2014 – Q21 (b)
When implementing the database, BigTech Gadgets decide to include an image of each product.
Name the field type required to store an image. (1)
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.
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)
2014 – Q15 (e)
A search is carried out for holidays in Greece leaving from “Any London” airport after 1st May 2015.
Here are some matching holidays.
Describe how the list is sorted. (2)
2014 – Q6
State one problem with storing data in a flat file database. (1)
