Module Four Quiz 4-1 | Latest Update | 2024/2025 | Graded A+

Module Four Quiz 4-1 | Latest Update | 2024/2025 | Graded A+ A ride-sharing app's discount system for riders is configured such that a ride discount is triggered only if at least two RiderIDs book a ride in the same CarID at the same time. Which of the following is true of the relationship RideDiscount-is-Applicable? Select one. The relationship minimum for RideDiscount-is-Applicable is One-Two given the business rule described. If you wanted to delete the column ChildAge from the table Children, which statement should you use? Select one. ALTER TABLE Children DROP ChildAge; In order to be used as a primary key, which of these characteristics must an attribute possess with respect to a single instance of the entity? Select all that apply. an attribute is termed singular when there is a maximum of one attribute instance. An attribute is unique when each instance of it describes at most one entity instance. It is a required attribute if there needs to be at least one instance of it. ON UPDATE or ON DELETE keywords specify action on the FOREIGN KEY constraint on a table and must be followed by one of four keywords that respond in a specific manner under certain conditions. These four keywords and the purpose of each are listed in the table. Match each keyword to its purpose. Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once. RESTRICT rejects an insert, update, or delete that violates referential integrity; it is applied by default if no action is specified. SET NULL sets an invalid foreign key value to NULL SET DEFAULT sets invalid foreign keys to a default primary key value. CASCADE propagates primary key changes such as deletions or updates to related foreign keys. Preparing for a hackathon at his high school, your cousin messages you the following code snippet for an app-based service targeted at high school students: CREATE TABLE Limos ( Code TINYINT