DISC 4372 FINAL SPRING 1998 v1

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.

1.1 Add the following accounts to the general ledger:

MajorMinorSub 1Sub 2
1000400000000000
1000500000000000
1000600000000000
1000700000000000

1.2 Delete the following accounts from the general ledger:

MajorMinorSub 1Sub 2
1900900000000000
9100100000000000

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

SRN: 7111Fiscal
Month
 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.00 
25001000000000007.00 
SRN: 7112Fiscal
Month
 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.00 
24001000000000007.00 
SRN: 7113Fiscal
Month
 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.00 
91001000000000007.00 
SRN: 7114Fiscal
Month
 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-75.00 
999999990000000075.00 
SRN: 7115Fiscal
Month
 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000100.00 
4000300010000000-20.00 
4000300020000000-20.00 
4000300030000000-20.00 
4000100000000000-20.00 
4000200000000000-20.00 
SRN: 7116Fiscal
Month
 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-100.00 
500010001000000025.00 
600010001000000025.00 
700010001000000025.00 
800010001000000025.00 
SRN: 7117Fiscal
Month
 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.00 
90005000000000007.00 
SRN: 7118Fiscal
Month
 9
MajorMinorSub 1Sub 2AmountDescription
9999999900000000-7.00 
40004000000000007.00 

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

Part 2

2.1 FTP your a44.asp to the local drive. Save it as a55.asp. Modify the program so that the query produced is a balance sheet. The report should be:


REVENUE:

.
.(show all accounts with first digit of major = 4 AND have a NON-ZERO BALANCE)
.

TOTAL REVENUE x-------x (this is the sum of the revenue balances above)

EXPENSES:
.
(show all accounts with first digit of major = 5,6,7,8 or 9 AND have a NON-ZERO BALANCE)
.

NET INCOME x---------x (this is the difference in Revenues and Expenses above)


Save this a55.asp locally. FTP it back to the server. Add a "INCOME STATEMENT" link to the assignments homepage that runs the a55.asp you just wrote.

Print your (1) a3.htm (2) a3.asp (the posting active server page that processes transactions) and (3) your new a55.asp. Put your name, SSN, Database Acct on each page. Turn these in.

When finished contact Parks.