For Ass 1 Quiz 1, your mark will be determined by your highest grade. You will receive a grade as soon as you submit. You are encouraged to re-attempt this quiz until you have received full marks. If you are marked incorrect for an answer that you think is correct, please discuss the question with your lecturer or email Jamie: [email protected] Ass 1 Quiz 2 (16 marks) Your last attempt at Ass 1 Quiz 2 will be manually graded. You will not receive feedback for this quiz until approximately two weeks after the assignment deadline.Using the database provided, write SQL queries that satisfy the following information requests. • Your queries should produce the expected result (including column names, grouping, duplicate removal, and ordering) shown in each information request. • Your queries must order the result as requested. If the information request does not mention a required ordering, your query does not need to order the result. • Where appropriate, your queries must remove duplicates from the result. • Simple queries are preferred. Marks may be lost for unnecessarily complex queries. Part B – Form development activity (3 marks)Using the database provided, develop a form name frmPartBNeighbourhoodWatchGroup that allows you to easily enter the details for a new neighbourhood watch group.The form should at least display the name, alias, area type, status and suburb of the Neighbourhood Watch Group.You are allowed to use any suitable user-friendly layout to develop the form.Make it easy for the user to enter the new details: • Use user interface controls such as list box, combo box, checkbox, or option buttons to allow easy data entry. • Provide a drop-down combo-box of Suburb names. • Include a sub-form that shows all other neighbourhood watch groups in the same suburb. Hint: define your own link that relates the Suburb Id with all of the other Suburb Ids.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here