CS290F Fall 2006 - UCSB Computer Science - Thorsten von Eicken

Contents 1 Project 3: Critical Paths and SQL Queries 1.1 Critical Path 1.1.1 Path 1 (For user) 1.1.1.1 SQL Queries 1.1.1.2 Graphs 1.1.2 Path 2 (For Employer) 1.1.2.1 SQL Queries 1.1.2.2 Graphs 1.1.3 Path 3 (For Employer) 1.1.3.1 SQL Queries 1.1.3.2 Graphs

Project 3: Critical Paths and SQL Queries

Critical Path

Path 1 (For user)

1. User logs in
2. Visits home page
3. Searches for jobs by location and jobtitle
4. Adds some to cart
5. Goes to apply page
6. Attaches documents
7. Applies

SQL Queries

Path 1 Queries

Graphs

Path 1 Optimization results

	Graphs
Replies/sec
Response Time

Path 2 (For Employer)

1. User logs in
2. Visits home page
3. Selects "Employer Task" tab
4. Views a listing of all the companies he is authorized to manage
5. Creates a new listing for a company

SQL Queries

Path 2 Queries

Graphs

Path 2 Testing results

	Graphs
Replies/sec
Response Time

Path 3 (For Employer)

1. User logs in
2. Visits home page
3. Selects "Employer Task" tab
4. Views a listing of all the companies he is authorized to manage
5. Views joblistings for a chosen company
6. Views the applications corresponding to that joblisting
7. Views the associated documents for an application
8. Changes the status of the application

SQL Queries

Path 3 Queries

Graphs

Path 3 Testing results

	Graphs
Replies/sec
Response Time