Question: . 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,

 . Exercise 1. Given the Sales' database which contains the following

. 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) InvoiceInvoicelD, InvoiceDate, ClientID", EmployeelD 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). Suppose a client came in and wants to know the total amount of an item in an invoice, so he gave 410 as an item id and 1A as an invoice id. Write the code needed to complete the requested task by calling the functions and procedure written in the previous questions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!