DB Project 2nd Test (1)

DB Project 2nd Test (1) - Project Implement a database...

This preview shows page 1 - 2 out of 4 pages.

Project: Implement a database including E-R diagram in MS Access based on the following requirements: FRANK’S RECONSTRUCTION HOSPITAL Frank’s Reconstruction Hospital is a short-term, acute care general hospital. It is a relatively small hospital with 165 beds currently. The basic goal of Frank’s Reconstruction is to provide quality health care to the community wile controlling rising costs. Frank’s Reconstruction Hospital has analyzed their data requirements for a new database by interviewing hospital staff including nurses, doctors, administrators, technician, and clerks by reviewing hospital documents and existing information systems. From this analysis, the following information has been collected. Care Center: A treatment center within the hospital, such as maternity, emergency care, cardiology, rehabilitation, etc. Each care center has a name and a location. Laboratory: a center within the hospital such as radiology or hematology, which performs tests on patients. Labs have a name and location. Patient: a person who is either admitted to the hospital or is registered in an outpatient program. Each patient has a patient number (identifier), name, date of birth, and telephone number. Resident patients have a Date Admitted. Each outpatient is scheduled for zero or more return visits, which have a data and comments. Physician: a member of the hospital medical staff who may admit patients to the hospital and who may administer medical treatments. Each physician has a physician ID (identifier), name, specialty, and pager number in addition to the normal information such as address and telephone number. Bed: a hospital bed that is assigned to a patient who has been admitted to the hospital. Each bed has a bed number (identifier), a composite attribute consisting of the room number and the bed number. Item: any medical or surgical item that may be used in treating a patient. Each item has an item number (identifier), description and unit cost. Items are supplied by Vendors, who also provides supply items for housekeeping and maintenance purposes. Employee: any person employed as part of the hospital staff. Each employee has an employee number (identifier), name, and date hired, as well as mailing address, birth date, and telephone number. Employees are made up of three major groups: nurse, staff, and technician. Only nurses have a Certificate, which indicates the qualification (RN, LPN, etc.) Staff has a job classification;
Image of page 1

Subscribe to view the full document.

Image of page 2
  • Fall '09
  • Physician, care center, FRANK’S RECONSTRUCTION HOSPITAL

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern