Given the ER-diagrams shown below, describe (in anorganized way) as much as you can about the real worldthat the diagram represents. Be sure to identify what eachentity are relationship are and to describe all constraintsrelated to them. Employ-ID(Supplier IDN1SuppliersupplyOfficeworkEmployesis aReceptionistsTrackNEarlyExpensesis abillsRuns account1is aNNAppointmentdays leftInsurance COMBillsNService cost(Paymentstracks1MangesNhasdental'splanDentistHygienistInsurance PlanPatientsNamepreformspreformsLast NameNFirst NameChildAdultNReceivesserviceSINSINOfserviceN1RecordAppointmentNamedatetimeservice

Answered: iven the ER-diagrams shown below,…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Given the ER-diagrams shown below, describe (in an
organized way) as much as you can about the real world
that the diagram represents. Be sure to identify what each
entity are relationship are and to describe all constraints
related to them.

Employ-ID
(Supplier ID
N
1
Supplier
supply
Office
work
Employes
is a
Receptionists
Track
N
Early
Expenses
is a
bills
Runs account
1
is a
N
N
Appointment
days left
Insurance CO
M
Bills
N
Service cost
(Payments
tracks
1
Manges
N
has
dental's
plan
Dentist
Hygienist
Insurance Plan
Patients
Name
preforms
preforms
Last Name
N
First Name
Child
Adult
N
Receives
service
SIN
SIN
Of
service
N
1
Record
Appointment
Name
date
time
service

Expert Solution

Step 1

Answer :

The entities list of above ER diagram are :

1) office

2) employee

3) Patients.

4) Dentist.

5) Hygentist.

6) Supplier

7) Early expenses.

8) service.

9) Record.

Now all these entities are related to each other as office work in employee and patients take appointment in office . Dentist and hygentist are the employee member , early expenses can be track in office like payment , insurance plan and service cost. Patients may be the child , adult.