Analysis of Whipps Cross Hospital Essay Example for Free

Analysis of Whipps Cross Hospital EssayWaltham Forest is i of the busiest areas in London. The main reason behind this comes from the fully grown 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 maven patient. There for I am going to create a entropybase for the hospital lag to be able to salt away, delete, search and edit data about the patients as well as the doctors. This leave behind 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 pass on be access codeible to all staff or workers in the hospital. My database go away also be utilize to produce report and respond to particular queries (question/ comments) that the doctors may puddle about patients. However before I start my database I pull up stakes need the following in nisusationOUTLINEI n this section I am going to outline the headings that I entrust be including in my database this will caudex in socio-economic classation about staff (doctors) and patients of the hospital.DatabaseA database is a order of battle 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 angiotensin-converting enzyme that can be dispersed or replicated among different points in a ne bothrk.Advantages* Reduced data redundancy* Reduced updating errors and increased consistency* Greater data integrity and independence from applications programs* better data access to users through use of host and query languages* Improved data security* Reduced data entry, storage, and retrieval costs* Facilitated development of naked as a jaybird applications programDisadvantages* 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(http//www.cl500.net/pros_cons.html)TablesI am going to lead two bows 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 separately table I will have different columns in which I will have suitable fields for instance for the first table I will place 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 and 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 etcForms== A form is like a blank document witch holds 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 dont 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 databaseo Names of staff and patients in alphanumerical formo Gender (M/F) in alphanumerical formo Address in alphanumeric formo Date of birth in integer formo Salary for the each staff member ($) moneyo Staff ID number (six digits) -in integer formQueriesThis is a selecti on 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 users 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 regular query that can be performed in a relational database.(http//www.informit.com/articles/article.asp?p=29661rl=1)As from the definition it suggests that its 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 particular propositi on 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 read if there database is working effectively it will save there time and make things easier to find and store.ReportsProducing 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.SUB TASKDesignI am designing a database for Whipps Cross Hospital to store their stuff and patients information under. Im going to design a database that will consist of two tables, one for the staff and the other one for the patients.EXAMPLE-For the staff rungSurnameJohnForenameSimonGender (M/F)MD.O.B04/05/1972Address31 Carlton Road, E17 5ET, Walthamstow, LondonSalary30,000 per yearID numberJ17672-For the patientsPATEINTSurnameJodiForenameSimonGender (M/F)FD.O.B06/08/1985Address9 farmer road, E10 5ST, Leyton, LondonNHS number6314518420Historyhepatitis BImplementationAt 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 flush use Microsoft excel to make the database. This is because the school dont have the appropriate software which they have in hospitals and this is the appropriate one. It is easier to use and it dont take a lot of billet in the computerTest ingI will test my work by adding appropriate information and appropriate codes using Microsoft excel or Microsoft access for exampleFor the staff ID I had maximum range of number from gramme 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 set 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 erro rs I will have to make corrections in the structural style 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 cant 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 percolate if the results are accurate.EvaluateI 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.INPUTSThe 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.STAFFFor the staff table For the patients tableOUTPUTSHow the data will be presented once it has com e out of the computer I will present my information in the form of table, reports and queries.SUCCESS CRITERIAIn 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.