AS Computing

Validation


Task 1

Set up the following validation in the example database (shared area 'Validation')

Firstname -    Length check -     10 characters maximum
Surname -      Presence check - Required
Data Joined - Range check -      between 01/01/09 & 31/12/10
Supervisor -  Existence check - must exist in Employee table



Task 2

Complete the design sheet for the product table


Task 3

1. Validation routines are used to improve the quality of data input. Identify three types of validation routine that might be used and explain what type of errors they are designed to trap. (6)

2. When entering your email address onto a form on a website
how does it automatically verify that you have entered a correct email address? (1)

DBMS





Task 1

Use the handout provided to make a presentation clearly describing what a DBMS is and what its functions are.

You should be able to describe the processes involved in a variety of different applications of computers in society.

A Health Service Information System

 

SLC Theory notes


Task 1


Complete the worksheet 'Theory Notes Task' in the Revision Folder


Task 2


Use the Connectives task to practice extending exam answers

Networks Hardware