• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  • Level: GCSE
  • Subject: ICT
  • Word count: 3068

Database Design Guideline

Extracts from this document...

Introduction

Whipps Cross Hospital Design guidelines I am designing a database for Whipps cross-hospital witch will require information on patients and doctors. I will use Microsoft access to produce my database you don't need much training on how to use it and this software will make it easier to store and find information about each doctor and patient in Whipps Cross Hospital. Below I will be designing how the database will work. The mean point of the database will hold 16 to 32 records and is going to have 2 tables. One of the tables is for the DOCTORS and the other one is going to be for the PATIENTS. I will try to design a database that is simple so it can be quick and easy to handle. Hardware * Central Processing Unit (CPU) for performing the system's calculating and processing. * Random Access Memory (RAM) for memory. * Hard disk drive for storage of permanent data. ==> Design Plans/ Inputs - drawing of what my tables will look like in Microsoft access once I have entered the field names and the data type. * Doctors Table Field Name Data Type Description Doctors ID Text It is the unique number the doctor is recognised by. (Primary key) Forename Text Doctors first name Surname Text Doctors surname Address Text Doctors Address Phone Number Text Doctors phone number Salary Currency How much the doctor gets paid Gender Text Male or Female Ward Text The working area of the doctor / The ward which the doctor will be working in. Specialist Text What the doctor specialises in (e.g. heart surgeon) * Patients table Field Name Data Type Description Patients ID Text It is the unique number the patient is recognised by. (Primary Key) Doctors ID Text The ID number of the patients doctor which is the unique number the doctor is recognised by. Forename Text Patients first name Surname Text Patients surname Address Text Where the patient lives. ...read more.

Middle

Doctor's Form: Doctor ID: Forename: Surname: Address: Phone number: Gender: Salary: Ward: Specialist: Patient's Form: Patient's ID: Date discharged: Doctor's ID: Ward: Surname: Phone number: Forename: Postcode: Gender: Illness: Data of birth: Address: NSH number: Date admitted: ==> Queries - This is a selection of data from the table in a database where a single query can extract data from different tables. Queries are particular searches that can be run on the database. This is better than going through each and every data and it will waste time. Queries are much quicker and it will save time leaving the hospital staff to do other stuff. 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. They can find the information needed very easily. This will also affect the general running of the database it will make it faster, quicker and more efficient for the hospital stuff. Now I am going to plan how I will be creating queries in my database and a brief design of what my queries will look like. For each of my queries I will have the following layouts: o Query 1 Table Used Doctor and Patient Query Criteria Doctors treating patients with osteopathy illness Expected Result A record of all Doctor's working with osteopathy patients. I should see all the records of that illness and the first and second name of doctor. Fields Used From doctor's form: Doctor ID, doctor forename and surname. Form doctors form: Patient illness Query Design - this is what the 1st query will actually look like in my Microsoft access database document: Field: Doctor ID Forename Surname Illness Tables: doctors doctors doctors patient Sort: Show: ? ? ? ? Criteria: "osteopathy" Or: Criteria- there is a rule behind how to input a data under the criteria, the word entered must contain a = sign and explanation marks before and after the criteria data for example; ...read more.

Conclusion

In the report all the information is extracted from the Queries, which I will design. I will be using reports to extract data for my doctor's table, patients table as well as all my queries so the information is more presentable. This is the design of my Doctor's report: Doctors Forename Surname Address Phone Gender Salary Ward Special 09 July 2007 Page 1 of 1 This is the design of my Patients report: Patie Docto Surna Foren Ge Date Addre NHS Data Date Ward Phon Postco Ill 09 July 2007 Page 1 of 2 This is the design of my Query 1 report: Doctors ID Forename Surname Illness 11 July 2007 Page 1 of 1 This is the design of my Query 2 report: Doctors ID Forename Surname Patients ID Ward Illness 11 July 2007 Page 1 of 1 This is the design of my Query 3 report: Patients ID Forename Surname Gender Ward 11 July 2007 Page 1 of 1 This is the design of my Query 4 report: Doctors ID Forename Surname Specialist Ward 11 July 2007 Page 1 of 1 This is the design of my Query 5 report: Doctors ID Forename Surname Gender Specialist Ward 11 July 2007 Page 1 of 1 This is the design of my Query 6 report: Doctors ID doctors.Forena doctors.Surna Patients ID patient.Forena patient.Surnam 11 July 2007 Page 1 of 1 This is the design of my Query 7 report: Patients ID Forename Surname Illness Ward 11 July 2007 Page 1 of 1 This is the design of my Query 8 report: Doctors ID Forename Surname Specialist Ward 11 July 2007 Page 1 of 1 This is the design of my Query 9 report: Patie Docto Foren Surna Ge Date Addre NHS Data Date Ward Phon Postco Ill 11 July 2007 Page 1 of 1 This is the design of my Query10 report Doctors doctors.F doctors.S Gender Patients patient.F patient.S Ward Illness 11 July 2007 Page 1 of 1 End of my database ?? ?? ?? ?? ICT coursework TASK 2C - designing the database (part 3) 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. System administration report

    It shows what type of room is available, who are the occupants and how long is their period of stay. This data is particularly useful to Reception as they can arrange what rooms and available and when. Again the keyboard operates the system.

  2. Database design.

    When we are giving the total mark then and only then is it information. It has been processed into information and is of use. This is the difference between Data and Information: Data is useless and has no meaning. Information has meaning and can be used.

  1. In this (2b) report I am going to investigate software application, Input and Output ...

    Although liquid crystal displays take up much less space, the disadvantage is that these screens can be viewed only from a limited angle. As the technology improves, flat screen panels are becoming available for desktop computers too. A screen display is either monochrome, or colour.

  2. Access Database

    Security: For security I will save my work regularly so this would reduce the risk of it not being saved. I will also save it in several places for example: school computer, computer at home and USB. This will make sure I wont lose my work.

  1. Database design for a farmers herd book.

    If training is needed then User friendly Less mistakes Less space taken up Easy to navigate around the system Efficient Task 2 Explanation of the entities and attributes Entities An entity is a thing or object of importance about which data must be captured.

  2. Normalisation.Normalisation is a process used to come up with the best possible design for ...

    Tables should be organised in such a way that; * No data is unnecessarily duplicated * Data is consistent throughout the database * The structure of each table is flexible enough to allow you to enter as many or as few times * The structure should enable a user to make all kinds of different queries relating from different tables.

  1. Database Coursework

    Solutions Current Manual System There are many ways of improving the manual system. The most obvious one is to get more workers to work alongside the receptionist. Since it is their job to collect the data for the entire system, its important that all the job is done correctly.

  2. Analysis of Whipps Cross Hospital

    Tables: I am going to have two tables 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 each table I will have different columns in which I will have suitable fields for instance for

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