HW2 Queries -- Online Assistance

The database for HW2, Question 2 has been set up on the SQL server system in the PML. Instructions for accessing it are here.

For those of you with difficulty accessing that environment, the database has also been set up in Oracle. Instructions for accessing it are here.

If you'd like to set it up yourself, feel free to do so. A file containing the DDL statements to create the tables is here, and a file with the DML statements to insert the data is here. Note that the SQL standard is not as "standard" as one would like. Differences you may encounter include the semicolons (sometimes required, sometimes disallowed); different names for numeric types ("number" vs. "numeric" vs. ...); different default formats for numeric types (no. of decimal places allowed varies); and different default date formats.

The files mentioned above will work in some environments (e.g. Oracle and others). For SQL Server, Kevin Ibrahim has kindly made the required changes to the scripts to create and populate the database, so feel free to use these if you like.