• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Database Design

Extracts from this document...

Introduction

Database Design There are four main entries for this database, they are; Patients, Admission, Equipment Definition of data requirement Patient Table This is the Patient table; it stores all the information on each of the patients, like their address and contact details. Attribute Name Comments Data Type & Length Validation Patient ID Title Forename Address Town County Post Code Patients Phone No. GP's Name GP's No. Automatically incremented Auto number Text (6) Text (20) Text (20) Text (20) Text (20) Text (20) Number (15) Text (20) Number (15) Unique Primary Key Default to Kent Admissions Table This is the Admission Table; this stores the information of who is in the hospital and what ward they are in. It also gives details of who is treating them, and also dates of when they will be in hospital. ...read more.

Middle

Attribute Name Comments Data Type & Length Validation Loan ID Patient ID Equipment ID Date Borrowed Date Due Back Date returned Automatically incremented Retrieved from patient tab. Retrieved from Equip. tab. Auto number Number Text (6) Date/Time Date/Time Date/Time Unique Primary Key =Date() =date + 42 Consultant Table This table holds the information about the Consultant treating each patient. This is then linked to the admission table. Attribute Name Comments Data Type & Length Validation Consultant ID Consultant Name Automatically incremented Auto number Text (30) Unique Primary Key Design of Input Form Patient Form This is the form that is used for the use of inputting patient details. It has a nice clear layout, and should be simple to use. This form is used for adding, looking up and editing any patient details on the data base. ...read more.

Conclusion

more than one table, so I could adjust what information would be shown and be able to be edited in the forms. Admission Query - This links information from Admission table and Patient table. This query is used in the admission form. Information from both tables can be edited and added from this form. Loan Query - This links information from Equipment table, Loan table and Patient table. This query is used in the Loan form. Information from both tables can be edited and added from this form. Current Patient Query - This links information from Admission table and Patient table. This query is used in the Equipment Status report and the Loaning form. Information from both tables can be edited and added from this form. Equipment Query - This one was added because not all fields of the equipment record was needed for this query. So some of the fields were removed. Menu Design ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. I have been given the task of creating a system for a hospital to ...

    Other costs that must be taken into consideration are training costs, staff will have to be trained how to use the system quickly and efficiently. Staff training costs should be low as the system is going to be designed so that it is easy to use and understand, this helps

  2. Computer Aided Design Package

    up the drawings that they produce during the day * Monitor for the user to view what they are doing while using the computer Other hardware that will be needed that is not part of the computer and is not needed to get the computer working, but will be required

  1. I have been given the task to design a database for a company called ...

    This is better than fonts such as Algerian in font 9 which although is fancy, is difficult to read. Forms The reason I have chosen forms instead of tables for the system is explained above under the title 'Query Outputs.'

  2. Basic Database Building

    Total Facilities - This is used for showing the total uses in general for all users of the sports facilities All the reports can be seen in the screen shots below; Data Dictionary Ricki Lambert 16 May 2008 Table: Facilities Page: 1 Properties DateCreated: 09/05/2008 10:10:02 DefaultView: Datasheet GUID: {guid

  1. VAGINAL DISCHARGE

    Again, Windows comes with this software pre installed, and it is relatively easy to use. If you prefer to use 3rd party software, there is also a program available from Horizon DataSys to do this process, it is available from www.rollbacksoftware.com for $69 or about �35.

  2. Robot Prototype design principles.

    Because there is no restructuring engine, the programmer must also revisit all of these related program locations in order to carry out the actual restructuring changes. Other visibility problems were due to design. For example, on tool start-up only a tool bar was displayed.

  1. Logo design

    Final Logo The logo I have chosen to use is: Logo build What software I used AO1A I used www.logoyes.com What software I could have used AO1O, AO1L I could have used paint or photo shop. Why I selected the software I did AO1K Because it was easy to use

  2. Spare Parts Database Project

    Wong; The business deals in the selling of engines and spare parts. 4. Self: From where does the business import its goods? Mr. Wong; The business imports its goods from Japan and South Africa. 5. Self: What are the problems that the business is facing?

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