​​ Practical Assessment Sage 3 In this project, you will only be developing a database for storing and retrieving information about the AusED Academic Staff. You need to create tables, reports and forms using LibreOffice Base. You also need to create SQL queries and views, create normalised tables and create the relationship diagram. The following are some of the requirements of AusED HR : 1. Forms: a.HR Manager should have the form to enter the information about AusED's employees b.HR Manager should have the form to enter information about the allocation of subject per Academic Staff c.Academic Staff should have the form to enter the weekly timesheet 2. Queries: HR Manager wants to see the following queries: 1. List of all Employees and their contact details (sorted by Last Name, then First Name). 2. List and total number of all full-time Academic Staff and their location. 3. List and total number of all part-time Academic Staff and their location. 4. List and total number of sessional Academic Staff and their location. 5. List the names of all academic staff and the type of work they are doing. 6. List the combined total hours worked of all the academic staff per week, the maximum hours worked, minimum hours worked, the name and subject of the academic staff who had the maximum hours , the name and subject of the academic staff who had the minimum hours worked. 7. List the names and location of all of the academic staff teaching a subject (subject will be inputted by the HR Manager). For example, if the HR Manager entered ISYS216, only names and location of academic staff teaching ISYS216 will be shown in the report. 8. List of how many subjects each academic staff is teaching (show the first name , last name and the number of subjects being taught). 9. List of academic staff, their subject and their total hours worked per week per academic staff. 10. List the names of all employees and how long they have worked for AusED. 3. Ta b l e s : 1. In order for you to create the forms and required reports, you must first create tables that will store all the data about the AusED Academic Staff. 2. The following are the activities you expected to do: I. create the database tables II. update the database tables using SQL statements or Form III. add at least 10 rows/records per table What to submit: 1. Please submit the LibreBASE databse you have created. AusED.odb file.