Steps to create a database:

1. Log into roger.
2. Create a SQL batch file (createdb) with the following code:

   cs898n
   abc123
   CREATE TABLE Pal (
     firstname CHAR(15),
     lastname  CHAR(20),
     city      CHAR(15),
     state     CHAR(2),
     age       INTEGER
   );
   INSERT INTO Pal VALUES (
     'Mike',
     'Nichols',
     'Tampa',
     'FL',
     19
   );
   INSERT INTO Pal VALUES (
     'John',
     'Wayne',
     'Tampa',
     'FL',
     20
   );
   

3. Run psql -u cs898n < createdb
4. To drop a table, you can use the following SQL batch file (droptable) and run psql -u cs898n < droptable.

   cs898n
   abc123
   drop table Pal;
   

5. For the Oracel database users, log into tinman and run those batch files without first two lines in this way:
   sqlplus username/password < createdb.