URL Production website:
http://wren.cis.upenn.edu/mccormjb/scraperproduction/Default.aspx
URL Staging website:
http://wren.cis.upenn.edu/mccormjb/scraperstaging/Default.aspx
DataBase Location :wren.cis.upenn.edu;
Staging:
Database name=khvatov
User ID=khvatov
Password=tabby06
Production:
Database name=mccormjb
User ID=mccormjb
Password=nutty08
Database descriptions:
tblTerms:
term varchar(10) PK NOT NULL
tblDepartments:
deptAbbr varchar(4) PK NOT NULL
deptName varchar(50) NOT NULL
deptUrl varchar(30) NOT NULL
term varchar(10) PK NOT NULL
tblCourses:
courseId int PK NOT NULL
deptAbbr varchar(4) NOT NULL
courseName varchar(50) NOT NULL
courseNumber int NOT NULL
credits float NOT NULL
term varchar(10) PK NOT NULL
tblSections:
sectionId int PK NOT NULL
courseId int PK NOT NULL
term varchar(10) PK NOT NULL
professor varchar(50) NOT NULL
location varchar(20) NOT NULL
sectinType varchar(5)
sectionTime varchar(50) NOT NULL
sectionDays varchar(10)
Alex Khvatov
Course scraper Time estimate:
Requirements Analysis 2
Design
Classes 1
Use Cases 1
Methods 1
Prototyping 4
Test Design 1
Implementation (Code, Debug) 35
Testing (Integration, System)25
Documentation 1
Total 71
+ 15%
Total Estimate: 81
Actual time spent:
Requirements Analysis 3
Design
Classes 2
Use Cases 0.5
Methods 4
Prototyping 10
Test Design 1
Implementation (Code, Debug) 60
Testing (Integration, System) 5
Documentation 3
Total Actual: 88.5
John McCormack
Course scraper Time Estimate:
Requirements Analysis 2
Design
Classes 1
Use Cases 1
Methods 1
Prototyping 20
Test Design 1
Implementation (Code, Debug) 50
Testing (Integration, System)25
Documentation 1
Total 102
+ 15%
Total Estimate: 117
Actual time spent:
Requirements Analysis 5
Design
Classes 2
Use Cases 2
Methods 4
Prototyping 25
Test Design 2
Implementation (Code, Debug) 70
Testing (Integration, System)10
Documentation 2
Total Actual: 122
Su-Ting Chuang
Course scraper Time Estimate:
Requirements Analysis 1
Design
Classes 1
Use Cases 1
Methods 1
Prototyping 15
Test Design 1
Implementation (Code, Debug) 60
Testing (Integration, System)20
Documentation 1
Total 81
+ 10%
Total Estimate: 89
Actual time spent:
Requirements Analysis 2
Design
Classes 2
Use Cases 2
Methods 6
Prototyping 30
Test Design 2
Implementation (Code, Debug) 60
Testing (Integration, System)10
Documentation 2
Total Actual: 116