Which type of database constraint does the following trigger implement?a.Key constraintb.Dynamic integrity constraintc.Static integrity constraintd.Inter-relational integrity constraint DELIMITER $$CREATE TRIGGER TRG_BEFORE_UPDATE_ON_partBEFORE UPDATE ON part FOR EACH ROWBEGINDECLARE errorMessage VARCHAR (255) ;SET errorMessage = CONCAT ( ' The new selling price of ',NEW.part_sellingprice,' cannot be 2 times greater than the current sellingprice of ',OLD.part_sellingprice);IF NEW.part_sellingprice > OLD.part_sellingprice * 2 THENSIGNAL SQLSTATE '45000'SET MESSAGE_TEXT = errorMessage;END IF;END $$DELIMITER;

Summary: We need to identify the type of database constraint that will implement the given trigger.

Answered: Which type of database constraint does…

Which type of database constraint does the following trigger implement? a.Key constraint b.Dynamic integrity constraint c.Static integrity constraint d.Inter-relational integrity constraint

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 7TD: Delete the index named ITEM_INDEX3.

See similar textbooks

Similar questions

The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0 THIS IS IN SQL FORMAT FOR CENGAGE MINDTAP, PLEASE HELP I AM STUCK
plz quickly ?????????????? /*Inserting into patient table*/ INSERT INTO patientVALUES ('1234','Kim Minji','06-05-1994','0557375017'); INSERT INTO patientVALUES ('1334','Han Sohee','06-07-1996','0567374017'); INSERT INTO patientVALUES ('1434','Jeon soyeon','07-10-1998','0537372017'); INSERT INTO patientVALUES ('1646','Lee Taemin','18-06-1993','0501346257'); INSERT INTO patientVALUES ('1645','Yu jimin','11-09-2000','0501846257'); select*from patient; /*Inserting into Doctor table*/INSERT INTO DOCTOR VALUES(2000432, 'khaled' , '05-12-1994' , 0556677880,'Dermatologists'); INSERT INTO DOCTOR VALUES(2000509, 'Ali' , '09-01-2000' , 0559918100, 'Dentistry'); INSERT INTO DOCTOR VALUES(2000389, 'Lewis' ,'21-01-1996' , 0559910000,'Family Physicians'); INSERT INTO DOCTOR VALUES(2000504, 'Saleh' ,'16-06-1998' , 055611500,'Family Physicians'); INSERT INTO DOCTOR VALUES(2000235, 'sara' ,'22-06-1998', 0557745500,'Orthopedics'); select *from doctor; /*Inserting into appointment table*/ INSERT INTO…
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the Driver ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2019-12-28 Driving License Checked: True Rating: 4.0
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Answer in MYSQL please
Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the second SMALLINT (INOUT) parameter. The procedure checks the parameter and, if there are no errors, inserts the value into tblPlayers. Documentation of errors Condition Error code No errors 1st param Null or zero len playerID taken 1 proclnsertGame will receive two IN VARCHAR(16) interpreted as
DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( ); 0 INSERT ); WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST NAME TEXT, LAST NAME TEXT, SALARY INTEGER (15), JOINING DATE DATETIME, DEPARTMENT CHAR (25) INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES 'Arora', 100000, '14-02-20 09.00.00', 'HR'), (001, 'Monika', (002, 'Niharika', 'Verma' 80000, '14-06-11 09.00.00', 'Admin'), 'HR'), 'Admin'), Admin'), 'Account'), 'Kumar', 75000, '14-01-20 09.00.00', 'Account') DROP TABLE IF EXISTS Bonus; CREATE TABLE Bonus ( ); (003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00', (004, 'Amitabh 'Singh', 500000, '14-02-20 09.00.00', (005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'. (006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00', (007, 'Satish' (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin'); WORKER_REF_ID INTEGER, BONUS AMOUNT INTEGER(10), BONUS_DATE DATETIME, FOREIGN KEY (WORKER_REF_ID) REFERENCES Worker (WORKER_ID) ON DELETE…
//stored procedure create or replace procedure firstthree (my_seqid in varchar2) as cursor c1 is select sname, grade from student s join taken t on s.sid=t.sid where seqid=my_seqid order by grade desc; -- my_sname varchar2(40); my_sname student.sname%TYPE; -- my_grade number(2,1); my_grade taken.grade%TYPE; begin /* clear the my_tmp table */ delete from my_tmp; commit; open c1; for i in 1..3 loop fetch c1 into my_sname, my_grade; exit when c1%notfound; /* in case the number requested */ /* is more than the total */ /* number of enrolled students */ /* display the result */ dbms_output.put_line('name: ' || my_sname || ' ' || 'grade: ' || my_grade); /* put into temporary table */ insert into my_tmp values(my_sname, my_grade); commit; end loop; close c1; end; / -------------- //php <? $connection = oci_connect ("test", "test", "test"); if ($connection == false){ $e = oci_error();…
9. Write a trigger that prohibits duplicate values except for nulls in the NoDupName column of the following table: CREATE TABLE TestUniqueNulls (RowID NoDupName varchar(20) int IDENTITY NOT NULL, NULL); (Note that you can’t do this by using a unique constraint because the constraint wouldn’t allow duplicate null values.) If an INSERT or UPDATE statement creates a duplicate value, roll back the statement and return an error message. Write a series of INSERT statements that tests that duplicate null values are allowed but duplicates of other values are not.