Homework 4 (pdf). Due: 13 February (Thursday).
Deadline extended to 16 February (Sunday)
Create Statements for COMPANY DATABASE.
Insert Statements for COMPANY DATABASE.
Screen Capture Instructions for Assignment.
NOTE: In order for you to start using Oracle on tinman.cs.gsu.edu,
you must copy the file ~raj/.cshrc into your home directory.
After copying, logout and then login for the commands in the
file to be activated. On subsequent logins, the commands in
this file will execute automatically.
Homework Submission Directions: Copy ~raj/.cshrc into your home
directory one more time; logout and then login;
Then, you may use the handin command.
For this homework, you will submit 3 files electronically:
- hw41.sql (containing the modified create table script)
- hw42.sql (containing the modified insert statements script)
- hw43.sql (containing all queries for problems 3 and 4).
The command to submit is:
$ handin4710 4 hw41.sql hw42.sql hw43.sql
6710 students will use handin6710 instead. Here the number 4 is the assignment
number. You will use 5 for hw5, 6 for hw6 etc.
You will also submit a printout of hw41.sql and hw42.sql
(with changes highlighted). For hw43.sql, you will capture the screen
and submit a printout of the screen capture file.
Homework 4 Solutions
