Question Production Tracking project (1 Viewer)

new to db work, so any and all help would be appreciated.

looking for help setting up the schema for a project.
goal:
track production for employees towards specific part numbers they work on during a shift.

need reporting to show :
1. total number of part #'s an employee worked
2. what employee's worked a part #
3. what work center did the work and total of work for that work center

so far, i have:

tblEmployees
-employee_id <PK>
-name

tblParts
-parts_id <PK>
-part_number

tblWorkCenter
-workcenter_id <PK>
-workcenter

but that is all i have so far.
any help on where i can look as a guide to keep going?

Hello & welcome to AWF

As a starting point you will need to have junction tables linking employees to parts and workcentres

For example a table: tblEmployeeParts with fields:
EmpPartID - PK
EmployeeID - FK
PartID - FK

NOTE I have deliberately removed underscores - it will make your life much easier if you do that

Next you need to split information so each field holds ONE piece of data
So FirstName, LastName etc

In the Parts table, will the part number be unique - if so that can be the PK field. You also need a PartDescription field and undoubtedly other fields such as Size/Colour etc depending on the nature of the parts used

Apply similar logic to the 3rd table

Strongly recommend to write a list of everything you will need to store then work out the best structure for that
Have a look at the many templates available to help get your thinking right