Midterm Key Spring 2009

Midterm Key Spring 2009 - NAME_KEY 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: _______________ KEY ________________________________________ 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:
Background image of page 1

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

View Full Document Right Arrow Icon
2 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. SOLUTION PROVIDED SEPARATELY. First customer is Aier at $330.94 – if it is wrong then student did not do the calculation correctly. Second customer is Baber at $45.53 – this one will determine if they grouped and summed. 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? Event 2. In a relational database designed according to the REA data model, information traditionally stored in accounting ledgers can be obtained by querying All of the above 3. Which type of processing produces temporary files where transactions are stored until
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.

{[ snackBarMessage ]}

Page1 / 7

Midterm Key Spring 2009 - NAME_KEY 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