1. Consider the following relational schema: Employee (EmpNo, EmpName, Salary, EmpPhone, EmpCommRate, ManagerId*) Order (OrdNo, OrdDate, OrdName, EmpNo*) OrdLine (OrdNo*, ProNo*, Quantity) Product (ProNo, ProName, ProPrice, ProQuantityOn Hand) 3 Create a procedure to compute the commission amount for a given order number. The procedure takes order number as input parameter. Inside the procedure you have to calculate the commission amount. The commission amount is the commission rate of the employee taking the order times the amount of the order. The amount of an order is the sum of the product of the quantity of a product ordered times the product price. The procedure should have to display the commission amount as output.