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.]
store_id is the primary key of the store table and primary keys cannot repeat, they must be unique.
store_id is the foreign key of the staff table and multiple employees can belong to one store.
store_id in the store table is the foreign key which cannot repeat.
Foreign key values can repeat in certain relationships.
 Why can the values in the store id column repeat in

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!