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


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.


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.


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 find out about jobs, education and other important factors of life. CCTV/Metropolitan website The CCTV system and the metropolitan website both work in keeping finding and keeping crime off the streets. CCTV, which stands for closed circuit television, is a system which uses video cameras to monitor a

  2. System requirements analysis

    her to write and it was not as awkward as it would have been if she did not have the earphone as she would only have one hand free to type slowing her down. Also I asked her if she had received any kind of training to use the system

  1. Data analysis report - Factors influencing pocket expenses of college students

    Visits to restaurants per month: Here, test statistic, t = 5.421227 t0.025 = 3.96 With 5.421227>1.50 (t0.025), we reject H0 and conclude at the 0.05 significance that B1 is not equal to zero. The statistical evidence shows that there is significant relationship between Number of restaurant visits per month and monthly expenses of students.

  2. System administration report

    The invoice is then recorded and sent to the finance department. This screenshot shows the main menu of the IGS booking system. All the employees in the hotel, particularly in reception, accounts/finance and sales, use it. There are a variety of options to choose from and is not only limited

  1. Different types of technology How I use ICT at home and at school

    You can use the platform of Facebook's liking or becoming a fan feature to make friends with people with similar interests. You can even find out who in your current social circle likes similar things as you, thus providing the chance for a 'friendship' to blossom.

  2. Organising the database at Costsloadsless.

    To test this method I shall create a customer and say it has bought back the DVD. I should then see in two days that the customer has been deleted. Design Data flow diagrams In a data flow diagram, basically it shows how the system moves around.

  1. ICT Job Applications - Enricé's Tapas Bar.

    The details also identify who they really are. Processing The following processes are needed in order to make the whole system work: Output The system should select one of the applicants and mail merge their details onto the letter by using a data source stored onto a database in MS

  2. GCSE Database Project ICT

    Because an Internet Connection is used, Norton Antivirus would be used to keep the computer free from viruses and other potential Malicious Files. Appropriate Hardware identified This is the computer and printer I believe is suitable for use now and in the future of the Dental Practice and the running of this efficient system: Manufacturer: Packard Bell BV Processor: Intel(R)

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