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

    What do you think of the layout of my hand drawn plans? 5. Is the colour combination used good, is the style of the page good? 6. Overall, what do you think of the hand drawn plans, should I redo do them, or keep it as it is? 7.

  2. Smarts Leisure Park Database Booking System

    I know that I want to enter a search to find the correct customer and all of their correct details. To do this I had to add a search criteria in the box: Now when I run the query it asks me for a surname: When I search the surname

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

  2. System administration report

    The hotel has also started advance bookings for Christmas and New Year parties. The hotel generates its main revenue from booking and reservations for weddings, conferences, and parties. The Moat house is attractive to a variety of businesses, ranging from small to big companies such as JCB, Argos and GEC for their conference rooms.

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

    staff use it, and without mouse they can't do any work in desktops this is a big problem for Sainsbury, thus Sainsbury hopes to reduce the desktops, Sainsbury wants to increase laptops on its supermarket. The advantages of the mouse which Sainsbury has been founded; a mouse works very well

  2. Organising the database at Costsloadsless.

    I will then look at least four good and bad points about them. So I know what I'm expecting when I apply those methods. Method 1: relying on staff My first method is to rely on staff. This method would work by a customer would take out a video/DVD the

  1. Database design

    However the cottage system is not easy to use, with very little ability to look up customers. Management cannot get reports or graphs which provide any useful analysis of cottage history and which cottages have been mostly used. There isn't any password for the folders and the files to keep them secure.

  2. Database design for a farmers herd book.

    Each of the rows in a table is called a record and the items in the columns are called fields. In these relational databases there will be an assortment of tables - one for each entity type; i.e. there could be a table for patients, suppliers and one for products.

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