I got a question on this problem. It says:Create a transaction inside a stored procedure to record a traffic stop – that includes code similar to what you wrote for #13. Pass the details about the traffic stop to the procedure through its parameters. Then call the procedure with a statement similar to this:CALL traffic_stop_transaction (“Jane”, “Jones”, “Waller”, “TX”, “VNR 971”, 1039, “2014-12-25”,”Speeding”)How do I create a transaction? CREATE TABLE OFFENSE (OFFENSE VARCHAR (30),FINE NUMERIC(7),CONSTRAINT OFFENSE PRIMARY KEY(OFFENSE));CREATE TABLE DRIVERS (LICENSE_NUMBER VARCHAR(30),DRIVER_FNAME VARCHAR(30) NOT NULL,DRIVER_LNAME VARCHAR (30) NOT NULL,DRIVER_CITY VARCHAR ( 30) NOT NULL,DRIVER_STATE VARCHAR (18) NOT NULL,CONSTRAINT PK_LICENSE_NUMBER PRIMARY KEY(LICENSE_NUMBER),CONSTRAINT UQ_DRIVER_FNAME UNIQUE KEY(DRIVER_FNAME),CONSTRAINT UQ_DRIVER_LNAME UNIQUE KEY(DRIVER_LNAME));CREATE TABLE TICKETS (TICKET_NUMBER NUMERIC(10) PRIMARY KEY,TICKET DATE DATE,LICENSE_NUMBER VARCHAR (30),OFFENSE VARCHAR (30),FOREIGN KEY (LICENSE_NUMBER) REFERENCES DRIVERS (LICENSE_NUMBER),FOREIGN KEY (OFFENSE) REFERENCES OFFENSE (OFFENSE)); LicenseDriver'sDriver'sTicketNumberDriverCityStateNumber Ticket DateOffenseFineМAА 823Elizabeth BlairHoustonTXHenry Newman Pearland12/3/2014 Failure to Stop12/3/2014 Parking12/6/2014 Speeding1023 12/20/2014 | ParkingGRE 720TX102230MVX 322Eva MillsWallerTX121115MVX 322Eva MillsWallerTX121265E. MillsStephen Sholes PearlandMVX 322WallerTX15ARG 595TX1024 12/21/2014 Speeding1025 12/21/2014 Red Light1027 12/22/2014 Parking1225 12/22/2014 Speeding1037 12/23/2014 Red LightRVX 287Rod BrooksBellaireTX65RVX 287Rod BrooksBellaireTX50TGY 832Luci SilvaSugarlandTX15КЕС 654Richard PenceHoustonTX65MVX 322E. MillsWallerTX50

Suppose the name of the relation in which you are these records is "traffic stop"…

Answered: I got a question on this problem. It…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

I got a question on this problem. It says:

Create a transaction inside a stored procedure to record a traffic stop – that includes code similar to what you wrote for #13. Pass the details about the traffic stop to the procedure through its parameters. Then call the procedure with a statement similar to this:
CALL traffic_stop_transaction (“Jane”, “Jones”, “Waller”, “TX”, “VNR 971”, 1039, “2014-12-25”,”Speeding”)

How do I create a transaction?