Y11 ICT Week 09 Lesson 2

​Click here to download source file

​Download EVIDENCE HERE

​Tutorial here

​Download EVIDENCE HERE

​Tutorial here

​Click here to download source file

​Mark Scheme

​Tutorial here

​Mark Scheme

Open Ended

Give the data type used for the Yes/No option in a database.

Open Ended

Ayoki wants to ensure that all holidays in the database are between 01 July 2027 and 31 July 2027.

Give the validation check she should use.

Open Ended

Ayoki has a field in the CLIENTS table that shows how the clients booked

their holiday.

She could use the = operator to find only those who booked direct =Direct

Give one other operator she could use to find only those clients who

booked direct.

Open Ended

Ayoki enforced referential integrity when she created the relationship between the three tables.
Explain why she enforced referential integrity