Hi Everyone,
I am attempting to design an employee database but I'm currently having an issue when trying to define the proper relationships for a portion of this.
The purpose of the database is to track call center employees and their metrics. The metrics fit into 4 categories. The issue I'm having is trying to determine how to link these categories to the employee. I have each category in its own table already?as each metric does has its own set of info. The categories are: Attendance, Discussions, Quality, and CAP.
I currently have a one to many setup for my first relationship as
TblEmployee
EmployeeID PK
EmpFName
EmpLName
TblMetrics
EmpMetricID PK
MetricCategory
EmployeeID FK
Can I use a junction table next to link in EmpMetricID and add the PKs of the individual metrics? Example: AttendanceID, QualityID, DiscussionID and CAPID to relate the individual metric tables? If not, can anyone suggest how to proceed from here?
I've begun going through various design resources but table design and structure is something that I am having a difficult time with for some reason. I've spent so much time scratching on paper with ideas for this. I am concerned I got myself all confused at this point so I'm questioning myself now.
Please let me know if any additional info is needed.
Thank you for any help!