CIS 550 Course Assignments
The homework assignments will be roughly as follows:
Assignment 1
: relational algebra and calculus.
Answers
.
Assignment 2
: SQL in Oracle. You will need to
sign up
for an Oracle account and you'll need the following
script
to create some sample tables.
Answers
.
Assignment 3
: Database design: ER diagrams and normalization.
Answers
.
Assignment 4
: XQuery and DTDs in Galax.
Answers
.
Assignment 5
: Data integration.
Answers
.
Assignment 6
: Indexing: B+-Trees and SQL indexing.
Answers
.
Assignment 7
: Query optimization.
Answers
.