Kayleigh
Member
- Local time
- Today, 07:45
- Joined
- Sep 24, 2020
- Messages
- 706
I am considering the best way to structure one component of my DB.
The scenario is that each person has certificates so there is a table for people and another table for certificates. However we also have the education details for some people which we record in another table with foreign key to people table. My question is how can I have certificates linked to the education table whilst allowing certificates to be entered individually not linked to a specific record in education?
The scenario is that each person has certificates so there is a table for people and another table for certificates. However we also have the education details for some people which we record in another table with foreign key to people table. My question is how can I have certificates linked to the education table whilst allowing certificates to be entered individually not linked to a specific record in education?