DISC 4372 FINAL SPRING 2010

Name_______________________________________ Student Number____________________________Database Name _______

e-mail address__________________________________________

1. (50 points) TO BE RETURNED BY 5:30 PM MON MAY 10 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
1300 4000 0000 0000  
2500 1000 0000 0000  
9000 4000 0000 0000  
9000 9000 0000 0000  
2600 1000 0000 0000  

1.3 Add the following accounts to the general ledger:

Major Minor Sub 1 Sub 2 Description Outcome
1100 0003 0000 0000 CD 3456-8766-1 12-21-2007  
2600 1000 0000 0000 Employee Insurance Withholding  
1000 5000 0000 0000 Cash Nashville  
9200 1000 0000 0000 Tax Preparation Expense  
4000 3000 4000 0000 Software Sales Revenue  
1000 5000 0000 0000 Cash -- Nashville Verbatim Bank  
1100 0004 0000 0000 AIG Stock  
3000 4000 0000 0000 Contributed Capital  
1700 3000 0000 0000 Computer Hardware  

1.4 Modify the following account descriptions:

Major Minor Sub 1 Sub 2 New Description Outcome
3000 4000 0000 0000 Contributed Capital  
1000 6000 0000 0000 Cash Idlewild Bank NJ  
4000 1000 1000 0000 Licensing Revenue  
9100 7000 0000 0000 ISP Expense  
9999 9999 0000 0000 Suspense Account  
4000 2000 0000 0000 Consulting Revenue  
1900 8000 0000 0000 Prepaid Taxes  
9000 4000 0000 0000 Insurance Expense  

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

SRN:  4411 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 4000 0000 0000 428.16 Risk Premium  
1000 5000 0000 0000 -428.16  
SRN:  4412 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
2600 1000 0000 0000 99.93 Paid Risk Premium 2009  
1000 2000 0000 0000 -99.93    
SRN:  4413 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -100000.87 Buy a CD  
1100 0003 0000 0000 100000.87    
SRN:  4414 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
3000 6000 0000 0000 -975.00 Write Off Suspense Account Amount  
9999 9999 0000 0000 975.00    
SRN:  4415 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 5000 0000 0000 1080.04 Sales Receipts Dec 2009  
4000 3000 1000 0000 -270.01    
4000 3000 2000 0000 -270.01    
4000 3000 3000 0000 -270.01    
4000 3000 4000 0000 -270.01    
SRN:  4416 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 7000 0000 0000 3455.29 Green Giant Energy  
1000 4000 0000 0000 -3455.29    
SRN:  4461 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 2000 0000 0000 -910.68 Paper Supplies  
9000 5000 0000 0000 910.68    
SRN:  4417 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -845.94 Federal Income Taxes  
2400 1000 0000 0000 -845.94    
SRN:  4418 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1100 7000 0000 0000 34661.00 Invest in Apple  
1000 1000 0000 0000 -34561.00  
SRN:  4419 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1700 3000 0000 0000 4456.22 Buy New Computers  
1000 1000 0000 0000 -2228.11    
1000 2000 0000 0000 -2228.10    
SRN:  4420 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 8000 0000 0000 430.00 Rent for Garbage Dumpster  
1000 1000 0000 0000 -430.00    
SRN:  4421 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 4000 0000 0000 8155.13 Consulting Revenue  
4000 2000 0000 0000 -8155.13    
SRN:  4422 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -10.01 Paper Clip Expense  
1000 2000 0000 0000 -10.02  
1000 3000 0000 0000 -10.03  
1000 4000 0000 0000 -10.04  
1000 5000 0000 0000 -10.05  
9000 5000 0000 0000 50.15    
SRN:  4461 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 223.18 Limo Lease  
9000 2000 0000 0000 -223.18    
SRN:  4423 Fiscal
Month		  5
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -143.38 Limo Gas  
9000 9000 0000 0000 143.38    

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 _________________.
  4. Are any Cash accounts overdrawn? If so, which ones:__________________________________ .

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.
BE SURE TO: SHOW THE REPORT TIME AND DATE.

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.

1.9 Print:

A copy of the je table after posting. Sort the table by sourceref ASC, srseq ASC. Show the number of journal entries AND the number of journal vouchers.

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

2. (50 points)TO BE RETURNED BY 5:30 PM MON MAY 10 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 2 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 two variations (color or size) of the third product in your catalog. Buy 1 of each of the variations. Thus, you buy a total of 2 units of the third product.
  6. Print another copy of the inventory master detail report after the three orders have been processed.
    Include in the report a grand total of the inventory on hand.
  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 5:30 PM MON MAY 10 to 280E MH:
  1. All 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. dump of the je table after posting
  4. a3.htm (the html/vbscript code to gather the journal voucher data)
  5. a3.asp (asp code to post journal vouchers to the glmaster)

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

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

Bind the pages so that they DO NOT fall apart.

Email me at parks@uh.edu if you have issues.