Results 1 to 3 of 3
  1. #1
    JeRz is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    33

    Employee Metric DB-stuck on design

    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!





  2. #2
    JeRz is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2014
    Posts
    33
    I dropped the TblMetrics idea and replaced it with an Employee junction table so that I can populate each metric in its own table with the EmployeeID. Is this the better way to go?

  3. #3
    Join Date
    Apr 2017
    Posts
    1,673
    tblEmployee: EmployeeID, ForeName, LastName, ...;
    tblMetrics: MetricID, MetricCategory, MetricText;
    tblEmployeeMetrics: EmployeeMerticID, EmployeeID, MetricID, MetricValue

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-20-2018, 08:31 AM
  2. Stuck on design
    By jmayojr in forum Database Design
    Replies: 8
    Last Post: 12-15-2017, 07:43 PM
  3. Stuck on DB design
    By lithium in forum Database Design
    Replies: 6
    Last Post: 11-04-2014, 08:38 PM
  4. Stuck on A Table/Form Design
    By dgaletar in forum Access
    Replies: 9
    Last Post: 02-26-2013, 05:41 AM
  5. Using composite keys but stuck badly in the design
    By hmushtaq in forum Database Design
    Replies: 2
    Last Post: 01-25-2011, 12:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums