Data Modeling (Entities) [employee db]
Posted on 2014-08-26
This is not an academic assignment.
This question involves entities only, no attributes. Do you agree with the proposed entities?
I am designing an employee database. The purpose of the database is to maintain the data used to track information about the work performed by the employees and the supervisor. Both the employees and the supervisor work for two different trusts.
Multiple tasks must be tracked. They can occur in a single time period. Here is a sample report that shows two tasks that were completed in 25 minutes.
Mary Smith, Jan. 1, 2014 1:00 p.m. to 1:25 p.m. (a) Entered timesheet information into Quickbooks and (b) Typed notes for attorney.
Here is a second sample report and a description of it:
The employee, subject, topic and task must be associated with each time period. It also has to show the start and stop times of the supervisor and employee task meetings.
Employee: Mary Smith; Subject: Payroll; Jan. 1, 2014 1:00 p.m.; Task: Entered timesheet information into Quickbooks.
Supervisor meetings: 1:05 p.m. - 1:10 p.m., 1:20 p.m. - 1:28 p.m.