DISC 4372 FINAL SPRING 1999

Name___________________________ Exam Number_____________

SS#____________________________

Database Name _______

Homepage URL_______________________________

Time of Exam Start__________________________

Part 1 of 2 (50 points)

Run glrestor.htm 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 update (i.e, worked ok or failed).

1.1 Add the following accounts to the general ledger:

MajorMinorSub 1Sub 2Description
1000400000000000Cash NY Office
1000500000000000Cash CA Office
1000600000000000Cash FL Office
1000700000000000Cash WV Office
1000700000000000Cash AZ Office

1.2 Delete the following accounts from the general ledger:

MajorMinorSub 1Sub 2
1800200000000000
9000300000000000
1000700000000000

1.3 Modify the following account descriptions:

MajorMinorSub 1Sub 2New Description
1000400000000000Cash New York
1000500000000000Cash California
1000600000000000Cash Florida

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

SRN: 4111Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-700.22Texas Sales Tax
2500100000000000700.22 
SRN: 4112Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-5432.20Federal Taxes
24001000000000005432.20 
SRN: 4113Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.11 
91001000000000007.11 
SRN: 4114Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-5.60 
99999999000000005.60 
SRN: 4115Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000100.00 
100020000000000020.00 
100030000000000020.00 
100050000000000020.00 
100060000000000020.00 
4300300030000000-180.00 
SRN: 4119Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-100.00 
1000200000000000-20.00 
1000400000000000-20.00 
1000500000000000-20.00 
1000600000000000-20.00 
5000100010000000180.00 
SRN: 4116Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-100.04 
500010001000000025.01 
600010001000000025.01 
700010001000000025.01 
800010001000000025.01 
SRN: 4117Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-37.02 
900050000000000037.20 
SRN: 4118Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
9999999900000000-72.03 
400040000000000072.03 

When finished, bring up your trial balance (a44.asp) and notify Parks you are ready to have Part One graded.

PART 2 of 2 (50 points)

Create a new table called "updatelog". This table will record every transaction that applies to glmaster. The table structure stores the full gl account number, and transaction amount. There are two additional fields: one is a 12 character "transactionaction" field that stores one of the words: "ADD","MODIFY","DELETE", and "UPDATE" and the second field that is a 24 character field called "updatetime" which will contain the date/time value. For a41.asp, a42.asp, a43.asp and a3.asp, modify each fo the four programs to write a record to the "updatelog" table for each correct modification of glmaster. Do not include transaction that faiul to update correctly. The field "transactionaction" will contain "ADD" for all a41.asp transactions, "MODIFY" for all a42.asp transactions, "DELETE" for all a43.asp transactions and "UPDATE" for all a3.asp transactions.

Use the VBSCript verb "now" to retrieve the current data/time. For example,

fred=now

places the current date/time into fred. Use this verb in every "updatelog" insert for the value of "updatetime". For a41.asp, a42.asp and a43.asp transactions, use 0.00 in the transaction amount field.

Restore your glmaster using glrestore. Re-enter all the transactions above. Show the contents of "updatelog" to Parks when done.

Print:

  1. a3.htm
  2. a3.asp (the posting active server page that processes transactions), and
  3. your part two asp.

Put your name, SSN, Database Acct # on each page.
Be ready to turn these in.

When finished contact Parks.