Out: 24 September 2001
Due: 22 October 2001, 5:30pm, one per team

Your first Project assignment, which was also serve as the first Homework assignment for the course, is to design E-R and object-relational models for the database supporting your streaming video VoD web site. The documents you produce must eventually be made available online, so be sure to use HTML. To hand in your assignment, make a hardcopy of your HTML documents and bring them to class on the assignment due date. Make sure your documents are stapled together and your names are clearly indicated on the first page.

Your HTML document is required to contain the following information:

• The name of your team (i.e. this should also be the name of your web site)
• The names and e-mail addresses of the two team members
• E-R diagram capturing the conceptual design of your database system. Be sure to use the object-relational extensions of the E-R model discussed in Section 25.6.3 of Ramakrishnan and Gehrke.
• Brief rationale (in English) for your (extended) E-R model
• Object-relational model of your database system, based on your E-R design. Your object-relational model should be given in the form of SQL3 CREATE TABLE|VIEW|INDEX etc. statements.
• The SQL3 description of your object-relational model should include as many integrity constraints as possible, including domain, key, and referential integrity constraints.
• A list of functional dependencies capturing any additional integrity constraints on your database system.
• Brief rational (in English) for your object-relational model.