In DBMS software referential integrity ensures that

Question

BlackTom AI · Accepted Answer

In DBMS software referential integrity ensures that
Option a: 'a value entered into field as a primary key already exists as a foreign key value in a related table.' This swaps the typical relationship direction. Referential integrity is about ensuring that a foreign key value corresponds to an existing primary key in the related table, not the other way around. So this option is incorrect because it describes a reversed relationship.
Option b: 'a value entered into field as a foreign key already exists as a primary key value in a related table.' This is the correct description of referential integrity. It ensures that any value placed in a foreign key column must match a primary key value in the related table, maintaining valid references across tables.
Option c: 'each primary key is an autonumber.' This is not a requirement of referential integrity. Autonumbering (automatic generation of primary key values) is a design choice, not a rule that enforces referential links between tables.
Option d: 'each foreign key is an autonumber.' This is incorrect because foreign keys typically reference primary keys; they are not usually autonumbered themselves. Autonumbering a foreign key would undermine the purpose of linking to the related table’s primary key and is not a definition of referential integrity.

In DBMS software referential integrity ensures that单项选择题

类似问题

In DBMS software referential integrity ensures that

A new café ordering database allows orders to be entered even when the customer ID does not exist in the customer table. Later, reports show orphaned orders that cannot be tied to real customers. Which database control would have best prevented this?

Question at position 4 A referential integrity constraint is a rule that maintains consistency among the rows of two relations.TrueFalse

Consider the Baseball database used in a number of class examples. We enforced referential integrity for Teams and Batters. This means _________

Question at position 26 Referential integrity requires that if a field (attribute) references the value of another field (attribute), such as the situation with foreign keys, then the referenced value must exist.TrueFalse

Referential integrity means:

Which statement best explains referential integrity?

Which referential Integrity enforcement option would you select if you want to prevent a user from deleting a record in a parent table (e.g., Customer) as long as it is still referenced by records in a child table (e.g., Orders)?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单