Question: Why can the values in the store id column repeat in the staff table, but not the store table? [ Check all that apply. ]
Why can the values in the store id column repeat in the staff table, but not the store table? Check all that apply.
storeid is the primary key of the store table and primary keys cannot repeat, they must be unique.
storeid is the foreign key of the staff table and multiple employees can belong to one store.
storeid in the store table is the foreign key which cannot repeat.
Foreign key values can repeat in certain relationships.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
