BUILD YOUR OWN VIDEO RENTAL STORE

Build a virtual vide rental ostore, a la www.kozmo.com. These are the
steps:

1. Model entities such as videos, their titles, actors, directors,
etc...  Create a schema and an E/R diagram representing your
database. Create useful and meaningful relationships between the
entity sets (for example one relationship is between videos and
actors). Also describe any constraints you want to have on your schema
(referential integrity constraints, functional dependencies, etc...).

2. Transform your E/R diagram into SQL syntax and create a "real" database
in SQL Server using your model.

3. Populate your database. You can either use "synthetic" data or download
a list of "real" videos and populate your database. You should have at
least 25 videos in the database. If you choose to use synthetic data,
please use meaningful names and entries.

4. Create another table(s) storing customers along with their VISA and M/C
card numbers and other relevant information. Create meaningful
relationships between customers and videos, actors, etc...

5. Create a WEB portal to your database. Videos should be able to be found
using actors, titles, directors. Once a search has completed, a
web page should be created summarizing the results of the search. Also for
each video in the summary, there is a link that the user can click on to
expand the information about the respective video.

6. Add e-commerce functionality to your website. Let a user be able to
buy his/her desired video from your database. Each buyer needs to be
able to order his video, and fill in his credit card information. (Do
not worry about security issues). Store the credit card information in
your database, so that a user does not have to enter this information
more than once. However, allow the user to modify his credit card
information.  Keep track of how many copies of each video you
currently have in stock: when a customer rents a video, that number
has to decrease.  Create another page for returning a rented video.

7. Export your database in XML.  Design an XML DTD that contains
elements and/or attributes corresponding to the entities in your
database, such as titles, actors, directors, etc, and write a program
that exports the entire database into an XML format with that DTD.

BONUS: If a user is searching for a video you don't have in stock,
your database application should go to kozmo.com and search for the
respective video and add it to your database. The price of the video
should be 20% higher than at kozmo.com.  For example the following URL
searches for "as good as it gets":

http://www.kozmo.com/cgi-bin/ncommerce3/KozmoDisplaySearch?kz_search_cat_id=1&kz_search_string=as+good+as+it+gets&kz_page_num=1&MERCHANT_RN=3


NOTE: Do not make your schema too complex: the entire project should
contain at most 3-4 entity sets plus relationships.