Midterm Exam Spring 2009

Midterm Exam Spring 2009 - NAME: _ COMPUTER ID: _ ACCT 361...

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

View Full Document Right Arrow Icon
NAME: _______________________________________________________________________ COMPUTER ID: _______________________________________________ ACCT 361 – Spring 2009 MIDTERM EXAM 300 points Query Exercise (40 points) The Orioles Shop database has been sent to each of your computers. You will find it in the shared documents folder in your My Documents directory. You will have seven minutes at the beginning of class to develop a query that will generate the following output related to the Orioles Shop database. When you have completed the query, close the database. Resubmit the file to me. Once you have done this, then you can begin working on your written exam. You cannot return to your query, and you can only submit it once. I will come to your computer after receiving your file and remove it from your folder on your computer. Query Output: Prepare a customer profitability analysis sorted by customer last name. That is, generate a query that provides the total gross profit for each customer. Please relabel the total gross profit field to be “Customer Gross Profit” on your final output.
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 Multiple Choice Questions (35 points total at 5 points each) 1. Information traditionally found in accounting journals is stored in which type of entity in an REA database? a. Resource b. Event c. Agent d. All of the above 2. In a relational database designed according to the REA data model, information traditionally stored in accounting ledgers can be obtained by querying a. Resources b. Events c. Agents d. All of the above 3. Which type of processing produces temporary files where transactions are stored until processed? a. Batch processing b. Real-time processing c. Captured transaction processing d. Chart of accounts processing 4. Data sources and destinations (sinks) are represented in a data flow diagram as: a. A square b. A circle c. Two parallel lines d. One curved line 5. Resources in the REA enterprise ontology are defined as
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 / 8

Midterm Exam Spring 2009 - NAME: _ COMPUTER ID: _ ACCT 361...

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