ASSIGNMENT TWO15 marksDue Fri Oct 28 2022 at 8pmReleased on 19/9/2022, last updated xx/10This assignment should be done in a group of no more than 2 students.This assignment needs to be completed in a group of no more than 2 student members. If such a group isformed, both members must come from the same campus, and also within the tutorial classes of thesametutorwhenever possible. While lecturers and tutors will help as much as they can, it is essentially eachstudent's own motivation and responsibility to form a group for this assignment. By default, each student isworking in a group containing a single member of himself. Students may however make use of thestudentcommunication boardto advertise their availability in seeking an assignment partnership.In the rare case of one group member becoming seriously ill or uncontactable or not responding, the othermember should consider forming a different group or working on his or her own for the assignment. As inreal life, everyone should have a contingency plan, or Plan B, and failure of assignment partnership at anypoint of time will not be accepted as the legitimate reasons for an assignment extension. However, a studentis obligated to properly notify his or her existing assignment partner in good time should it becomeimperative that the student need to terminate the existing partnership due to unexpected circumstances.Marks are not necessarily always proportional to the complexity of the questions or the amount of timerequired to have the problems solved, as we may often need to allocate more marks to the more fundamentaltheories and techniques to ensure they are well covered.Students enrolled in INFS2002 - Database Design and Development (Advanced) must also complete theadvanced partby the same due date.!For all the SQL queries in this assignment, students need to submit their SQL statementsconstructeddirectly, that is, not to generate the SQL script for you by the GUI, as this woulddefeat the purpose of practicing how to formulate SQL queries directly.!All required screenshots must be clearly readable, and the relevant text in on the screenshotsmust be directly legible on a normal A4-sized printout of the submitted document. Otherwisethe screenshots will be deemed having not been submitted.!Students' main document submitted for their answers to this Assignment must be written inMicrosoft Word, not in PDF.Q1.Selected additional exercises (5 marks)i. Complete Questionsαandγin the Additional Exercises for Practical 8. (2=.5+1.5marks)ii. Complete Questionsβandεin the Additional Exercises for Practical 10. (2=.5+1.5marks)iii. Complete Questionsαandβin the Additional Exercises for Practical 11. (1=.5+.5mark)
