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.