Journal Wednesday March 12th, 2008

Q1- Your task is to encrypt all sensitive data (security, privacy) in your database and get rid of the original data (delete files or fields ). -The key for running the encryption is "the quick brown fox jumps over the lazy dog". program is not case sensitive, deal with special characters and numbers in your own creative way. To test your program decrypt the data to get to original database. The test data input is HELLO and the encrypted output you should get is PTFFB. Hint, you may want to use an other key for numbers and special characters.(40 points)

"the quick brown fox jumps over the lazy dog"
 abcdefghijklmnopqrstuvwxyz, skip letters that are repeated such as "o", "e"

Q2- You are to design a database from scratch using any file access and memory access mode (sequential, random, array, object, etc.) Be unique and creative. You may want to use C++ or any programming language you are familiar with. show your data file and queries.(30 points)

Q3- you are to design a database using access, DB2, Oracle, etc. Use your own SQL query to access the similar data as in question two. (30 points)