Course Hero Logo

15288089.pdf - ASSIGNMENT TWO 15 marks Due Fri Oct 28 2022...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 6 pages.

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)

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 6 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
One
Professor
N/A
Tags
Entity relationship model, Relational model, partner

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture