DISC 4372 FINAL SPRING 2008

Name_______________________________________ Student Number____________________________Database Name _______

e-mail address__________________________________________

1. (50 points) TO BE RETURNED BY 5PM FRI MAY 2 TO 280E MH

1.1 Run your glrestor program on your database to restore it to its original status. On all the add/modify/delete's and journal vouchers below, write the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why if it failed.

1.2 Delete the following accounts from the general ledger:

Major Minor Sub 1 Sub 2 Outcome
1700 2000 0000 0000  
2600 1000 0000 0000  
4000 3000 4000 0000  
9100 1000 0000 0000  
1000 5000 0000 0000  

1.3 Add the following accounts to the general ledger:

Major Minor Sub 1 Sub 2 Description Outcome
1000 5000 0000 0000 Cash Santa Barbara California -- The Pink Dweeb Bank  
4000 3000 4000 0000 West Coast Revenue  
1000 5000 0000 0000 Cash Palo Alto Office -- Oracle Bank  
9000 4000 0000 0000 Insurance Expense  
4000 3000 5000 0000 China Operations Revenue  
1000 6000 0000 0000 Cash -- Payroll Account -- The Pink Dweeb Bank  
1100 0003 0000 0000 Microsoft Stock  
3000 4000 0000 0000 Capital Cash Contributions  
9000 3000 1000 0000 Forbe's Magazine Subscription  

1.4 Modify the following account descriptions:

Major Minor Sub 1 Sub 2 New Description Outcome
3000 4000 0000 0000 Capital Contributions  
1000 5000 0000 0000 Cash -- The Pink Dweeb Bank  
1700 1000 0000 0000 Furniture  
9100 1000 0000 0000 Office Lease Expenses -- All Locations  
9999 9999 0000 0000 Suspense  
4000 1000 0000 0000 Software Royalties  
2700 0000 0000 0000 Under-the-table Payoff Expenses  

1.5 Using your transaction system post the following journal vouchers to your general ledger system:

SRN:  3411 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 6000 0000 0000 1348.31  
1000 5000 0000 0000 -1348.31 West Coast Communications Expenses  
SRN:  3412 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 4000 0000 0000 238.91 Auto Insurance 2008  
1000 5000 0000 0000 -238.91    
SRN:  3413 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
5000 1000 1000 0000 2234.57 Part Time Sales Staff  
1000 2000 0000 0000 -2234.57    
SRN:  3414 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
3000 6000 0000 0000 -975.01 Clear Suspense Account  
9999 9999 0000 0000 975.01    
SRN:  3415 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 884.50 Sales Receipts December 2006  
4000 3000 4000 0000 -800.10    
4000 3000 5000 0000 -10.10    
4000 3000 3000 0000 -74.40    
SRN:  3416 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 7000 0000 0000 2560.28 Santa Barbara Wind and Gerbil Power  
1000 1000 0000 0000 -2560.28    
SRN:  3416 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 5000 0000 0000 -910.38 Remote Charges  
9000 2000 0000 0000 910.38    
SRN:  3417 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 4000 0000 0000 -1200.99 Taxes  
2400 1000 0000 0000 600.01    
2400 5000 0000 0000 600.98    
SRN:  3418 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
1100 0003 0000 0000 144065.04 Invest in Microsoft  
1000 1000 0000 0000 -144065.04  
SRN:  3419 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
9999 9999 0000 0000 -0.01 suspense fix  
3000 6000 0000 0000 0.01    
SRN:  3420 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
2600 1000 0000 0000 600.00 Insurance  
1000 5000 0000 0000 -600.00    
SRN:  3421 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 6000 0000 0000 6600.00 Found Buried Treasure  
1000 5000 0000 0000 -6600.00    
SRN:  3422 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 0600 0000 0000 643.00 Santa Barabara Earthquake Insurance  
900 4000 0000 0000 -643.00    
SRN:  3423 Fiscal
Month		  12
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 7643.28 Santa Barabara Starbucks Bill  
9000 5000 0000 0000 -7643.27    

1.6 Fill in the answers to the following questions (after completing sections 1.1, 1.2, 1.3, 1.4, and 1.5 above):

  1. The glmaster balance is $______________.
  2. The number of accounts in the glmaster table _______________.
  3. The number of rows in the je table is _________________.

1.7 Print a copy of your a44.asp trial balance output after you have completed posting the transactions above.

BE SURE TO: ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER.
BE SURE TO: SHOW THE OVERALL glmaster BALANCE.
BE SURE TO: SHOW THE NUMBER OF ACCOUNTS IN THE glmaster TABLE.

1.8 Print:

  1. a3.htm (the source code for the client side program that gathers the journal voucher data)
  2. a3.asp (the posting active server page that processes transactions)

These two items may be in one asp. If so, please note this on your printout.

Put your name, Student Number, Database Acct # on each page.

2. (50 points)TO BE RETURNED BY 5PM FRI MAY 2 TO 280E MH

Using your electronic web store program:

  1. Run your equivalent of glrestore program on your store's inventory master to restore it to its original state.
  2. Print a copy of the output of the program that shows the detailed contents of the inventory-master immediately after restoration.

    Include in the report a grand total of the inventory on hand.

  3. Make a purchase of the first product in your catalog of 4 units (any color or size).
  4. Make a purchase of the second product listed in your catalog. Buy 2 of this item (any color or size).
  5. Choose three separate variations of the third product in your catalog. Buy a total of 4 units on the same order (i.e., same product but three different variations of either size or color -- total quantity is 4)
  6. Print another copy of the inventory master detail report after the three orders have been processed.
  7. Print a copy of the asp program that posts the order to the inventory master.

Put your name, Student Number, Database Acct # on each page.

In summary, turn in by 5PM FRI MAY 2 to 280E MH:
  1. Exam pages with Name, Student Number, gl account, and email and outcomes of the posting entries.
  2. output of a44.asp trial balance after posting
  3. a3.htm(l) (the html/vbscript code to gather the journal voucher data)
  4. a3.asp (asp code to post journal vouchers to the glmaster)

    Note (3) and (4) may be one program

  5. output of the contents of the inventory master table contents before posting
  6. output of the contents of the inventory master table after posting
  7. copy of the asp program that posts orders to the inventory master

Bind the pages so that they DO NOT fall apart.