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 XML Schemas.
proc.xml
and
inproc.xml
are here and Saxon is
here
.
Answers
.
Midterm solutions
.
Project detailed specifications
and
Tomcat
server documentation.
Assignment 5
: Data integration, with schemas
here
and
here
.
Answers
.
Assignment 6
: Indexing: B+-Trees and SQL indexing; query optimization
Answers
.