Exams and Assignments:

There will be two exams in this course: a midterm and a final. There will be three assignments. Remote login access is required for the assignments.

Grading scheme:

Assignments Description:

Please visit blackboard.usc.edu for details

Homework 1

Use the Extended ER and Object Relational concepts to create a conceptual schema for a provided example application. Use your schema to build a sample database in Oracle. Write the given queries in SQL3 and execute them on your database.

Homework 2

Extend your schema of Homework 1 to support spatial datatypes. Use the new schema to build a database in Oracle. Write a GUI program that supports Graphical Query Language (GQL). The program must allow the users to select spatial attributes for spatial queries (e.g. selection from a map). The GQL must then parse these into SQL queries, which will be passed to your database.

Homework 3

Extend the schema from Homework 1 to XML. Create a DTD specification for the same. Write a custom XSL stylesheet (details will be provided). Write an XML parser module that reads the XML data and automatically populates your database (a sort of XML->SQL conversion). Write XML Queries using an XML Query Language (e.g., X-Query) to query the XML data.

Exam schedules: