Project 3: Implementing the Critical Paths with SQL Analysis

CS290F Fall 2006 - UCSB Computer Science - Thorsten von Eicken

Contents 1 Critical Path 1.1 Path 1 (Click Here For SQL Analysis) 1.1.1 User wants to purchase a single 1.2 Path 2 (Click Here For SQL Analysis) 1.2.1 User likes popular music 1.3 Path 3 (Click Here For SQL Analysis) 1.3.1 User buys a previously created CD

Critical Path

SQL Analysis:
SQL queries marked green can be optimized.
SQL queries marked grey can be eliminated.
SQL queries marked dark red can be optimized by adding an index.

Path 1 (Click Here For SQL Analysis)

User wants to purchase a single

1. Homepage
2. Search For Bob Marley by Artist Name
3. View Results
4. Listen to Song
5. Login
6. Rates song
7. Add to Playlist (Cart)
8. Checkout
9. Place order
10. Log out

Path 2 (Click Here For SQL Analysis)

User likes popular music

1. Homepage
2. Browse Top Rated
3. Listen to top rated songs
4. Add top 3 songs to playlist (Cart)
5. Login
6. Checkout
7. Place order
8. Logout

Path 3 (Click Here For SQL Analysis)

User buys a previously created CD

1. Homepage
2. Views User CDs
3. Adds the 3rd User CD to playlist (Cart)
4. Login
5. Checkout
6. Place order
7. Logout