Center%20for%20Advanced%20Vehicular%20Systems%20Information%20System%20and%20Management%20Tool

1
Center for Advanced Vehicular SystemsInformation
System and Management Tool

• Matthew Denton
• Julie Sparkman
• Jon Yu
• Anshuman Ghai

2
About CAVS

• Focused on developing superior computational,
  engineering, manufacturing, design, and
  information technologies relevant to Mississippi
  industries
• Approximately 200 employees
• Ranging from undergrad to faculty
• 10 research teams operating quasi-independently

3
Issues

• Lack of a marketable website
• Must be easy to update
• Must be easy to use
• Unorganized data
• Multiple data sources
• Lack of data integrity

4
Solution

• Website Redesign using MySQL and PHP
• Website draws data from database
• Database is updated by functionality built into
  the intranet part of the website

5
New Issue

• CAVS Employees are not using the website
• Due to
• Lack of Awareness
• Lack of time
• Lack of incentive

6
Solution

• Build quarterly reports and other useful reports
  using information gathered through website
  interface

7
Analysis

• Interview
• What reports are needed
• Example Documents
• Quarterly Report
• User feedback
• Interface questions
• Improvements

8
Report Types

• Management wanted ability to query all activities
  at CAVS
• Organize information by research team, date, and
  type
• Build employee reports

9
Report Requirements

• Current Modules
• Publication
• Employee
• Projects and funding information
• CAVS affiliates

10
Report Requirements (cont.)

• Needed modules
• Proposals and proposal funding
• Employee Activities
• Employee Tours and tour members
• Ability to update proposal information
• Need to integrate old modules with new modules

11
Feasibility

• Technologically
• MySQL powerful free database software
• PHP server already in place
• Economically
• Free tools
• Save money in long run
• Operationally
• Goal to make interfaces as intuitive and easy to
  use as possible

12
Security

• Intranet login
• Defined rights for different user groups
• Items are giving public or private status
  depending on type and sensitivity
• Robot.txt file disallows robot access to intranet
  and proposal directory

13
Gantt Chart
14
PERT Diagram
15
ERD
ERD
Edited Tables
Added Tables
16
Context Level DFD
17
Diagram 0
18
Diagram 0 (cont.)
19
Diagram 0 (cont.)
20
Diagram 0 (cont.)
21
Diagram 0 (cont.)
22
Diagram 0 (cont.)
23
Process 1.0
24
Process 1.5.0
25
Process 1.5.0 (cont.)
26
Child 1.5.1.0
27
Child 1.5.2.0
28
Process 2.0
29
Process 2.0 (cont.)
30
Child 2.0 (cont.)
31
Process 2.5.0
32
Child 2.5.0 (cont.)
33
Process 3.0
34
Process 4.0
35
Process 5.0
36
Process 6.0
37
Process 6.0 (cont.)
38
Decision Trees
39
Decision Trees
40
Decision Trees
41
Decision Trees
42
Decision Trees
43
Structured English
44
Structured English (cont.)
45
Structured English (cont.)
46
Implementation

• Website
• Plunge
• Website modules
• Phased

47
Maintenance

• Work out bugs that couldnt be predicted
• Enhance user interface and usability

48
Future Goals

• Add modules to increase functionality
• Create more reports as needs arise
• Add more data checking features to decrease
  amount of fraudulent data

49
Conclusion

• Improves efficiency
• Provides instant report capabilities
• Centralized repository decreasing redundant
  out-of-date data