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.

Related GCSE ICT Systems and Application essays

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.

It helps the workers because they can communicate with each other via intercom and improves the moral and chemistry between the staff team. Finally speakers help the customer because they can hear advertisements and/or promotions on the shop floor. It helps the company meet the need for high customer service and good communication throughout the organisation.

To get it to work you would have to use a second normalised form, which would include a selection table in the middle like this; Second normalised form This selection table would enable students to do more then one course on the database.

Customer related Objectives * The user will be able to insert a new customer to the system in less than 1 minute. * The user will be able to edit the customer details with ease. * A list of most popular sweets can be ready and printed for customer use in less than 30 seconds.

And the disadvantages which Sainsbury found are: an external mouse requires space, making it nearly impossible to use on an airplane. A mechanical mouse needs to be cleaned regularly or it will get clogged with lint and dust. The cord on most mice can get hung up and drag, making the mouse difficult to use.

Access it good at many things, which makes it the ideal choice for database software as multiple criteria, enables easy manipulation of data and it makes easy work of large amounts of data. Three Quantitative objectives 1. The user needs to search and print patient information for a reminder letter

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

password, and data can be handled without risk of damage data or lose it. Also with computer you can make calculus faster, without using a calculator, and another important thing is that you can make prediction of the work, how it's going and if it's improving or not.