[BigR1983]

Hi All,

I am trying to come up with a database design to hold employees task information that they have completed during the week.

I am stumped at where to begin with it. Should I create a table with all the employees, a table with a list of tasks, and a table that holds the reports?

Any advice would be greatly appreciated.

[JaKWaC]

I'd start with the employee table since its the "master" every report requires an employee to own it and every task is assigned to an employee I assume.

[macosxnerd101]

Quote

I am stumped at where to begin with it. Should I create a table with all the employees, a table with a list of tasks, and a table that holds the reports?

This is the route I would take. Design an Employees table to model your Employees, and a Tasks table to keep track of the work being done. Then create a linking table to relate Employees to tasks, since multiple Employees can be assigned to the same Task. I would just use the employee_id and task_id as a composite PK in the linking table.

[BigR1983]

Thanks guys, I will start there