1 Exercise 1. Given the Sales' database which contains the following 5 tables. Client(ClientID, ClientName, Gender, City, Birthdate, Telephone) Employee(Employeeld, Employee FName, EmployeeLName, Gender, Salary, Commission, HireDate) Item(ItemID Description, Price) Invoice(InvoicelD, InvoiceDate, ClientID*, EmployeeID InvoiceDetail InvoicelD*, ItemID* Quantity) Q2). Write a function that accepts an invoice ID, an item ID, and the sales price as parameters. The function must calculate and return the total amount of this item in this invoice, which can be calculated by multiplying the selling price by the quantity. Q3). Write a procedure that accepts the invoice id (YY), the item id (XX), and the total amount of an item (ZZZZ) as a parameter. The procedure should display a message "The item id XX in the invoice whose number is YY has a total amount of ZZZZ.". Q4). liont came in and wants to be an 1 Exercise 1. Given the Sales' database which contains the following 5 tables. Client(ClientID, ClientName, Gender, City, Birthdate, Telephone) Employee(Employeeld, Employee FName, EmployeeLName, Gender, Salary, Commission, HireDate) Item(ItemID Description, Price) Invoice(InvoicelD, InvoiceDate, ClientID*, EmployeeID InvoiceDetail InvoicelD*, ItemID* Quantity) Q2). Write a function that accepts an invoice ID, an item ID, and the sales price as parameters. The function must calculate and return the total amount of this item in this invoice, which can be calculated by multiplying the selling price by the quantity. Q3). Write a procedure that accepts the invoice id (YY), the item id (XX), and the total amount of an item (ZZZZ) as a parameter. The procedure should display a message "The item id XX in the invoice whose number is YY has a total amount of ZZZZ.". Q4). liont came in and wants to be an