COMP 378 Lecture 1: Comp 378ass2qs1
Comp 378 - Assignment # 2
Question 1 (12 marks)
Consider the following EER diagram for the Royal Victoria Hospital (RVH) database
Data volume and access for this diagram are as follows:
There are 1 000 patients and 500 items yielding a total of 10 000 usage records in the database.
There are 50 physicians and a total of 4 000 prescriptions in the database.
There are 200 treatments in the database.
There are 50 accesses per day for patient records; of these, 30 request access to both prescription and
usage records.
There are 20 accesses per day for physician records; of these, 20 request access to prescriptions.
There are 50 accesses per day to item records; of these, 10 request access to usage records.
There are 5 direct accesses per day for treatment records.
Of the total accesses to prescription records, 20 request access to patients, 30 request access to
physicians, and 35 request access to treatment.
Of the total accesses to usage records, 10 request access to patients and 30 request access to items.
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
Consider the following eer diagram for the royal victoria hospital (rvh) database. Data volume and access for this diagram are as follows: There are 1 000 patients and 500 items yielding a total of 10 000 usage records in the database. There are 50 physicians and a total of 4 000 prescriptions in the database. There are 50 accesses per day for patient records; of these, 30 request access to both prescription and usage records. There are 20 accesses per day for physician records; of these, 20 request access to prescriptions. There are 50 accesses per day to item records; of these, 10 request access to usage records. There are 5 direct accesses per day for treatment records. Of the total accesses to prescription records, 20 request access to patients, 30 request access to physicians, and 35 request access to treatment. Of the total accesses to usage records, 10 request access to patients and 30 request access to items.