Provide an overview of their database activities

List two government organisations in Saudi Arabia that use database systems.
Provide an overview of their database activities, and examples of two non-trivial
queries for each organisation. 2% Marks
B. 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. 3% Marks
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
Question 2
A. Critique the differences in file-based and the database approaches. With the helpof
two examples, demonstrate the superiority of the database approach over that of
the file based. 2% Marks
B. Assume you have been contracted to design a database system for the KAU Hospital
(KAUH). You are required to use a systems development lifecycle approach. For each
stage of the database system development lifecycle identify examples of the tasks to
be captured

The post Provide an overview of their database activities appeared first on My Assignment Online.