Many to Many Junction

Many to Many Junction

  

Hey, guys, it's me again.


I am doing a many to many relationship using three tables.

(JUNCTION TABLE



EmpTraining

- EmployeesId

- TrainingProcessId

- ScoreId

- DateAquired



Above I am linking a table that has scores for the employees training processes. Is this okay to do? Or should I put the scores into the EmpTraining table directly maybe?

So to this junction table I have three seperate Entities linking to it. One entity that holds employee information, one entitity that holds the training processes, and one entitity that will hold employee scores.

Solution

Hi Jared,

The data model will depend on your requirements, I would say that keep the scores in a different table like you suggested is ok. However if the score is only one mark, so one attribute, you can simplify and make it one attribute directly on your EmpTraining table.


Hope it helps you.

Solution