Practical+Validation

Practical validation (school computers)
A secondary school has 2 databases. One database (Computers) stores information about each computer in the school. The second database (Classrooms) stores information about the classrooms across the school.

You are required to add validation to the tables as follows:


 * Computers** (Primary Key: Serial Number)


 * Serial Number should be a maximum of 6 characters in length. It should be a unique value and must always be present.
 * Make should be a radio button with 2 choices: Apple or HP.
 * Hard Disk should be a number between 80 and 750. The user should be able to override this setting.
 * Operating System should selected from a list: OS X, Windows XP, Windows Vista or Windows 7.
 * Room Number should be an integer between 1 and 70. The user should not be able to override this setting.


 * Classrooms** (Primary Key: Room Number)


 * Room Number should be an integer between 1 and 70. The user should not be able to override this setting.
 * Teacher should have a maximum of 16 characters and must always be present
 * Floor should be an integer in between 1 and 3
 * Department should be chosen from a drop down list containing: Maths, English, Computing, Science, CDT and RME

Once all validation has been set, you should test entry to each field.