Data Source

CS290F Fall 2006 - UCSB Computer Science - Thorsten von Eicken

Home

Data Source

We will rely on Amazon E-Commerce Service (ECS) to collect data for DVDs titles, manufacturer, producer, image, price, audience rating and format. ECS can be used also to fetch user reviews.

We have designed the schema of our database to hold all the information gathered from the data source. The figure below shows the schema. Blue table are the primary tables, while yellow ones are the M-N relation table.

Project 2 Functionality

• Models:

1. dvds: dvds title, manufacturer, producer, average_user_rating, ... etc.
2. actors: actor name (for now). We may include a short biography.
3. users: users accounts data (username, hashed password)
4. shopping cart: saved shopping cart for each user

• Controllers

1. dvds: operate on dvds: list them alphabetically, search by name, modify rating.
2. users: operate on users: add user(username, password), log in user.
3. shopping cart: add shopping cart item, remove shopping cart item, empty shopping cart.