{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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.
Image of page 1

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

View Full Document Right 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
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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern