A question about relationships
Hi,
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?
Subject
Written By
Posted
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.