Waltham Forest is one of the busiest areas in London. The main reason behind this comes from the big hospital called Whipps Cross; serving a large community of approximately 225,000 people it makes it difficult for the approximately 2488 hospital to keep track of every single patient. There for I am going to create a database for the hospital staff to be able to store, delete, search and edit data about the patients as well as the doctors. This will help the hospital to keep track of the patient, for example, their latest treatment that they had, and what doctor they saw last etc. The hospital database will be accessible to all staff or workers in the hospital. My database will also be used to produce report and respond to particular queries (question/ comments) that the doctors may have about patients. However before I start my database I will need the following information:
In this section I am going to outline the headings that I will be including in my database; this will store information about staff (doctors) and patients of the hospital.
A database is a collection of data that is organised so that its contents can easily be accessed, managed and updated. The most prevalent type of database is the relational database, a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. A distributed database is one that can be dispersed or replicated among different points in a network.
* Reduced data redundancy
* Reduced updating errors and increased consistency
* Greater data integrity and independence from applications programs
* Improved data access to users through use of host and query languages
* Improved data security
* Reduced data entry, storage, and retrieval costs
* Facilitated development of new applications program
* Database systems are complex, difficult, and time-consuming to design
* Substantial hardware and software start-up costs
* Damage to database affects virtually all applications programs
* Extensive conversion costs in moving form a file-based system to a database system
* Initial training required for all programmers and users
I am going to have two tables first table to get the details about the staff of Whipps Cross Hospital and the second table for the patients in Whipps cross hospital.
For each table I will have different columns in which I will have suitable fields for instance for the first table I will put the doctor name and just say if there are 20 doctors working I will put all of their names, address, gender, date of birth, salary and staff ID etc. I will then store this information onto the computer. So altogether their will be six rows. For the second table for patients I will put the patients name in the first field, gender in the second field, then the address in the third field and their date of birth in the fourth field etc…
==> A form is like a blank document witch allows you to enter information into the database.
I will need the forms in my database as this will narrow my search when I am finding out information about the staff and the patients in Whipps cross hospital. I will also give each field its suitable form to access the information required. I will create a separate form for each doctor and patient in Whipps Cross Hospital so the information don’t get mixed and makes it less complicated to store. The forms can also be used as a back up file.
-Types of forms that I will be including in my database:
o Names of staff and patients – in alphanumerical form
o Gender (M/F) – in alphanumerical form
o Address – in alphanumeric form
o Date of birth – in integer form
o Salary for the each staff member – ($) money
o Staff ID number (six digits) -in integer form
This is a selection of data from the table in a database and a single query can extract data from different tables. It searches particularly information that is already stored on the database and will allow the hospital to use it for research + to make reports of their findings.
A query is an inquiry into the database using the SELECT statement. A query is used to extract data from the database in a readable format according to the user’s request. For instance, if you have an employee table, you might issue a SQL statement that returns the employee who is paid the most. This request to the database for usable employee information is a typical query that can be performed in a relational database.
As from the definition it suggests that it’s the selection of data, I will design two tables one for the staff and other one for the patients in Whipps cross hospital so with the help of both tables the Whipps Cross can run a query to specific information about the patient or the doctor. The query can also be used under one table as, if the hospital only needs to find the patients information.
A query is useful because it will allow me to extract specific information from the database.
Whipps Cross Hospital can just run the queries and check if there database is working effectively it will save there time and make things easier to find and store.
Producing information on a database in a form of a report data base will produce reports about the doctors and the patients e.g. patients information report, the doctors salary record etc. It will also produce results on a database in a presentable form. After making query database will produce the report for them in which it will be the information of one/two tables. This will be easier for Whipps Cross to translate the information.
I am designing a database for Whipps Cross Hospital to store their stuff and patients information under. I’m going to design a database that will consist of two tables, one for the staff and the other one for the patients.
-For the staff:
31 Carlton Road, E17 5ET, Walthamstow, London
30,000 per year
-For the patients:
9 farmer road, E10 5ST, Leyton, London
At this point I will be making my database. I would like to use Delphi software which I can access to find the information about the staff or the patients on my computer, but the school does not pervade us with this software so there for I will be using Microsoft access to design my tables and the database or I can even use Microsoft excel to make the database. This is because the school don’t have the appropriate software which they have in hospitals and this is the appropriate one. It is easier to use and it don’t take a lot of space in the computer
I will test my work by adding appropriate information and appropriate codes using Microsoft excel or Microsoft access for example:
For the staff ID I had maximum range of number from 1000 to 20,000 so I can put six digits Id for the staff and I will make sure that these six digits should be between 1000 and 20,000 and for testing purpose I will put a number less than 1000 and greater then 20,000. So when I do this if the error occurred or I tried to put more then six digit ID the database will automatically reject the value so I will have to put another ID to test my work. When I will put the right values my database did work so this shows that my database is working perfect.
This is one of the example which I have used from my report to show that what will happen if I will have number less than1000 or more then 20,00 in my database the computer will automatically reject those values and if I have more then 6numbers in my ID it will also reject it.
In the case with fixing these errors I will have to make corrections in the structural mode of tables. All this means that when I will be making my table I will put the staff ID in the structural mode. So when I will need to change the data I can’t directly change from my report or the inquiry I will have to go in structural mode to change this information.
I can also produce a number of recodes and run queries to see if the results are accurate.
I will evaluate my work by showing each step and explaining how I achieved this and all the errors and complication that I had. How I can improve my database. I will also explain the things which went right or wrong.
The data will be put into 2 tables, one for the staff and one for the patient. It will have different field names because there are 2 different sets of people. This will be the information that I will be putting into the database or the FIELDS.STAFF
For the staff table: For the patients table:
How the data will be presented once it has come out of the computer; I will present my information in the form of table, reports and queries.
In order for the database to be successful, I will measure the success of my data by running queries. Also, I will see if the correct information is displayed, this will tell me if it is a success and if it works proper.My database must contain information about Whipps cross hospitals staff and patients so it makes it easier for them to store and keep track of all the staff and patients so it makes it easier for Whipps Cross to store and keep track of all the stuff and patients. My database needed to be used friendly, it needs to have no spelling mistakes and it should have no gaps.