AssignmentIncludes Studentld Course Code AssignmentNumber FormNumber s09 c2 1 SC 754 s10 1 SC458 C4 Examination Studentld CourseCode Examination Location Mark s05 Bath 57 s07 Bedford 85 s09 New York 56 Taunton s09 Taunton 71 s10 Gateshead 888888 S09 63 ExamIncludes Studentld CourseCode s05 FormNumber SC245 27 SpecialCircumstancesForm FormNumber Date Received SC245 2004-10-19 SC458 2004-04-16 SC754 2004-03-07 74 Course Code c4 c5 Assignment Studentld CourseCode AssignmentNumber Mark s01 c4 1 80 s01 c4 2 s02 1 70 S02 2 65 S02 3 73 s02 1 53 S02 2 58 s05 c2 1 78 s05 c2 2 63 s07 1 91 s09 c2 1 92 s09 c2 2 s09 c4 1 s10 c4 1 45 s22 c2 1 74 s22 2 68 s38 1 51 s38 3 43 s57 c4 1 93 s57 2 s57 C4 3 84 s57 c5 1 Enrolment Studentld s01 s02 s02 s05 s05 s07 c2 c7 c4 76 85 s09 s09 EnrolmentDate 2005-01-12 2005-01-01 2005-06-12 2004-06-04 2004-10-18 2004-12-12 2004-12-16 2004-12-18 2004-12-15 2004-06-20 2005-05-05 2002-03-15 2003-09-18 2004-03-09 2002-03-01 2001-06-30 2003-01-20 s09 c7 c7 c4 s10 s10 s22 s38 s38 546 s57 s57 C4 82 & R&R 74 c4 Course Course Code c2 c4 Credit 30 Title Syntax Semantics Logic Pragmatics Course Code c4 60 60 30 Quota CourseCode 888 QuotaLimit 3000 250 250 Date Reviewed 2007-01-10 2007-01-10 2006-04-23 Tutors Studentld s01 S02 SO2 s05 s05 s07 s09 s09 s09 s10 s10 s22 538 s38 546 s57 s57 c7 C4 c2 c4 c7 C4 c7 StaffNumber 3158 5324 5212 5324 5324 3158 8431 5324 5324 5324 5324 6451 3678 3678 4219 5212 7774 Telephone TutoredBy StaffNumber CourseCode 3158 5324 c7 6451 7774 8431 R&R $ $ $ 8 (b) Write SQL queries to answer the following requests. In each case, make sure that the result table represents a relation and include that table with your answer. (i) Give the identifier and mark for each student who in assignment 1 of the course c4 received a mark which was either less than 50 or greater than 85. (3 marks) (ii) Give the name of each drug which is prescribed for low temperature. (4 marks) AssignmentIncludes Studentld Course Code AssignmentNumber FormNumber s09 c2 1 SC 754 s10 1 SC458 C4 Examination Studentld CourseCode Examination Location Mark s05 Bath 57 s07 Bedford 85 s09 New York 56 Taunton s09 Taunton 71 s10 Gateshead 888888 S09 63 ExamIncludes Studentld CourseCode s05 FormNumber SC245 27 SpecialCircumstancesForm FormNumber Date Received SC245 2004-10-19 SC458 2004-04-16 SC754 2004-03-07 74 Course Code c4 c5 Assignment Studentld CourseCode AssignmentNumber Mark s01 c4 1 80 s01 c4 2 s02 1 70 S02 2 65 S02 3 73 s02 1 53 S02 2 58 s05 c2 1 78 s05 c2 2 63 s07 1 91 s09 c2 1 92 s09 c2 2 s09 c4 1 s10 c4 1 45 s22 c2 1 74 s22 2 68 s38 1 51 s38 3 43 s57 c4 1 93 s57 2 s57 C4 3 84 s57 c5 1 Enrolment Studentld s01 s02 s02 s05 s05 s07 c2 c7 c4 76 85 s09 s09 EnrolmentDate 2005-01-12 2005-01-01 2005-06-12 2004-06-04 2004-10-18 2004-12-12 2004-12-16 2004-12-18 2004-12-15 2004-06-20 2005-05-05 2002-03-15 2003-09-18 2004-03-09 2002-03-01 2001-06-30 2003-01-20 s09 c7 c7 c4 s10 s10 s22 s38 s38 546 s57 s57 C4 82 & R&R 74 c4 Course Course Code c2 c4 Credit 30 Title Syntax Semantics Logic Pragmatics Course Code c4 60 60 30 Quota CourseCode 888 QuotaLimit 3000 250 250 Date Reviewed 2007-01-10 2007-01-10 2006-04-23 Tutors Studentld s01 S02 SO2 s05 s05 s07 s09 s09 s09 s10 s10 s22 538 s38 546 s57 s57 c7 C4 c2 c4 c7 C4 c7 StaffNumber 3158 5324 5212 5324 5324 3158 8431 5324 5324 5324 5324 6451 3678 3678 4219 5212 7774 Telephone TutoredBy StaffNumber CourseCode 3158 5324 c7 6451 7774 8431 R&R $ $ $ 8 (b) Write SQL queries to answer the following requests. In each case, make sure that the result table represents a relation and include that table with your answer. (i) Give the identifier and mark for each student who in assignment 1 of the course c4 received a mark which was either less than 50 or greater than 85. (3 marks) (ii) Give the name of each drug which is prescribed for low temperature. (4 marks)