Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Database Design There are four main entries for this database, they are; Patients, Admission, Equipment Definition of data requirement Patient Table This is the Patient table; it stores all the information on each of the patients, like their address and contact details. Attribute Name Comments Data Type & Length Validation Patient ID Title Forename Address Town County Post Code Patients Phone No. GP's Name GP's No. Automatically incremented Auto number Text (6) Text (20) Text (20) Text (20) Text (20) Text (20) Number (15) Text (20) Number (15) Unique Primary Key Default to Kent Admissions Table This is the Admission Table; this stores the information of who is in the hospital and what ward they are in. It also gives details of who is treating them, and also dates of when they will be in hospital. Attribute Name Comments Data Type & Length Validation Admission No. Patient ID Ward Consultant ID Treatment Admission Date Discharge Date Automatically incremented Retrieved from patient table So details can be given This will show present date Auto Number Number Text (3) Number Memo (100) Date/Time Date/Time Unique Primary Key =date() Equipment Table This is the Equipment Table; this stores all the information about each piece of hospital equipment that can be loaned out....

To see the full version of this document, and 145,348 others