• 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. Basic Database Building

    {00603FE1-F42B-4071- LastUpdated: 14/05/2008 11:11:12 9D6A-6C358D5587C7}} NameMap: Long binary data OrderByOn: False Orientation: Left-to-Right RecordCount: 2 Updatable: True Columns Name Type Size Facility ID Long Integer 4 AllowZeroLength: False Attributes: Fixed Size, Auto-Increment CollatingOrder: General ColumnHidden: False ColumnOrder: Default ColumnWidth: Default DataUpdatable: False OrdinalPosition: 0 Required: False SourceField: Facility ID SourceTable:

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

  1. Logo design

    13 Stepping 8 GenuineIntel ~1729 Mhz What alternative hardware I could have used AO1D Apple Mac pc or laptop Advantages and disadvantages of alternative Hardware AO1E, AO1V, AO1W Advantages: * Reliable for a professional logo outcome Disadvantages: * Can react quite slowly * Doesn't communicate with other computers * Don't

  2. Spare Parts Database Project

    Mr. Wong; I would have a control on my stock, a good database, and also can update all the stock and at same time fix the price without difficulties. 9. Self: How many employees are there in the business? Mr. Wong: There are three.

  1. Computer Aided Design Package

    There are also seven people who take blueprints out to clients to make sure that they like the drawing before Engineering ? Us constructs the design. These five people also take orders and measurements of the areas where the clients want the items to be placed and deliver the items to the client using a company van.

  2. Robot Prototype design principles.

    The visibility principle: Relevant data and functionality ought to be as visible as possible to a tool user. This principle is predicated on the assumption that the human capacity for recognition is more powerful than recall [Preece 94, pp. 118-121].

  1. Setting up a database for a shop selling P.C.'s.

    - Can be saved on a back-up file if accidentally lost or saved over by another client working in tiny. - The database is user- friendly since it uses bright colours which are a warm contrast purposely designed for users to develop familiarity with a computer and therefore are encouraged to use the computer more often.

  2. Hospital Equipment Loan System.

    These features are available from the right click menu of these text boxes as shown. Depending on the type of data, if there is only a limited selection of available values, I will make use of a different control, which allows the selection of a value from a list, shown to the left.

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