Write SQL code for (see image for the table structure):Create a stored procedure “changeCreditLimit” to change the credit limit for a given customer. If the customer’s total payment amount (note: payment amount is in the table “payments”) is not smaller than a given amount, then add 2000 to the customer’s credit limit (note: credit limit is in the table “customers”). CREATE TABLE `payments (`customerNumber' int(11) NOT NULL,'checkNumber' varchar(50) NOT NULL,'paymentDate` date NOT NULL,`amount` double NOT NULL,PRIMARY KEY (`customerNumber`, `checkNumber'),CONSTRAINT `payments ibfk 1 FOREIGN KEY (`customerNumber') REFERENCES 'customers' ('customerNumber')) ENGINE=InnoDB DEFAULT CHARSET=latin1;CREATE TABLE `customers' (`customerNumber' int(11) NOT NULL,'customerName` varchar(50) NOT NULL,'contactLastName` varchar(50) NOT NULL,'contactFirstName` varchar(50) NOT NULL,'phone varchar(50) NOT NULL,addressLine1 varchar(50) NOT NULL,`addressLine2` varchar(50) DEFAULT NULL,city' varchar(50) NOT NULL,state varchar(50) DEFAULT NULL,`postal Code varchar(15) DEFAULT NULL,'country` varchar(50) NOT NULL,'salesRepEmployee Number' int(11) DEFAULT NULL,`creditLimit' double DEFAULT NULL,PRIMARY KEY (`customerNumber"),KEY 'sales RepEmployeeNumber` (`salesRepEmployeeNumber"),CONSTRAINT customers ibfk 1 FOREIGN KEY (`salesRepEmployeeNumber") REFERENCES employees'('employeeNumber')) ENGINE=InnoDB DEFAULT CHARSET=latin1;

The solution is an given below :

Answered: SQL code for (see image for the table…

Computer Networking: A Top-Down Approach (7th Edition)

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...

See similar textbooks

Related questions

Question

Write SQL code for (see image for the table structure):

Create a stored procedure “changeCreditLimit” to change the credit limit for a given
customer. If the customer’s total payment amount (note: payment amount is in the
table “payments”) is not smaller than a given amount, then add 2000 to the customer’s
credit limit (note: credit limit is in the table “customers”).