CSC343H Summer 2003.
Assignment #2
Due Monday, July 7th,
2003, 9:00pm
This assignment is given in two parts:
The first part is an archive file
containing these files:
- create.sql which contains the DDL intructions to create four
relations
- import.sql among players.txt, teams,txt, franchise.txt,
salaries.txt contain the DDL intructions and tuples to populates
these relations.
- drop.sql which contains the DDL intructions to drop the relations
- readme.txt which explain the meaning of the different fields for
each relations.
You will have to create and populate your databse using these file
(db2 -f create.sql; db2 -f import.sql) and then answer the assignment.
- Where do I find the assignment: Assignment2.pdf
- Where do I find the archive file: Archive
file
- How do I uncompress/untar the archive: tar -xvzf assignment.tar.gz
- How do I tar/compress my archive: tar czvf
a2_<studentid>.tar.gz query01.sql query02.sql ... query18.sql
- Why Should I populate my database as soon as possible: Because we
have some concerns about the space disk availability. Therefore we will
apreciate to solve problems related to this archive as soon as possible
and not the last week-end