class6 - 33:010:458 33:010:458 Accounting Information...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 33:010:458 33:010:458 Accounting Information Accounting Information Systems Systems r. Peter R. Gillett Dr. Peter R. Gillett Associate Professor Department of Accounting, Business Ethics and Information Systems Rutgers Business SchoolNewark and New Brunswick Accounting Information Systems A.I.S. Class 6: Outline A.I.S. Class 6: Outline Group Projects Group Work Flowcharting Learning Objectives for Chapter 7 Systems Analysis and Design usiness Transactions September 21, 2009 Dr. Peter R. Gillett 2 Business Transactions September 21, 2009 Dr. Peter R. Gillett 2 Accounting Information Systems Group Projects Group Projects Stage Date Grade 1 9 / 2 1 5 2 1 / 5 5 3 10/19 50 1/2 4 11/2 50 5 11/16 50 1/30 6 11/30 50 nal 2/9 September 21, 2009 Dr. Peter R. Gillett 3 Final 12/9 50 September 21, 2009 Dr. Peter R. Gillett 3 Accounting Information Systems Group Work Group Work Chapter 6 Problems 2, 5, 6, 7 Narrative and flowcharts in the Chapter 1 ppendix for manual Purchases Appendix for manual Purchases September 21, 2009 Dr. Peter R. Gillett 4 September 21, 2009 Dr. Peter R. Gillett 4 Accounting Information Systems Group Work Group Work - Chapter 6 Problem 6 Chapter 6 Problem 6 Murthy & Groomers Solution: a) List the salesperson name and salary for all sales to customers whose balance outstanding is greater than 20000. SELECT SALESPERSONS.S-NAME, SALESPERSONS.SALARY FROM SALESPERSONS, CUSTOMERS, SALES WHERE CUSTOMERS.CUST-NO = SALES.CUST-NO AND SALESPERSONS.SP-NO = SALES.SP-NO AND CUSTOMERS.BALANCE > 20000; b) List the names and addresses of all customers who have been sold merchandise by salespersons employed before 1/1/96. SELECT CUSTOMERS.C-NAME, CUSTOMERS.C-ADDRESS FROM CUSTOMERS, SALESPERSONS, SALES WHERE CUSTOMERS.CUST-NO = SALES.CUST-NO AND SALESPERSONS.SP-NO = SALES.SP-NO ND SALESPERSONS.DATE- MPLOYED < #1/1/96#; September 21, 2009 Dr. Peter R. Gillett 5 AND SALESPERSONS.DATE EMPLOYED < #1/1/96#; September 21, 2009 Dr. Peter R. Gillett 5 Accounting Information Systems Group Work Group Work - Chapter 6 Problem 7 Chapter 6 Problem 7 Murthy & Groomers Solution: a) List the invoice number, item number, item description and selling price on all invoices by salesperson "John Doe." SELECT INVOICES.INVOICE-NO, ITEMS-SOLD.ITEM-NO, INVENTORY.DESCRIPTION, ITEMS-SOLD.SELLING PRICE FROM INVOICES, ITEMS-SOLD, INVENTORY WHERE INVOICES.INVOICE-NO = ITEMS-SOLD.INVOICE-NO AND ITEMS-SOLD.ITEM-NO = INVENTORY.ITEM-NO AND INVOICES.SALESPERSON = "John Doe"; b) List the customer names, invoice numbers, and invoice dates for all invoices where the quantity sold exceeded 100. ELECT CUSTOMERS NAME INVOICES INVOICE O INVOICES DATE FROM SELECT CUSTOMERS.NAME, INVOICES.INVOICE-NO, INVOICES.DATE FROM CUSTOMERS, INVOICES, ITEMS-SOLD WHERE CUSTOMERS.CUSTOMER-NO = INVOICES.CUSTOMER-NO AND INVOICES.INVOICE-NO = ITEMS-SOLD.INVOICE-NO AND ITEMS-SOLD.QUANTITY-SOLD > 100; September 21, 2009 Dr. Peter R. Gillett 6 September 21, 2009 Dr. Peter R. Gillett 6 Accounting Information Systems...
View Full Document

This note was uploaded on 03/19/2010 for the course ACCT 458 taught by Professor Gillett during the Fall '09 term at Rutgers.

Page1 / 34

class6 - 33:010:458 33:010:458 Accounting Information...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online