CS422 HW4

Homework 4
CS422, Fall 2012

Due: Thursday, November 15

Please upload the source code files to CSNS. Note that file uploading will be disabled automatically after 11:59PM of the due date, so please turn in your work on time.

Set up SimpleDB project under Eclipse as described in the lecture notes.

1. (40pt) Modify SimpleDB to allow queries like "select * from tbl where col=1" - in other words, to allow the use of * as a shorthand for selecting "all columns".

For this exercise, please submit only the Java source files that you added or modified.

2. (40pt) Create a Java program ShowTables to display the information of the tables in a SimpleDB database. Specifically:

ShowTables takes the name of the database as an optional command line argument. When no argument is given, the database name is StudentDB.
ShowTables outputs the names of the tables in the database, and for each table, the name and the type of each column in the table.

In the program you may import any SimpleDB class and/or use SimpleDB code to create your own classes, but for this exercise you may not change existing SimpleDB classes.