This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: NAME: _______________________________________________________________________ COMPUTER ID: _______________________________________________ ACCT 361 – Fall 2009 MIDTERM EXAM 300 points Query Exercise (50 points) The Pets-R-Us 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 Pets- R-Us 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 make sure I received your file and then come to your computer after receiving your file and remove it from your folder on your computer. Query Output: Prepare a daily sales report. That is, generate a query that provides the total revenue for each day the company was in operations. Please relabel the total revenue field to be “Total Daily Revenue” on your final output. Also sort the output to have the most recent day’s revenue occur first. 2 Multiple Choice Questions (30 points total at 5 points each) 1. Periodic updating of the data stored about resources and agents is a. online real-time processing. b. real-time processing c. batch processing d. data 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...
View Full Document
- Fall '09
- Accounting, Foreign key, Purchase order, purchase orders