diff options
| -rw-r--r-- | assignments/2/README.md | 18 |
1 files changed, 5 insertions, 13 deletions
diff --git a/assignments/2/README.md b/assignments/2/README.md index 9d96c28..fd4ee30 100644 --- a/assignments/2/README.md +++ b/assignments/2/README.md @@ -1,12 +1,4 @@ -Total: 100 marks - -Weight: 15% of your final grade - -Due: After you have completed Unit 6. - -Answer all of the following questions, and upload your completed work here. - -## Question 1 (12 marks) +## Question 1 Consider the following EER diagram for the Royal Victoria Hospital (RVH) database. @@ -26,7 +18,7 @@ Data volume and access for this diagram are as follows: Draw a composite usage map for the RVH database. -## Question 2 (12 marks) +## Question 2 Answer the following questions (250 words max/question). @@ -107,7 +99,7 @@ Answer the following questions (250 words max/question). * Disadvantages: 1. More joins are needed in order to gather the required data reducing query speed or increasing the need for more indexes which increases the amount of needed disk space. -## Question 3 (12 marks) +## Question 3 Answer the following questions (250 words max/question). @@ -158,7 +150,7 @@ Indexed file advantages over hashed file 2. No wasted space for data. Additional space is required to maintain the index. 3. Lower CPU overhead than computing a hash key for each record and hash collisions are not a concern. -## Question 4 (18 marks) +## Question 4 Consider the following database: @@ -206,7 +198,7 @@ CREATE INDEX employee_salary_idx ON Employee(salary); CREATE INDEX employee_names_idx ON Employee(name ASC); ``` -## Question 5 (40 marks) +## Question 5 Consider the following three relations: |