Exam Revision Questions Quiz DDD WDD

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

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

List the fields/attributes that should be included in each table.

Answer explanation

EXHIBITOR: exhibitor code, company name, area, stand number

PRODUCT: exhibitor code, product ref, item name, price

2 marks for all correct fields for Exhibitor

( 1 mark for 1 incorrect field, 0 if more than 1 incorrect or missing)

2 marks for all correct fields for Product

( 1 mark for 1 incorrect field, 0 if more than 1 incorrect or missing)

Identify the foreign key used to link the two tables.

Answer explanation

EXHIBITOR: exhibitor code, company name, area, stand number

PRODUCT: exhibitor code, product ref, item name, price

Foreign Key : Exhibitor Code

When implementing the database, BigTech Gadgets decide to include an image of each product.

Name the field type required to store an image.

• Text

• Number

• Object/Graphic

• Date

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.

• Presence Check

• Range Check

• Length Check

• Restricted Choice

Visitors to the exhibition will be able to find information using an interactive touchscreen kiosk. The kiosk includes a map with the location of each zone in the exhibition hall.

Identify one feature that makes this a suitable user interface for a touchscreen kiosk.

Answer explanation

Any one from:

- Large areas to make selection easy

- Large readable text

- Uncluttered screen

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.

Answer explanation

Search (select query) carried out (1 mark)

using Area field = Tech Zone (1 mark)

Another screen from the kiosk is shown

Identify two features used on this screen to aid navigation.

Answer explanation

Any 2 from

Breadcrumb,

Highlighted selection,

Back/Forward buttons,

Search (bar),

Home (button)

In the game section of a website, players are shown a board with pairs of picture tiles placed randomly. These are then flipped over to hide the images. Players have to flip two tiles trying to find two matching images until all pairs have been found.

Identify a situation in the game where the following programming constructs will need to be implemented: Selection Repetition

Answer explanation

Selection:

user clicks on tile

Repetition:

repeat turn

repeat tile turning until tiles matched

repeat game

One mark for each catagory

When a correct pair of images is found,

a tip giving advice about energy use or conservation is displayed.

Write the advice that should be included with these images.

The first example has been done for you.

Answer explanation

Candidate should specify energy saving tip relating to image for 1 mark each

For example:

Diagram 1 - Power Button:

Switch off device when not in use to save energy.

Don’t leave devices on standby when not in use.

Diagram 2 - Laptop:

Laptops use less power.

Switch laptop to hibernate when not in use. Reduce brightness to save power.

Dispose of laptops correctly

When creating the website, Ally copies images, sections of text and ideas from a website about energy use.

Explain why she might be in breach of the Copyright Designs and Patents Act.

Answer explanation

Demonstrate understanding of copying work created by others.

For example:

- Use of images without copyright permission

- Plagiarism of other persons writing