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

    The speed is one of the major factors, but must create a system that does not take up vast amounts of memory. Costs: The initial starting out costs will be the machine purchase, and basic unit for it to go on (unless already owned).

  2. Computer Aided Design Package

    by the company to enable it to do all the work required is the A0 plotter and graphics tablets. An A0 sized plotter will be used to print off the CAD drawings on A0 paper and used to show the blueprints to the clients, they then decide if they like it or not from these blueprints.

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

    Each field as above (query output forms) is in point 10 and in a clear and legible font, which is, well defined and easy to read. Also the forms will be clear of images as they are not really needed, and there are large rewind and fast forward buttons to manually take the user through the records.

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

  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

    Self: Do you think the computerization of your business will help to reduce the problem you are facing? Mr. Wong; Yes, I am sure that the computerization of my business will help me to reduce my problem. 8. Self: How do you think that it will help you? Mr.

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