Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If we look at the referential integrity of these two tables, what would happen if a new staff member was hired, we added a row
If we look at the referential integrity of these two tables, what would happen if a new staff member was hired, we added a row for that staff to the staff table and gave the storeid the value of as a foreign key value for that new staff member?
You could add the row successfully but your database would not be related properly.
You would not be able to add that store id value of because there is no store with a primary key of in the related table.
A th store would automatically be created by the system.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started