Question: What does a user view represent in the context of a database system? Imagine that a hospital wants you to design a database System for
What does a user view represent in the context of a database system? Imagine that a hospital wants you to design a database System for them with two user views, namely the Medical Director and the Incharge Nurse. Provide user's requirements specification for each of these user views, and frame two queries each in plain English belong to these views.
Note 1: The Director is responsible for the overall management of the hospital and must maintain control over the use of resources (including staff, beds, and supplies) in the provision of cost-effective treatment for all patients
Note 2: Incharge Nurse has overall responsibility for the management of a single ward. Incharge Nursing Staff is allocated resources to run the ward and must ensure that all resources (staff, beds and supplies) are used effectively in the care of patients
Note 3: User's requirements is a list of tasks accomplished by the User
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
