Question
Create a ERD diagram follwoing this: Entities Entities Doctor Nurse Patient Equipment Company Clinic University Certification HelpDesk Relationships Doctors/Nurse WorkIn Clinic Doctor/Nurse attend Universities Doctors/Nurse
Create a ERD diagram follwoing this:
Entities
Entities
Doctor
Nurse
Patient
Equipment
Company
Clinic
University
Certification
HelpDesk
Relationships
Doctors/Nurse WorkIn Clinic
Doctor/Nurse attend Universities
Doctors/Nurse receive Certificates
Nurse TendTo Patient
Doctors diagnose Patient
Company produce Equipment
Doctors/Nurse use Equipment
Patients registerWith HelpDesk
Attributes
Address (AddressID, Street, ZipCode, State)
Employee (EmpID, FirstName, LastName, EmailAddress, DOB, AddressID(FK), ClinicID(FK))
Doctor (EmpID, Specialty, CertificationID(FK), UniversityID(FK))
Nurse (EmpID, CertificationID, UniversityID)
Patient (PatientID, FirstName, LastName, DOB)
Company (CompanyID, CompanyName)
Equipment (EquipmentID, EquipmentType, EquipmentName)
University (UniversityID, UniversityName)
Certificate (CertificateID, CertificationType, CertificationName)
Clinic (ClinicID, Location, AddressID)
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