In class exercises

1. You have a database set up called "z012345bd". Set a password (NOT your main biolinx password--maybe just your first name) using the command SET PASSWORD=PASSWORD('whatever');

2. Convert the /home/bios546/ amino2.txt file to a file where all comment lines have been removed and the fields are separated by commas instead of whitespace.

3. Make a table in your database to hold the data in the amino2.txt version you just created and put that data into it, using a Perl script.

3. Set up a Perl script to generate a list of the amino acid names, symbols and molecular weights for those amino acids whose molecular weight is more than 120, using the table you created above.