Since you choose to enforced the referential integrity while creating relationship between Employees table and Social Security table, which of the following would therefore be true?Group of answer choicesIt allows user from deleting a record from Social Security table when there are related records in Employees tableIt prohibits the user from entering a foreign key value in a Social Security table unless the primary key value already exists in the Employees tableIt allows you to enforce marriage between Employees table and Social Security tableIt prohibits the user from entering primary key value in Social Security table unless the foreign key value already exists in the Employees table
Question
Since you choose to enforced the referential integrity while creating relationship between Employees table and Social Security table, which of the following would therefore be true?Group of answer choicesIt allows user from deleting a record from Social Security table when there are related records in Employees tableIt prohibits the user from entering a foreign key value in a Social Security table unless the primary key value already exists in the Employees tableIt allows you to enforce marriage between Employees table and Social Security tableIt prohibits the user from entering primary key value in Social Security table unless the foreign key value already exists in the Employees table
Solution
The correct answer is: "It prohibits the user from entering a foreign key value in a Social Security table unless the primary key value already exists in the Employees table."
Here's why:
Referential integrity is a property of data which, when satisfied, requires every value of one attribute (column) of a relation (table) to exist as a value of another attribute in a different (or the same) relation.
In simpler terms, if you have two tables, Table A and Table B, and you want to create a relationship between them
Similar Questions
Enforcing Referential integrity while creating relationship between two tables ensures that ___________________.Group of answer choicesData can be recognized by the AccessData can be deleted in a related table even if has records in related tablesit enforces the gravity between two tablesData cannot be entered to related tables if original record doesn't exist in original table.
Which key is specifically used to enforce referential integrity between two tables?Group of answer choicesComposite KeyForeign KeySuper KeyPrimary Key
When the referential integrity rule is enforced, which one is usually NOT a valid action in response to the deletion of a row that contains a primary key value referenced elsewhere?Choose one answer. a. Accept the deletion without any other action b. Set the foreign keys of related rows to null c. Do not allow the deletion d. Delete the related rows
Based on the relationship provided above, where referential integrity is enforced, which of the following statements is true?Question 3Answera.Data must be entered into the Students table first.b.Data must be entered into the Enrolment table first.c.Enrolment data can be entered without the unit code.d.The order of data entry does not matter.
A relationship with referential integrity means that the foreign key must have an existing reference in the parent table.Question 4Select one:TrueFalse
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.