COMP 266 Chapter qs 12: Questi12
Question: Consider the following EER
diagram for the Royal V...
Bookmark
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.
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
Question: consider the following eer diagram for the royal v 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.