The Phoenix hospital Essay Example for Free

The Phoenix hospital EssayThe Phoenix Hospital has asked me to create a computer action to replace the existing manual one. In this system patient details have to be unplowed and breeding about borrowing of equipment. Records must be kept of what equipment has been borrowed, by whom and when, and also if any equipment is not available because it is being repaired. Aim My aim is to successfully create a database for the hospital, which they plunder4 use on an unremarkable basis. The database get out need to Ability to store details of equipment. Item code to identify the item and the oddb both of equipment. For each piece of equipment it must find- whether it is available, being repaired or out on loanword if on loan, to whom and at what address or ward number if on loan, when is it due to be returned or the loan renewed if being repaired, when was it sent for repair Produce a hard copy of the above information for any piece of equipment. Equipment is lent out for a 6- w eek period, this can be renewed for periods of 6 weeks. Patients may have more than one piece of equipment on loan at a item time. At any one time, about half the equipment will be out on loan and 1 or 2 pieces will be in for repair. Names and addresses of patients are to be invented. protect numbers are W1- W10. At the end of each week, a full report of the location of all equipment is to be produced. If equipment is due for return or renewal during the following week, that patient will be contacted. thither is a standard letter for this purpose. jut out Definition of data Requirements I need to design tables, forms and queries which will enable me to meet the above aims. Record Structure Patient Table Field Name Data Type Field Length/ Format Validation Rule Input Mask Patient id AutoNumber massive Integer Title textbook 5 Forname Text 50- Surname Text 50 gender TextLoan ID Number Long Integer Item ID Text 50 Returned Yes/No flesh 6 Loan Table Record Structure Design of Form s Patient Form Figure 7 Design of Patient Form Equipment Details Form Figure 8 Design of Equipment Details Form experience Screen Form Figure 9 Design of Welcome Screen Repair Form Figure 10 Design of Repair Table Design of melodic themes Locations Report Figure 11 design of Locations Report Equipment on Loan at End of Week Report Figure 12 Design of Equipment on Loan at End of Week Report Security and Integrity of Data Security and faithfulness are very important aspects of a database.I have made sure the database is secure from hackers, thieves and from global mistakes messing up the system. Security can be done using passwords to keep out people who shouldnt glide path areas. There are different levels of access rights these are read-only, Read/Write and No Access. Backup can help keep hold of important data in the event of the system being destroyed. thence the more frequently that backups are done the better. Integrity will minimize the amount of errors going into the sys tem. authorize data in the database will help keep it in good working order and contact it easy to search for data when needed.