How does the Enforce Referential Integrity option relate to the creation of orphan records?

What will be an ideal response?


Enforce Referential Integrity is a set of rules to help ensure that no orphan records are created in the database. An orphan record is a record in the "many" table that has no match in the "one" table. Checking the Enforce Referential Integrity option prevents this possibility for new records entered into the database.

Computer Science & Information Technology

You might also like to view...

Constant names are always case sensitive.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Memory cards are typically volatile.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Which term describes a method that enables an administrator to limit access to a network based on the physical addresses of wireless NICs?

A. 802.1X B. MAC address filtering C. WEP D. WPA

Computer Science & Information Technology

You can set play options for a video clip with buttons in the Video Options group on the _____ tab.

A. Playback Tools Options B. Playback Tools Format C. Video Tools Playback D. Video Tools Format

Computer Science & Information Technology