ZuoTi.Pro
Question

Diagram the below business rules into a complete EERD. A doctor’s office keeps information on the...

Diagram the below business rules into a complete EERD.

A doctor’s office keeps information on the doctors, the patients, and the medicines

a. An id number and name are associated to each doctor, to each patient, and to each medicine. The ids identify each specific person or item. The doctor’s address, phone, and specialty are stored in the system. The patient’s phone number, address, and insurance carrier are stored in the system. Each medicine’s supplier and cost are stored in the system.
b. A doctor may have many patients and though a patient can see many doctors in the doctor’s office, patients are assigned, in the database, to 1 specific doctor when they make an appointment for their 1st visit.
c. Patients may be prescribed multiple medications and a medication may be prescribed to multiple patients.
d. Medications are categorized as either generic or name brand, but cannot be both

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
Diagram the below business rules into a complete EERD. A doctor’s office keeps information on the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Given the business rules in the first picture and my diagram in the third picture. Please...

    Given the business rules in the first picture and my diagram in the third picture. Please help with the connectivity and the relationship. Please do it exactly like the example in picture 2. Thank you so much! Using the UML Class Diagram notation, create an ERD that can be implemented for a medical clinic using the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with...

  • Assume that you are working with a hospital and this hospital needs a software system to...

    Assume that you are working with a hospital and this hospital needs a software system to track its patients’ information. Your role in this software development is to design the database. There are many aspects of such a hospital software system to develop. However, in this assignment, you will only address interactions between doctors and patients. Your first step will be to create the relations necessary for this system and identify and describe the constraints that would be appropriate for...

  • Do only the bolded questions. Draw a use case diagram for the following dentist office system,...

    Do only the bolded questions. Draw a use case diagram for the following dentist office system, but do not bother to identify the flow of events within each use case. Whenever new patients are seen for the first time, they complete a patient information form that asks their name, address, phone number and brief medical history, which are stored in the patient information file. When a patient calls to schedule a new appointment or change an existing appointment, the receptionist...

  • The Apgar Medical group keeps a patient file for each doctor in the office. Each record...

    The Apgar Medical group keeps a patient file for each doctor in the office. Each record contains the patient’s first and last name, home address, and birth year. The records are sorted in ascending birth year order. Two doctors, Dr. Best and Dr. Cushing, have formed a partnership. make a working version in python JUST NEED THE PYTHON WORKING VERSION, THANK YOU

  • The organization is a dentist office. When new patients are seen for the first time, they...

    The organization is a dentist office. When new patients are seen for the first time, they complete a patient information form that asks for their name, address, phone number, and brief medical history, which are stored in the patient information file. When a patient calls to schedule a new appointment or change an existing appointment, the receptionist checks the appointment file for an available time. Once a good time is found for the patient, the appointment is scheduled. If the...

  • Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient...

    Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient’s last name, first name, date of birth, and date of admission are recorded. Also, every patient is seen by a Physician who develops a treatment plan for the patient. Each Physician may see many patients. Some patients are resident patients (they spend at least one night in the hospital) and others are outpatients (they are treated and released)....

  • Question 3 refers to the relational database with a schema described below: The hospital database contains...

    Question 3 refers to the relational database with a schema described below: The hospital database contains information about the treatments of patients performed by the doctors. The database also contains information on the prescriptions ordered by the doctors. The schemas of relational tables, the meanings of attributes and specifications of primary, candidate, and foreign keys are given below. HOSPITAL HospitalCd Name Address Estate PostalCode EstablishedDate Hospital Code Name of the hospital Address of the hospital The estate where the hospital...

  • Make an ERD using the following description

    WardsThe Hope Hospital has 17 wards with a total of 240 beds available for short- and long-term patients, and an outpatient clinic. Each ward is uniquely identified by a number (for example, ward 11) and also a ward name (for example, Orthopedic), location (for example, E Block), total number of beds, and telephone extension number (for example, Extn. 7711).Staff The Hospital has a Medical Director, who has overall responsibility for the management of the hospital. The Medical Director maintains control...

  • Draw ER Diagrams for the following narratives. Draw ER Diagrams for the following narratives. The Human League Surgery...

    Draw ER Diagrams for the following narratives. Draw ER Diagrams for the following narratives. The Human League Surgery has doctors, nurses, midwives and patients. The patient has to telephone for appointments with the doctors or nurses and these appointments are allocated by the receptionist. An appointment can only be made with one doctor, midwife or nurse at a time. A patient may also only be registered with one doctor. 1. "Authors are responsible for writing plays that are performed in...

  • Explain the core functions of the proposed information system (minimum 4 major functions). ABC medical group...

    Explain the core functions of the proposed information system (minimum 4 major functions). ABC medical group is focusing to provide quality care to all patients. Currently all patient management processes are handled manually. The management wanted to develop a health care system to achieve improved Patient Service and Patient Data Security. The patient care processes are mentioned below: When a patient needs an appointment, the front office must be contacted for required service, If the patient is approaching first time,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT