Walk in Clinic
Final Report
Walk-In-Clinic
Table of Contents
Introduction to the Company 3
Description of the company 4
Problems 5
Justification 6
Description of Database and Application Design 7
Entities: 8
Implementing to MS ACCESS: 9
Referential Integrity: 9
Forms 10
Query and Report: 10
Database Application Utilization: 11
Database Administration Issues 11
Conclusion 13
Appendix 14
Introduction to the Company
These days walk in clinics and hospitals, are under strong pressures from several fronts these days. Many of these are because of a strong need for a more comprehensive range of health services, the increasing complexity of identifiable disease and treatment patterns and the fact that more people today than ever before are demanding high-quality medical care. This act was a great challenge to the modern clinics which are dependent for its day-to-day operation on an accurate, rapid and efficient information flow. The solution is to develop an integrated clinical database to help meet the information processing needs of the clinic in an optimal way.
A major problem was the lack of an appropriate clinic database design methodology which was the issue we faced initially as we were working on a hypothetical company, but we had in our minds what are the common walk-in clinic issues these days and how would our group want the database to be designed and implemented if we were running the walk-in clinic.
By definition a walk in clinic is “A facility, often associated with a hospital or medical school that is devoted to the diagnosis and care of outpatients”. There are no appointments needed unless assigned by the doctor on a prior visit according to the patient’s medical needs. The effectiveness of databases derives from one single, comprehensive database much of the information relevant to a variety of organizational purposes may be obtained. In a health care organization the database may be used by walk in clinic for patient care recording, for
Walk-In-Clinic
Table of Contents
Introduction to the Company 3
Description of the company 4
Problems 5
Justification 6
Description of Database and Application Design 7
Entities: 8
Implementing to MS ACCESS: 9
Referential Integrity: 9
Forms 10
Query and Report: 10
Database Application Utilization: 11
Database Administration Issues 11
Conclusion 13
Appendix 14
Introduction to the Company
These days walk in clinics and hospitals, are under strong pressures from several fronts these days. Many of these are because of a strong need for a more comprehensive range of health services, the increasing complexity of identifiable disease and treatment patterns and the fact that more people today than ever before are demanding high-quality medical care. This act was a great challenge to the modern clinics which are dependent for its day-to-day operation on an accurate, rapid and efficient information flow. The solution is to develop an integrated clinical database to help meet the information processing needs of the clinic in an optimal way.
A major problem was the lack of an appropriate clinic database design methodology which was the issue we faced initially as we were working on a hypothetical company, but we had in our minds what are the common walk-in clinic issues these days and how would our group want the database to be designed and implemented if we were running the walk-in clinic.
By definition a walk in clinic is “A facility, often associated with a hospital or medical school that is devoted to the diagnosis and care of outpatients”. There are no appointments needed unless assigned by the doctor on a prior visit according to the patient’s medical needs. The effectiveness of databases derives from one single, comprehensive database much of the information relevant to a variety of organizational purposes may be obtained. In a health care organization the database may be used by walk in clinic for patient care recording, for