1. What is the purpose of enforcing referential integrity in a relational database?
To require a primary key in each table
To prevent incorrect entries in the primary key field
To prevent orphan records from being created
To validate that data is in a correct format
2. A validation rule does all of the following except
determines what values a field can accept
prevents unreasonable data from being added to the database
provides a list of drop-down values for a field
helps minimize data entry errors
3. Rex & Gwen Co.,an investment firm, is facing a shortage of data storage space. Finn, the assistant manager, suggests that the company purchase a high-end data storage machine. David, the branch manager, approves the suggestion and assigns Betty, his secretary, the task of making a list of vendors. In the context of the roles in the buying center, Finn is most likely the _________.
influencer
evaluator
gatekeeper
initiator