• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Analysis of Whipps Cross Hospital

Extracts from this document...

Introduction

Analysis of Whipps Cross Hospital 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: OUTLINE 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. Database: A database is a collection of data that is organised so that its contents can easily be accessed, managed and updated. ...read more.

Middle

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. (http://www.informit.com/articles/article.asp?p=29661&rl=1) 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. Reports: 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. ...read more.

Conclusion

How I can improve my database. I will also explain the things which went right or wrong. INPUTS 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: OUTPUTS 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. SUCCESS CRITERIA 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. ?? ?? ?? ?? ICT coursework Task 2C Activity Sheet 1 Fizzi Hasib 10W ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    They can have up to date information on when a vacancy opens and do all they can to try and find a job, whether it be part time or full time. This is extremely useful to the large amount of unemployed who can simply find any open jobs using this site without having to go to job centres and such.

  2. ICT Coursework (MarcoS)

    Then click on "Insert"; 3. A new window will open, and now select the button "Combo Box"; 4. Click and drag the mouse to create one, then right click on it and select "Format Control", a new window will open; 5. Now you have the possibility to give an "Input range" of data, and a "Cell link".

  1. Database Analysis and Database Design Project - DVD library for moving images.

    Each title falls into a specific category some of these are adventure, thriller, fantasy, action or education. (There are others) All titles are only loaned to registered members of Moving Images. Information is store on members personal details including name, address and contact number.

  2. Ict Powerpoint Coursework

    This is the page which would lead the user to when the home button is clicked on any slide. Slide 3: This is the slide that contains the burgers that S.A. Foods have to offer, there are several pictures of burgers that S.A.

  1. Database Coursework

    A spreadsheet would also make it much easier for the mechanics. Instead of having to spend a long time with the calculations, they can simply use the drop down menu to choose all the different options and see which one is the best to use.

  2. GCSE IT Coursework

    data in the database is kept up-to-date, as otherwise the stock data may be out of date, so a customer is told that there is a product that is not in stock, is available. I will also include the ability to search for data in the database so that data

  1. GCSE Database Project ICT

    to and many reports will be in use for the Mail Merge information also queries will be run in which, the file will be printed out to check the information is correct and valid. Also in printing, the file out it makes it easier for people to view and edit

  2. Organising the database at Costsloadsless.

    My form would collect valuable information from the customer. letters This letter will contain the information about the DVD they have taken out and have failed to return the date that it was taken out will be on the

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work