Database Design Guideline

Authors Avatar

ICT coursework TASK 2C - designing the database (part 3)

Whipps Cross Hospital Design guidelines

I am designing a database for Whipps cross-hospital witch will require information on patients and doctors. I will use Microsoft access to produce my database you don’t need much training on how to use it and this software will make it easier to store and find information about each doctor and patient in Whipps Cross Hospital.

Below I will be designing how the database will work.  The mean point of the database will hold 16 to 32 records and is going to have 2 tables. One of the tables is for the DOCTORS and the other one is going to be for the PATIENTS. I will try to design a database that is simple so it can be quick and easy to handle.

Hardware

  • Central Processing Unit (CPU) for performing the system's calculating and processing.

  • Random Access Memory (RAM) for memory.

  • Hard disk drive for storage of permanent data.

 Design Plans/ Inputs - drawing of what my tables will look like in Microsoft access once I have entered the field names and the data type. 

  • Doctors Table

  • Patients table

➔ Fields -Fields are the different parts of the database record. Common fields in my database are surname, forename, doctor ID, address, gender and phone number. Field is what you store the information in e.g. doctor ID will go under that particle field making it separated from other information/fields.

Doctor’s table: This is how my doctor’s table will look like when I have designed it in the actual database in Microsoft Access, for Whipps Cross Hospital.

Patient’s table: This is how my patient’s table will look like when I have designed it in actual database in Microsoft Access; for Whipps Cross Hospital.

 Validation rules- rules that you can only entry and nothing else in a particular field. It only allows cretin data to be entered. This helps make my work easier because if I type something else by mistake a sign will come up telling me that I can’t type anything else apart from what I wrote on my validation rules for that field.

'' Techniques used to ensure that the data is input into a computer system in accordance with predefined rules''

I will be using a validation rules in my database for my doctors and patients table, I will create a validation rule under the field of ward. My validation rule is in colours ("Red" Or "Blue" Or "Orange" Or "Green"). This means that in my database I can only enter the colour red, blue, orange or green for the ward input so while filling my forms I will have to apply and stick with these rules as my database will not allow me to entry any other information apart from using does rules.  

Join now!

Validation controls are given to create some rules for your assignment E.g. Validity check you can put minimum or maximum range. Validation rule gives you some rules witch you have to follow. The big advantage of using a validation rule is that there will be fewer changes of errors and making mistakes in my database this is why I think a validation rule is important in my database.


 

...

This is a preview of the whole essay