Change the Class Diagram to have (Generalization, Aggregation, Composition, Association and multiplicity) relations.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

Change the Class Diagram to have (Generalization, Aggregation, Composition, Association and multiplicity) relations.

doctor
patient
pharmacist
OrderHistory
id
id
-id
- pid
- ph_id
- user_name
- email
user_name
user_name
doctor_name
doctor_fees
pharmacist_fees
- payment_status
- date
- order_id
email
email
password
phone_number
password
- password
phone_number
- phone_number
address
address
address
gender
date_of_birth
gender
date_of_birth
- gender
date_of_birth
DoctorAppointmen
did
time
day
date
availability
PharmacyOrder
PatientReports
PatientAppointments
- pid
- pid
ph_id
- pid
DoctorCategory
did
-did
did
- patientName
- prescription
- dignosis
- note
- date
- order_id
prescription
- dignosis
- note
date
did
patientName
- email
- category
- specialty
- time
- appointmentDate
day
Transcribed Image Text:doctor patient pharmacist OrderHistory id id -id - pid - ph_id - user_name - email user_name user_name doctor_name doctor_fees pharmacist_fees - payment_status - date - order_id email email password phone_number password - password phone_number - phone_number address address address gender date_of_birth gender date_of_birth - gender date_of_birth DoctorAppointmen did time day date availability PharmacyOrder PatientReports PatientAppointments - pid - pid ph_id - pid DoctorCategory did -did did - patientName - prescription - dignosis - note - date - order_id prescription - dignosis - note date did patientName - email - category - specialty - time - appointmentDate day
Expert Solution
steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education