Hey, guys, it's me again.

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



- 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.


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.