Note: Paradox is set so you cannot create a new database. Use MySql monitor to create two tables for your default database- you have two databases by default, one called
information_schema, leave that one alone and another which should be the same as your user account - that describes the relationship
between departments and employees. It should be a one to many relationship. The Employee table
should have the fields:lname, fname, age, date_hired, and gender. The department table should have
dname, room, budget. Add three rows of sample data to each table.

After completing the database tables do the following for submitting the homework:
1) If you are using Telnet or other appropriate connection software type script homework.txt
Here is a link on using script: http://myweb.stedwards.edu/laurab/help/scripthelp.html

This will start a program that will capture all information on the screen and save it to the named 
textfile. Make sure you have your database selected and type:

SHOW TABLES;
DESC TABLENAME1; (TABLENAME1 is the name you gave to table1)
DESC TABLENAME2; (TABLENAME2 is the name you gave to table2)
SELECT * FROM TABLENAME1;
SELECT * FROM TABLENAME2
EXIT ( This should stop the script program from saving any more data)

Copy your homework.txt file and link it to your web page and label it MysqlHomework.

Note:
There already is a database created for you with the name of your account.
You may not be able to create new databases-that may be restricted.
You can seethe databases by using the command SHOW DATABASES;
The USE DATABASENAME; command will choose which database you are working with.
The SELECT DATABASE(); command will show you which database is currently selected.
Also, this homework may require some research. For example, how do you make a column a primary key?
Should any columns be designated not null. Use the mysql manual and any other resources.