Question: 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
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.
- Ibekwe-SanJuan, F., & Bowker, G. C. (2017). Implications of big data for knowledge organization. Knowledge Organization, 44(3), 187-198. https://www.sciencedirect.com/science/article/abs/pii/S0306437916303398?via%3Dihub
- (To view this reading, please open the link provided and download the "PDF full text.")
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.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
