Community Hospital Database - Assignment Example

IntroductionQuestion 2In this particular paper we delve to highlight in detail the structure of the of the tables in the mounatin view community hospital database file. First and foremost, we start with the patient table. Apparently, it has five fields, as seen below. The data type and other relevant information is clearly seen in the picture below.patient table Secondly, we have the patient treatment table. Notably, it contains information about the patient’s admission and discharge dates.

In addition, it contains five fields, that is, patient#, patient name, patient address, date admitted and discharged and the id of the physician. However, in this case, no primary key is needed since it is possible for a single patient to undergo more than one procedure[Dem03].Patient treatment tableMoreover, we have the physician table. This documents the details of the physician. On that note, it contains, five fields, namely; name of the physician, specialty, id of physician, date and the phone number.

It is worth noting that decisive details’ pertaining to the fields is shown below.Physician table Furthermore, we also have the room utilization table. Apparently, this is mandated with the task of storing information regarding the accommodation of in patients in the hospital. It contains four fields, which are the patient #, location, accommodation and the date discharged. It’s worth noting that the data pertaining to the type, fields’ size among others are shown below.Room utilization tableQuestion 6 Introduction Apparently, it is evident that the use of technology is essential in the smooth running of the Mountain View community hospital.

Notably, it was critical for the incorporation of the database system in order to aid in various processes, for instance the capturing and storage of the patient information among other important information required in a hospital setting[Dem03]. In actual fact, this was reached after a study was conducted in the hospital to establish some of the ways in which services can be improved in this hospital. First and foremost, in order for the above database system to be able to capture certain information, for instance the marital status, gender, occupation, salary or the insurance coverage, appropriate field must be added to the room utilization table and form[Dem03].

However, it is worth noting that the type data in each field should be specified accordingly to avoid errors that might arise. Furthermore, these changes are made to make sure that more information about the patient is given and this in turn will lead to improved quality of service delivery[Dem03]. It is important to note that, with the addition of these fields, the manipulation and operation of this system is user friendly and thus can be used by both the trained and the untrained persons[Dem03].

Since, the above fields are to be reported, a report with the relevant fieldsmust be made. Consequently, this will serve to relay the desired output which is the information: marital status among other[Dem03]. On the same note, a print command may be placed in the form to reduce the time and hence boost efficiency. In conclusion, it is clear that the addition of these fields is meant to better the services of the hospital through ensuring that they gather as much information about the patient as possible.

Work citedDemetriades, Dinos. Information Technology. Oxford: Oxford UP, 2003. Print