Question
Youve been hired to do the initial design of an object-oriented database for a local medical doctors office. Assume you have conducted the initial interview
Youve been hired to do the initial design of an object-oriented database for a local medical doctors office. Assume you have conducted the initial interview with office personnel, and you have gathered the data given below. You may need to make some logical assumptions to clarify this information. Specify key (and basic) attributes of each entity type, and mapping/structural constraints on each side of the relationship type, such as cardinality and participation. Be particularly careful to list any attributes that are mentioned in these notes. In your design, note any unspecified requirements and the appropriate assumptions used to make the specification complete. This office is a partnership between two doctors. The office maintains patient information: SIN, name, address, home phone number, work phone number, employer name, employer address, pertinent medical history (illnesses, allergies, medical allergies to drugs, blood type, etc.), current medical history with this office (i.e., a record of all previous visits to this office). The office filing system is based on patient appointments, and therefore a schedule of appointments is maintained. The office files medical insurance claims for patients, and has contracts with several insurance companies. The office processes accounts receivable and payable. For each patient, the office maintains information about the party responsible for the patient with respect to their medical bills and medical permission for procedures. Each medical procedure has a unique medical code, which is used to file insurance claims, and to determine the amount of the bill. Patients may have multiple procedures performed in one visit. Each of the two doctors has hospital privileges at (possibly different and multiple) hospitals. Each doctor has a state medical license and a local business license. The office files monthly reports with the state concerning the diseases that were treated. The office has an answering service that provides information on all messages after hours. Your database will also need to maintain information on the office staff and professionals. Draw a class diagram for the above situation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started