Read the following description. "A hospital consists of a number of clinics and offers a number of treatments. Each treatment consists of a number of procedures and each procedure can be conducted at a different clinic. Doctors and nurses are medical staff and work at the hospital. A doctor can be in charge of one or more individual treatments and can perform any of the procedures that are part of the treatments they are in charge of. A nurse reports to an individual doctor and is based at an individual clinic and can perform all procedures offered by the clinic Patients make registration for the entire course of one or more treatments at the hospital but need to need to make individual appointments for each procedure of the treatment with a member of the medical staff." a) Make an Entity/Relationship model for the above description and clearly identify entities, attributes, relationships, cardinality ratios. b) Design an E/R diagram for the above description. c) Implement SQL statement(s) that will create the relevant tables in the Hospital database.

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...
icon
Related questions
Question
Read the following description.
"A hospital consists of a number of clinics and offers a number of treatments.
Each treatment consists of a number of procedures and each procedure can be conducted at
a different clinic.
Doctors and nurses are medical staff and work at the hospital. A doctor can be in charge of
one or more individual treatments and can perform any of the procedures that are part of the
treatments they are in charge of. A nurse reports to an individual doctor and is based at an
individual clinic and can perform all procedures offered by the clinic
Patients make registration for the entire course of one or more treatments at the hospital but
need to need to make individual appointments for each procedure of the treatment with a
member of the medical staff."
a) Make an Entity/Relationship model for the above description and clearly identify entities,
attributes, relationships, cardinality ratios.
b) Design an E/R diagram for the above description.
c) Implement SQL statement(s) that will create the relevant tables in the Hospital database.
Transcribed Image Text:Read the following description. "A hospital consists of a number of clinics and offers a number of treatments. Each treatment consists of a number of procedures and each procedure can be conducted at a different clinic. Doctors and nurses are medical staff and work at the hospital. A doctor can be in charge of one or more individual treatments and can perform any of the procedures that are part of the treatments they are in charge of. A nurse reports to an individual doctor and is based at an individual clinic and can perform all procedures offered by the clinic Patients make registration for the entire course of one or more treatments at the hospital but need to need to make individual appointments for each procedure of the treatment with a member of the medical staff." a) Make an Entity/Relationship model for the above description and clearly identify entities, attributes, relationships, cardinality ratios. b) Design an E/R diagram for the above description. c) Implement SQL statement(s) that will create the relevant tables in the Hospital database.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY