Project Monitoring Web Site

1
Project Monitoring Web Site
John Gyselinck
CS 8630, Fall 2005
2
Executive Overview

• I was approached by a friend of mines father to
  design a web site for him that would allow him to
  keep track of the status of each active project
  that he has. He is a consultant that assists in
  the creation of banks and therefore deals with
  many people in the process. He wanted to provide
  everyone with a central place that they could go
  to and find the status of the project at any
  given time (keeps him off of the phone).

3
Development Tools

• Java 1.5.0
• Javascript, JSP and HTML
• Apache/Jakarta Tomcat Web Server 5.0.28
• MySQL 5.0 RDBMS (InnoDB Database Engine)
• May end up having to convert everything to ASP
  (change in specification)

4
Why use these?

• MySQL is free and is the most widely used Open
  Source DBMS available right now
• Replication is very easy in MySQL should we
  decide to go that route
• I have currently been chartered with the task of
  moving all of our production databases at work
  from SQL Server 2000 to MySQL
• MySQL databases are very fast
• Javas write once run anywhere feature

5
Web Site Layout
6
E-R Diagram
7
Relational Schema
8
Data Dictionary
9
Data Dictionary (cont.)
10
Form Description
11
CRUD Matrix
12
Login Page
13
Admin Home Page
14
Create/Update User
15
Delete User
16
Create Project
17
Create Organizers
18
Problems

• Browser caching
• Local machine
• Proxy Server Caching
• MySQL syntax different

19
QUESTIONS?