ive made volunteer a subclass of employee as volunteers are given a temprorary employee ID. this seemed to make sense.
as a result i have the following tables:
employee no (PK)
insurance tel no
does this look okay? i think it would cause problems though. for example if i want to do a SQL query showing how many volunteers are working at the company. not to sure how i would present it. maybe passport number needs to be a primary key too? confused lol