Database System - Assessment Answer

1IEDJ

Database System – Private Education Organisation

Task:

The aim of this assessment is to assess the student’s ability to solve business problems using database design tool and software. It also aims to enable students to think about the impacts of using IT in Businesses and communicate key issues through a written report. Many companies depend on the accurate recording, updating and tracking of their data on a minute- to-minute basis. Employees access this data using databases. An understanding of this technology allows business professionals to be able to perform their work effectively.

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 Indonesia, Papua New Guinea and Vietnam. 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 Indonesian, Papua New Guinean and Vietnamese government. One of their projects is called Project "HR DATABASE". The following are the stages:
Stage 1: Develop HR Database System for the Academic Staff
Stage 2: Extend the Database system to include administrative Staff
Stage 3: Develop a Partners database
You have been assigned to develop part of the stage 1 of the project.

TWHI has used a spreadsheet software to maintain and monitor its employee information. Its human resource (HR) department is currently struggling get the updated information of its entire academic and administrative staff. The HR manager maintains the following spreadsheets for the academic staff:
• 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)
• Timesheet for academic staff (Employee ID, hours worked per week, type of work, (e.g., online facilitation, assessment marking, consultation), hourly rate, subject code, number of students)
• List of subjects that teaching staff is approved to teach (Subject Code, Employee ID, Subject Name)  Information about the teaching staff (name, location, contact details, status (part-time, full- time, sessional)
• Class details (Class code, class name, semester offered ,year offered)