Due Date: March 1, 2000

(1)    Based on homework #4, write a Perl program, h5populatedb.pl, to populate an Access database using the terms and definitions in the area of mortgage using ODBC.  The ODBC DSN is your account name, which will link to the Access file db.dbm in your db directory of your account.

(2)    Write a CGI-Perl program that allows users to search the database using keywords or to list terms with a given first character.  You may or may not use the HTML element functions of CGI-Perl (i.e. p, br, table, etc)  The initial screen should look like:

http://lattes.uhcl.edu/accountname/h5search.pl

If Q is selected, the screen should look like:

http://lattes.uhcl.edu/accountname/h5search.pl?firstchar=q

If the keyword "long term" is entered:

Your program should produce output as close to the screens above as possible.  Turn in your program listing, screen shots and your url.