Listed here are some examples of query transactions that should be supported by the University Accommodation Office database system: (a) Present a report listing the Manager’s name and telephone...

Listed here are some examples of query transactions that should be supported by the University Accommodation Office database system: (a) Present a report listing the Manager’s name and telephone number for each hall of residence. (b) Present a report listing the names and banner numbers of students with the details of their lease agreements. (c) Display the details of lease agreements that include the summer semester. (d) Display the details of the total rent paid by a given student. (e) Present a report on students who have not paid their invoices by a given date. (f) Display the details of apartment inspections where the property was found to be in an unsatisfactory condition. (g) Present a report of the names and banner numbers of students with their room number and place number in a particular hall of residence. (h) Present a report listing the details of all students currently on the waiting list for accommodation; that is; who were not placed. (i) Display the total number of students in each student category.
Z02_CONN3067_06_SE_APP2.indd   3 11/07/14   4:43 PM
B-4 | Appendix B  Other Case Studies
(j) Present a report of the names and banner numbers for all students