From 90e04959bc4a2e739d159337d5722e455fb6f390 Mon Sep 17 00:00:00 2001 From: mo khan Date: Fri, 31 Jan 2020 14:11:24 -0700 Subject: Remove marks --- assignments/2/README.md | 18 +++++------------- 1 file 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: -- cgit v1.2.3