eugenelim0410
New member
- Local time
- Yesterday, 17:35
- Joined
- Aug 13, 2018
- Messages
- 7
I have built several tables for my database which includes the employee, client, engagement, team and task table.
I found that my tables contain a many to many relationship so I created a table to link the both tables.
Please advise if the relationship have any problem.
1 client will have many engagements.
1 engagement will have 1 team each time.
1 team consist of many employees.
1 employee can be allocate into different teams.
Please check the attachment for the relationship.
I found that my tables contain a many to many relationship so I created a table to link the both tables.
Please advise if the relationship have any problem.
1 client will have many engagements.
1 engagement will have 1 team each time.
1 team consist of many employees.
1 employee can be allocate into different teams.
Please check the attachment for the relationship.