SET-A 1. Create table `mobileModel` and `prepaid` as per following Table Instance Chart. Restrict deletion of data in mobileModel table if modelid exists in the prepaid (½+½=1) `mobileModel` table Column Name modelId modelName Key Type Primary …
Chapter-12.1 PROBLEM 1 Create customer table — (a) Customer Table DROP TABLE IF EXISTS `customer`; CREATE TABLE `customer`( `CUSTNUMB` INT PRIMARY KEY, `CUSTNAME` VARCHAR(35), `ADDRESS` VARCHAR(100), `BALANCE` DECIMAL(8,2), `CREDLIM` INT, `SLSRNUMB` INT )ENGINE=INNODB; — adding data for customer table INSERT …