BCS 360 Study Guide - Quiz Guide: Result Set

10 views2 pages

learn4life

20 Jun 2022

School

SUNY Farmingdale, FSC

Department

Computer Systems

Course

BCS 360

Professor

For unlimited access to Study Guides, a Grade+ subscription is required.

Document Summary

Lab 6: write a select statement that returns the same result set as this select statement. Substitute a subquery in a where clause for the inner join. Order by vendorname; select distinct vendorname from vendors where vendorid in (select vendorid from invoices) order by vendorname: write a select statement that answers this question: which invoices have a. Return the invoicenumber, invoicetotal and paymenttotal for each invoice select invoicenumber, invoicetotal, paymenttotal from invoices where invoicetotal > (select avg(invoicetotal) from invoices where invoicetotal <> 0: write a select statement that returns four columns: vendorname, invoiceid, Invoicesequence, and invoicelineitemamount for each invoice that has more than one line item in the invoicelineitems table. Hint: use a subquery that tests for invoicesequence > 1. select vendorname, invoicelineitems. invoiceid, invoicesequence, invoicelineitemamount from invoices join vendors on vendors. vendorid = invoices. vendorid join invoicelineitems on invoices. invoiceid = invoicelineitems. invoiceid where (select count(invoicesequence) from invoicelineitems where invoices. invoiceid = Invoicelineitems. invoiceid) > 1: write a select statement that returns three columns: invoiceid, vendorid,

Related Questions

Use Case Name

Update Sale Invoice by adding more products

Triggering Event

Customer would like to change what they would like to buy.

Brief Description

Allows the Owner to change a sale invoice.

Actors

School Owner

Related Use Cases

Preconditions

Owner is logged into the system and the sale menu is displayed.

Post Conditions

Update sale is saved to the database and now can be printed or emailed as a receipt for the customer.

Flow of activities

Actor

System

Requests to search a sale invoice.

Prompts for search by customer’s phone number.

Enters customer’s phone number.

Displays the sale invoices associated with the entered phone number, as well as the customer’s name.

Selects one sale invoice.

Displays all the details in the invoice, including customer’s name and address, the invoice number, the invoice date, and all the products added into the sales invoice and the quantity and price for each product.

Request to add more products.

Displays a list of products.

Select one product and enter the quantity to buy.

Adds the product and its quantity to the sale invoice.

Repeats step5 until all products have been added.

Prompts to save.

Confirms to save.

Saves the sale invoice and details

please create class diagram ad sequence diagram

unofish

Write a C++ program that will prompt the user for quantity of items bought and the unit price and print the Invoice. The program should be such that:
a. The user can enter a tax percent.
b. A 5% discount is deducted before the vat calculation if the customer is buy items worth
GHc 500.
c. A 10% discount is deducted before the vat calculation if the customer is buy items worth
GHc 1000.
d. A 15% discount is deducted before the vat calculation if the customer is buy items worth
GHc 1500.
e. The quantity of items is printed.
f. The unit price is printed.
g. The price with tax excluded is printed.
h. The total amount payable by the customer is printed.
i. The vat amount is printed.
j. The discount amount is printed.