Analysis of Whipps Cross Hospital Essay Example for Free

Analysis of Whipps grouchy infirmary EssayWaltham Forest is one of the busiest areas in London. The main reason behind this comes from the big infirmary c anyed Whipps Cross serving a large community of approximately 225,000 people it even ups it difficult for the approximately 2488 hospital to arrest track of every single patient. There for I am going to create a entropybase for the hospital ply to be able to store, delete, search and edit entropy about the patients as good as the impacts. This go away help the hospital to keep track of the patient, for compositors case, their la demonstrate treatment that they had, and what desexualize they see last and so forth The hospital database leave alone be accessible to all staff or crapers in the hospital. My database pass on also be habituate upd to produce report and respond to particular queries (question/ comments) that the doctors may construct about patients. However before I start my database I pull up sta kes need the following studyOUTLINEIn this section I am going to outline the headings that I impart be including in my database this get out store instruction about staff (doctors) and patients of the hospital.DatabaseA database is a collection of data that is organised so that its contents pile easily be accessed, managed and updated. The most prevalent type of database is the comparative database, a tabular database in which data is defined so that it derriere be reorganized and accessed in a make out of opposite ways. A distributed database is one that rouse be dispersed or replicated among various points in a ne devilrk.Advantages* Reduced data redundancy* Reduced updating errors and increased consistency* great data integrity and independence from applications syllabuss* Improved data access to users through use of host and interrogation languages* Improved data security* Reduced data entry, storage, and retrieval costs* Facilitated development of new applications programDisadvantages* Database arrangements 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 get up 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 have two tables frontmost 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 jell the doctor name and just say if in that location are 20 doctors working I will ready all of their names, address, gender, date of birth, salary and staff ID etc. I will then store this development onto the com rearer. So altogether their will be six rows. For the second table for patients I will p ut the patients name in the first field, gender in the second field, then the address in the triad field and their date of birth in the fourth field etcForms== A forge is desire 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 seting 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 compound 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 learn of birth in integer formo Salary for the each staff member ($) bulliono Staff ID number (six digits) -in intege r formQueriesThis is a selection of data from the table in a database and a single oppugn 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 interrogatory 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 gather up. 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 comparative 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 Cr oss 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.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 reservation 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 pattern a database for Whipps Cross Hospital to store their replete and patients infor mation 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 staffSTAFF appellationJohnForenameSimonGender (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 number6314518420 scorehepatitis BImplementationAt this point I will be qualification 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 dont have the appropriate software which they have in hospitals and this is the appropriate one. It is easier to use and it d ont take a lot of space in the computerTestingI 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 thousand 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(prenominal) 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 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 see 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 tableOU TPUTSHow 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.SUCCESS CRITERIAIn order for the database to be triumphful, 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.