Question: (25 points) Given the table CREATE TABLE Persons ( ID INT NOT NULL Last Name VARCHAR(255) NOT NULL FirstName VARCHAR(255) BirthDate DATETIME, Age int Does

(25 points) Given the table CREATE TABLE Persons ( ID INT NOT NULL Last Name VARCHAR(255) NOT NULL FirstName VARCHAR(255) BirthDate DATETIME, Age int Does this trigger correctly enforce the rule that a person's age can only increase? CREATE TRIGGER QuizTrigger AFTER UPDATE OF Age ON Persons REFERENCING OLD ROW AS Old NEW ROW AS New FOR EACH ROW WHEN (Old. Age >New. Age) UPDATE Persons SET Age Old. Age WHERE Age New. Age; Why or why not? (25 points) Rewrite the previous trigger so that it only allows a persons age to be increased by 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

CREATE TABLE Persons ( ID INT NOT NULL, LastName VARCHAR(255) NOT NULL, FirstName VARCHAR(255), BirthDate DATETIME Age int Does this trigger correctly enforce the rule that a person's age can only...

CEAE TABLE Persons ( ID INT NOT NULL, LastName VARCHAR(255) NOT NULL FirstName VARCHAR(255) , BirthDate DATETIME, Age int )i Does this trigger correctly enforce the rule that a person's age can only...

Use the ' Premiere Products Company ' SQL script file found in the D2L content folder called 'SQL Scripts'. Paste the contents of this script into a query tab of MySQL Workbench and execute it. This...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Narrative/Case Study For this lab, you will be creating SQL statements to build a series of relational tables, using SQL CREATE statements in a script file format for the Student Database. You will...

Database: File: prisonDB.sql Create database PrisonDB; Use PrisonDB; Create Table Prison ( prisonerID int auto_increment not null, lastName varchar(25), firstName varchar(25), photo varchar(25),...

Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your...

please help me with this as my tutor fell through and I dont understand all sections these are the programs it gave me this is the main java above this is the grade book reader above these are the...

Assignment 6 Florida International University Student Name: Dario Francis Department of Knight Foundation Student ID: 6 3 6 4 3 3 7 School of Computing and Information Sciences CTS 4 4 0 8 : Database...

Consider the following table of all the ILLINOlS residents. CREATE TABLE Persons( PersonID int, LastName varchar (255) FirstName varchar(255), Address varchar (255), City varchar (255) Age integer...

Factors affecting selection of length of air gap for DC machines

Olathe Company exchanges old delivery equipment for new delivery equipment. The book value of the old delivery equipment is $31,000 (cost $61,000 less accumulated depreciation $30,000). Its fair...

? _ _ _ _ _ _ _ _ _ _ _ _ a r e e x p e n s e s t h a t h a v e a l r e a d y b e e n p a i d a n d c a n n o t b e r e c o v e r e d . Q u e s t i o n 9 o p t i o n s : 1 ) D e p r e c i a t i o n 2...

Company produces three joint products. At the split offpoint three basic prodcuts emerge A,B, and C. each productcan be either sold at the split off point or be processedfurther. if they are...

KEY QUESTION What are the three major legal forms of business organization? Which form is the most prevalent in terms of numbers? Why do you think that is so? Which form is dominant in terms of total...

KEY QUESTION The following are production possibilities tables for China and the United States. Assume that before specialization and trade the optimal product mix for China is alternative B and for...

KEY QUESTION True or False? U.S. exports create a demand for foreign currencies; foreign imports of U.S. goods create a supply of foreign currencies. Explain. Would a decline in U.S. consumer income...