KEY Midterm - Fall 2009

KEY Midterm - Fall 2009 - ACCT 361 Fall 2009 MIDTERM EXAM -...

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

View Full Document Right Arrow Icon
ACCT 361 – Fall 2009 MIDTERM EXAM - KEY 300 points Query Exercise (50 points) Query Output: Prepare a daily sales report. The solution would indicate that sales for 9/1 were $397.83. Multiple Choice Questions (30 points total at 5 points each) 1. Periodic updating of the data stored about resources and agents is batch processing 2. A well-structured database imposes several requirements on the structure of tables. The constraint that ensures the consistency of the database by requiring all foreign keys have the value of a primary key of another table or be null is known as the referential integrity rule 3. Characteristics of interest that need to be stored about a particular object are: attribute 4. A general journal is used to record infrequent or non-routine transactions. 5. Certain documents or forms are generated and/or processed with each business process. The issuing of a purchase order is part of which business process? Acquisition/Payment process 6. Using a file-oriented approach to data and information, data is maintained in many separate files
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Short Answers (45 points total at 15 points each) 1. Give an example of a query for which you would need to use an outer join instead of an inner join. Students can give various answers, as long as it is clear an outer join is required. The homework used three: to determine ending quantity on hand, inventory valuation, and reorder
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/05/2011 for the course ACCOUNTING 361 taught by Professor Anand during the Fall '09 term at George Mason.

Page1 / 6

KEY Midterm - Fall 2009 - ACCT 361 Fall 2009 MIDTERM EXAM -...

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

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