Answer To: ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 1 of 10 ASSESSMENT BRIEF Subject Code...
Ankit answered on Dec 08 2020
Student_Id
Student_Name
Title of Assignment
1. Introduction
The main purpose of this document is to develop database design for academic staff and admin staff for Torrens We Help Inc (TWHI). “Torrens We Help Inc (TWHI) is a not-for-profit private education organisation. It provides online education in farming anywhere in the world. The majority of their students are from outback areas of Australia, Papua New Guinea and New Zealand. TWHI wants to engage and work in partnership with communities, industries and businesses. It seeks to provide multiple learning experiences and opportunities to enrich the learning journey of its students. TWHI prides itself on being an inclusive provider, offering higher education to people who might not otherwise have the opportunity to experience it. To this end many of its students have their fees paid partially or fully by the Australian, PNG or New Zealand government.”
The database software is developed for TWHI in software MSaccess that consist of tables, relationship, forms and reports. The design of tables is listed below:
1. Employee information (Employee ID, Title, First Name, Middle Name, Last Name, Birthdate, Street Address, City State, Postal Code, Phone Number, Mobile Number, Date Hired, Date Terminated, TFN, Department, Location)
2. Timesheet for teaching staff (name of staff, hours worked per week, type of work, (e.g., online facilitation, assessment marking, consultation), hourly rate, subject name, number of students)
3. List of subjects that teaching staff is approved to teach (name, list of subjects)
4. Information about the teaching staff (name, location, contact details, status (part-time, full-time, sessional)
5. Administrative staff information (name, position, status (part time or full-time)
6. Teaching staff leave/absence spreadsheet (name of staff, position, status, no of leave allowed, no of sick leave allowed, dates of leave/absences, type of leave, remaining leave, remaining sick leave, paid/not paid leave, status (approved or not)
7. Administrative staff leave/absence spreadsheet (name of staff, position, status, no of leave allowed, no of sick leave allowed, dates of leave/absences, type of leave, remaining leave, remaining sick leave, paid/not paid leave, status (approved or not)
8. Staff Professional Development Activities (name of staff, date of activity, type of activity, description of activity, report submitted, funding type)
2. Need for the implementation of the database
“Microsoft Access is database management software as it dramatically decreases the amount of time required to exchange and leverage information between Microsoft Office applications. Microsoft access provides database management functionality for academic staff of TWHI Human Resource and is highly extensible with enterprise systems by professional developers.”
3. 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
4. Reports
· List of all Employees and their contact details (sorted by Last Name, then First Name)
List and total number of all full-time Academic Staff and their location
List and total number of all part-time Academic Staff and their location
List and total number of sessional Academic Staff and their location
List the names of all academic staff and the type of work they are doing.
List the names of all employees and how long they have worked for TWHI
Tables
Database: Acedemic staff has following tables in 3 normal forms:
1. create table Employee(Employee_id number,Employee_title text,Employee_fname text, Employee_lname text,Employee_dob date,Employee_address text,Employee_state text,Employee_postalcode text,Employee_phno text,Employee_mobile text,Employee_hire_Date date,Employee_terminated_date date,TFN text,Department text,Location text);
2. Create table Timesheet(ID number, employee_id number, Hours_works_week text, Type_work text, Hourly_rate number, Subject_id number, Number_student_subject text);
3. Create table Subject(Subject_id number, Subject_code text, Subject_name text);
4. Create table Subjects_approved(ID number, Subject_id number, Employee_id number);
5. Create table Staff_teaching(id number, employee_id number, Staff_location text, Staff_mobile text, Staff_status text);
6. Create table Admin_staff(Admin_id number, Admin_name text, Admin_position text, Admin_status text);
7. Create table Staff_Activity(ID number, employee_id number, activity_date date, activity_type text, activity_desc text, report_submitted text, funding_type text);
8. Create table Leave_info_Admin(id number, admin_id number, admin_position text,...