contestada

Which of the following does not violate the referential integrity of a database?
inserting a new row into a table with a foreign key that doesn’t match a primary key in the related table
updating a foreign key with a value that doesn’t match a primary key in the related table
updating a primary key in a primary key table without also updating the foreign keys for the related rows in all related tables
deleting a row in a foreign key table without deleting the related row in the related primary key table

Respuesta :

Martebi

The option that  does not violate the referential integrity of a database is option D: deleting a row in a foreign key table without deleting the related row in the related primary key table.

What does referential integrity prevent?

You can avoid adding information to table Y that cannot be connected to information in table X by using a referential integrity rule. Referential integrity also requires that any records that are connected to a deleted record from table X be destroyed as well.

When all values for all foreign keys are valid, a database is said to be in referential integrity. A column or combination of columns in a table that must have values that match at least one of the main key or unique key values of a row in its parent table are known as foreign keys.

Note that removing a row from a table with foreign keys without removing the relevant entry from the related primary key table. Referential integrity, however, is broken when a record from the primary key table is deleted.

Learn more about referential integrity from

https://brainly.com/question/22779439
#SPJ1

Otras preguntas