A hospital has a large number of registered nurses. Attributes of Nurse include N_ID (the primary key), N_Name, and Phone_No. Attributes of PATIENT include Patient_ID (the primary key), Patient_Name. Any patient who is admitted must have one and only one nurse. A nurse may take care of any number of patients. Draw an E-R diagram and convert it into

C++ for Engineers and Scientists
4th Edition
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Bronson, Gary J.
Chapter5: Repetition Statements
Section5.1: Basic Loop Structures
Problem 5E: (For review) a. What’s the difference between a pretest and posttest loop? b. If the condition being...
icon
Related questions
Question

(DB Design)

A hospital has a large number of registered nurses. Attributes of Nurse include N_ID (the primary key), N_Name, and Phone_No. Attributes of PATIENT include Patient_ID (the primary key), Patient_Name. Any patient who is admitted must have one and only one nurse. A nurse may take care of any number of patients. Draw an E-R diagram and convert it into corresponding tables. 

Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Requirement Analysis
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.
Recommended textbooks for you
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning