Shirley Abrahami

1
SundanceFlix.com

• Shirley Abrahami
• Aryk Grosz
• Laura Halstead
• Veronica Vela

2
Table of Contents

• Description of SundanceFlix.com
• Data Needs
• Database Requirements
• EER Diagram
• Implementation
• Recommendations

3
SundanceFlix.com

• Owned by Sundance Films
• Most comprehensive online archival
• Films, shorts, documentaries
• Specializing in Sundance Films

4
SundanceFlix.com

• Online movie rental
• Allows users to
• Download (watch later)
• Stream films (watch now)
• PayPal, Credit Card

5
Our Customers

• Our Customers
• 6,000 users/month
• 3.00/film
• PayPal or Credit Card

6
Competition

• 3 Types of Competitors
• On demand film
• MovieLink.com
• CinemaNow.com
• MovieBeam.com
• PPV cable

7
Competition

• Video Rental Stores
• On location stores
• Blockbuster, etc.
• Order Deliver
• Netflix.com

8
Data Needs

• Customer View
• Information on films
• Popular films
• Customer order history

9
Data Needs

• Company
• Order history of upcoming films
• Customer orders
• Customer errors
• Server
• Potential clients
• Sponsors Ads
• Employees

10
(No Transcript)
11
Implementation

• Relationship View

12
Live Queries

• Downloads by Distributors
• Customers by Genre
• Order History

13
Implementation

• Movie Query

14
Implementation

• Sample Query Customer Errors

15
Implementation

• Sample Query Rental History

16
Recommendations

• Intelligent searching
• Usability
• Targeted film advertising
• More consumer feedback
• My Picks section
• Trailers
• Interviews with Filmmakers

17
Recommendations

• Online communities
• Customers
• Filmmakers
• Friendster based

18
Bio
Current Projects
Project Needs Openings
Network
Search Watch
Email
Testimonials by other filmmakers
19
Questions?