anything-except-newline anything-except-*/ newline *1 end-of-input fo

What happens when a constraint is followed? Unique I Primary Key (ii), Default (iii), and Check (iv) Unique I Primary Key (ii), Default (iii), and Check (iv)

SQL code for:  Create a stored procedure “setRelocationFee” to set the relocation fee for a given employee. If the employee’s office is in San Francisco, the relocation fee is $10000; if the employee’s office is in Boston, the relocation fee is $8000; if the employee’s office is in London, the relocation fee is $20000; if the employee works in other offices, the relocation fee is $15000. Below is a sample statement to test your stored procedure. set @employeeID = 1501; call setRelocationFee(@employeeID, @relocationfee); select @employeeID, @relocationfee;   Having this database  CREATE TABLE `offices` (   `officeCode` varchar(10) NOT NULL,   `city` varchar(50) NOT NULL,   `phone` varchar(50) NOT NULL,   `addressLine1` varchar(50) NOT NULL,   `addressLine2` varchar(50) DEFAULT NULL,   `state` varchar(50) DEFAULT NULL,   `country` varchar(50) NOT NULL,   `postalCode` varchar(15) NOT NULL,   `territory` varchar(10) NOT NULL,   PRIMARY KEY (`officeCode`) ) ENGINE=InnoDB DEFAULT…

SQL DML/DDL There are five tables describing employees of a company, departments, buildings, which department(s) an employee works in (and a percentage of the time for each), and in which building an employee works (an employee may have more than one office). The primary key of each table is the attribute(s) in capitals and underlined. The foreign keys are in italics. Other attributes are not necessarily unique.Employee (EID, Ename, Salary, Start_Date, End_Date)Building (BID, Bname, Address)Department (DID, Dname, Annual_Budget)In_Department (EID, DID, Percentage_Time)In_Building (EID, BID)Write the SQL statements for the following.1. Find the names of Departments where NO employees work. 2. For employees who are still working in the company, end date has no value (empty). For those who have left the company and have end date values, show their names and the duration of their employment in years.  3. Find the names of buildings where more than 50 employees work.  4. The tables have…