Answered step by step
Verified Expert Solution
Question
1 Approved Answer
. 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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started