Suggest three typical business situations where referential integrity avoids data problems.
What will be an ideal response?
Students might respond with examples similar to the following.
Referential integrity would avoid problems such as:
• Entering an order for a customer number that does not exist
• Deleting a customer who still has open orders pending
• Entering a part number in an order for a part that has not been entered in the system yet
• Entering a reservation code for a passenger who has not been entered in the system yet
• Registering a student for a course that has not been entered into the system yet
• Deleting a course that has students in it
You might also like to view...
Change the prompt string to a smiley face such as :-)
What will be an ideal response?
The following session performs the given tasks.
What will be an ideal response?
In a formatted text file, ________ signal(s) the beginning and end of a formatting command.
Fill in the blank(s) with the appropriate word(s).
_________ resources include people, hardware, and the supporting system elements and resources associated with the management of information in all its states.
Fill in the blank(s) with the appropriate word(s).