Homework answers / question archive / 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

Business

Share With

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.