Submitting the Schema and Data of Phase I

Due October 17, 2003

You need to submit the schema and data of your domain (Inventory, Billing, or Shipping) for Phase I in an XML file, formatted as explained below. Please read the requirements for the rest of Phase I which will be due October 24th. Good design now will make the rest of Phase I (and the entire Project) much easier later.

Example - Students Database

Suppose you have the following schema for a students domain is as below.

Students(ID, Name)
Signup(StudentID, ClassSignedUp)
Classes(Code, Instructor)

where:

• The first word is the table name and the attribute names are within the "()"s,
• The attributes ID, StudentID are of type integer,
• The attributes name, ClassSignUp, Code and Instructor are of type string.
• There is a foreign key from the attribute StudentID in table Signup to the attribute ID in the table Students, and from the attribute ClassSignUp in table Signup to the attribute Code in table Classes.

The format for specifying such a schema with some example data is shown here.

Turnin Procedure

1. Send your xml file as an attachement, named as your name and hw1 so we can identify you. For example, my file would be tessa_macduff_hw1.xml.
2. Make sure your xml file is well-formed. Check it by viewing it with a browser.