Computer Science Projects

Monash Library Services (MonLib) The local Monash Municipality maintains several libraries for its residents across the municipality. For each branch Monash Library Services assigns a branch code (an incremental number for each branch with the first branch using a code of 100). The branch name, address and contact phone number are also recorded. Each branch is assigned a manager. Due to the small size of some of the branches a particular manager may manage several branches. Each manager is assigned a manger id. Monash Library Services record a managers name and contact phone number. All managers are assigned one particular branch as their home branch. Monash Library Services maintain records of current loans of books to borrowers. Each borrower is identified by a borrower number and each copy of a title by a barcode number (the library may have more than one copy of any given title). When a borrower first registers to borrow books the branch where they register is recorded as their...

Task Specification You are required to finish all the following 4 tasks: Task 1 (SQL): This task requires you to write Oracle SQL DML statements. For each of the following, give the Oracle SQL DML query which fulfils the request: a) List the IDs and names of all sandwiches, sorted alphabetically on the sandwich name.  b) Return the number of stores in Bristol (i.e. where the postcode of store starts with BS). c) For each pending (has not been completed yet) order, list the OrderID, the sandwich name used in the order and the name of the bread used in the order. The result need to be sorted by order date, most recent first in the first instance and then by sandwich name alphabetically. Task 2 (PL/SQL) (3 Marks): This task requires you to write Oracle PL/SQL code: a) Write a stored procedure that receives as input 2 dates representing start and end of an interval, and displays the IDs and order dates of orders placed in that time interval, sorted according to the date of ...