• 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)

    A lot of credit card fraud is negated this way. Summary * Negates the need of the prolonged method of going to a banker * Quick, fast and simple to use * Located in a lot of areas allowing you to withdraw money in a large variety of places *

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

    YES MAIN MENU RUN QUERIES YES MAIN MENU MEMBERS REPORT YES MAIN MENU LOANS REPORT YES MAIN MENU DVDs REPORT YES FROM TO WORKED EXISTING / NEW MEMBERS FORM NAVIGATION BUTTON YES EXISTING / NEW MEMBERS FORM EXIT YES EXISTING / NEW MEMBERS FORM DELETE RECORD YES MESSAGE BOX COMES

  1. Database Coursework

    My system allows me to edit records within half a minute. This is because each record is already in edit mode, so all that needs to be done is the editing. Finding all records with common data within 1 minute: this would allow the worker to find all the records that fall under a certain data, e.g.

  2. GCSE Database Project ICT

    Security strategy (e.g. password) explained The computer will be marked physically with 'Property of the NSDAP� in both visible and invisible markers to prevent theft. The computer itself will be bolted to the table and the table bolted to the floor.

  1. ICT Coursework (MarcoS)

    fully, they can use different kind of formulas to calculate the account. They don't know very well how to use Microsoft Word, so that's why they are currently working on the account. Manager: The manager has only to check that everything is working well and that every data is correct.

  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

  1. ICT ANALYSIS

    - Each area must be shaded to a different effect and the correct textual information should be added to appropriate sections. - Hotspots is a vital part as it should be in use for all links from any page as it is not specific to a section or part.

  2. System requirements analysis

    The centre would need computers that worked quite fast and high capacity. They could also use a TFT monitor (thin film transistor) which is as effective as a LCD monitor. * A brief assessment of the advantages and disadvantages for the different types output devices which could be used (A01.53)

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