A question about relationships
Posted by: Eslam Elbyaly
Date: January 24, 2018 04:27AM

In a book I am studying, there is the following ERD and there is something I do not understand.
the scenario, there are volunteers who work for an aquarium. every volunteer have a job to accomplish, and every job need a skill of a volunteer or more to be done.
my question is about "job_numb, skill_numb" foreign key columns in "volunteer_schedule" table. Why skill_numb is a foreign key for "skill_numb" in "job_skill_required" table and not to "skill" table?

2- why is "job_numb" is foreign key to "job" table and not to "job_skill_required" table?

Options: ReplyQuote

Written By
A question about relationships
January 24, 2018 04:27AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.