Spring 2012: CMSC424: Database Design: Assignments
Piazza Class Forum
Programming Assignment:
Description Due April 24, 2012;
ToyRDBMS Code Updated Query.java
Hints in Oracle
Test Queries
Homeworks:
Homework 1 Latex File
Homework 1 Solutions
Homework 2
Homework 2 Solutions
Homework 3
Homework 3 Solutions
Homework 4
Homework 4 Solutions
SQL Assignment:
This assignment is to be done individually.
There are two parts to this assignment. First one is Due February 17 (the answers will be provided that day),
and the second one is Due February 24.
SQL Part 1 Answers
SQL Part 2 Answers
Download all the assignment parts as a zip file: Zip.
There are three files:
---- populate.sql: a file that will populate the database,
---- sql_assignment_part_1.txt and sql_assignment_part_2.txt: files that contain the two parts of the assignment.
You must submit the answers to the assignment by filling in those two files (the files should be self-explanatory; also
see the video linked below).
There are (at least) two ways you can use the Oracle database.
SQL*PLUS on Glue Machines:
To start with, log into glue.umd.edu, run "tap oraclient", followed by "sqlplus" (SID: dbclass2, user/password provided in class).
To populate the dataset, use:
@ populate.sql
And try some simple queries:
e.g. select * from states;
Using ORACLE SQL Developer:
This option may be preferable since SQL Developer is a graphical client with much richer interface. Download
the Oracle SQL Developer from Oracle directly.
The video linked below shows how to get started with this tool.
Some initialization information in case you don't want to go over the video:
-- server: ginger.umd.edu
-- port: 1521
-- SID: dbclass2
Submission: Assignment submission will be using submit server. Only the .txt file must be submitted for each part (see the screencast below) -- do not
create a zip archive or any other format (like .docx).
Screencast: You may want to see this (short) video that illustrates how to use the above tools, especially
if you have never used a database before.
Web Project:
Project Description