Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
You are tasked with developing a relational database model for an Employee Attendance System
You are tasked with developing a relational database model for an Employee Attendance System. Refer to your reading assignment for a sample relational database model. The purpose of this system is to provide management with a history of attendance at work and the amount of time off taken by employees categorized by type of time off taken, e.g. vacation, sick, and family leave, etc.
The deliverable for this assignment must include:
- A list of the tables in this model for use in the Employee Attendance System. Each table must contain the top three attributes.
- A list of application areas such as Payroll which will be the source of the transactions necessary to update the Employee Attendance System.
- A system diagram of the Employee Attendance System including databases and source data applications.
- Brief narratives explaining your rationale behind the contents of the data model, system diagram, and list of source applications.
Expert Solution
Answer:
List of tables:
Employees: Emp_ID, Name, Dept_ID
Departments: Dept_ID, Department_Name
AttendenceCaptute: Emp_ID, Date, Attendence_Time
LeaveType : Leave_ID, Leave_Name, Description
LeaveApplication: EmpId, DateFrom, Date_To, Leave_ID
Application Source: Payroll system, Swipe_in Swipe_Out system, Access control system
System diagram is in explanation
Brief narrative is in explanation
Step-by-step explanation
System diagram file is attaching. Also pasting here as a content:
Brief narratives explaining your rationale behind the contents of the data model, system diagram, and list of source applications:
Employee, date of attendance and time of attendance should be captured. If leave is taken then date of leave and type of leave should be captured.
Attendance data could be taken from payroll or if the employee swipe-in his access card then from Swipe-in system or if the customer access his/her workplace then from access control system the data could be taken,
PFA
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.
