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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!