Back to the Data Model.
These Requirements were drafted established by Andrea on 10th. July, 2007 who needs a Database for Car Park Security.
An organisation wishes to increase security in its car park.
It has been decided to issue an identity card to all employees.
The cards record the employee’s name, department and identity number.
A barrier, a card reader and a sensor are placed at the entrance of the car park.
The driver inserts the numbered card into the card reader.
The card reader checks the card number.
If the number is valid, the reader sends a signal to raise the barrier and the vehicle can enter the car park.
The sensor sends a signal to the barrier to lower when the vehicle has entered.
There is a system at the exit with a barrier which is raised when a car wishes to leave the car park. W
hen there are no spaces in the car park a sign at the entrance displays “Full” and is only switched off when a vehicle leaves.
Special visitors’ cards, which record a number and the current date, also permit access to the car park.
Visitors’ cards may be sent out in advance or collected from reception.
All visitors’ cards must be returned to the reception when the visitor leaves the site so that they can be
deleted from the list of valid cards.
10th. July 2007
The Things of Interest include :-
Water Quality Tests