center for advanced vehicular systems information system and management tool matthew denton julie...
TRANSCRIPT
![Page 1: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/1.jpg)
Center for Advanced Vehicular SystemsInformation System and Management Tool
Matthew Denton
Julie Sparkman
Jon Yu
Anshuman Ghai
![Page 2: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/2.jpg)
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
• 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
![Page 3: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/3.jpg)
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
• Lack of a marketable website– Must be easy to update– Must be easy to use
• Unorganized data– Multiple data sources– Lack of data integrity
![Page 4: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/4.jpg)
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
• Website Redesign using MySQL and PHP– Website draws data from database– Database is updated by functionality built into
the intranet part of the website
![Page 5: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/5.jpg)
New Issue
• CAVS Employees are not using the website– Due to:
• Lack of Awareness• Lack of time• Lack of incentive
• CAVS Employees are not using the website– Due to:
• Lack of Awareness• Lack of time• Lack of incentive
![Page 6: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/6.jpg)
Solution
• Build quarterly reports and other useful reports using information gathered through website interface
• Build quarterly reports and other useful reports using information gathered through website interface
![Page 7: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/7.jpg)
Analysis
• Interview– What reports are needed
• Example Documents– Quarterly Report
• User feedback– Interface questions– Improvements
• Interview– What reports are needed
• Example Documents– Quarterly Report
• User feedback– Interface questions– Improvements
![Page 8: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/8.jpg)
Report Types
• Management wanted ability to query all activities at CAVS
• Organize information by research team, date, and type
• Build employee reports
• Management wanted ability to query all activities at CAVS
• Organize information by research team, date, and type
• Build employee reports
![Page 9: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/9.jpg)
Report Requirements
• Current Modules– Publication– Employee – Projects and funding information– CAVS affiliates
• Current Modules– Publication– Employee – Projects and funding information– CAVS affiliates
![Page 10: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/10.jpg)
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
• 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
![Page 11: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/11.jpg)
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
• 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
![Page 12: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/12.jpg)
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
• 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
![Page 13: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/13.jpg)
Gantt Chart
6 8 10 12 14 16 18 20 22 24 26 28 30 1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 2 4 6 8
Cover Sheet draft
Requirement Analysis-Initial Interview
Context Level DFD and Diagram 0
ERD
Amend Database
Finish DFDs
Structured English
Decision Trees
Coding & Testing
Add Data to Database
Powerpoint & Report
Practiceand FinalizePresentation
October November
Gantt ChartCAVS Information System
Team 4
![Page 14: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/14.jpg)
PERT Diagram
![Page 15: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/15.jpg)
ERD
ERDEdited Tables
Added Tables
![Page 16: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/16.jpg)
Context Level DFD
![Page 17: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/17.jpg)
Diagram 0
![Page 18: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/18.jpg)
Diagram 0 (cont.)
![Page 19: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/19.jpg)
Diagram 0 (cont.)
![Page 20: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/20.jpg)
Diagram 0 (cont.)
![Page 21: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/21.jpg)
Diagram 0 (cont.)
![Page 22: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/22.jpg)
Diagram 0 (cont.)
![Page 23: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/23.jpg)
Process 1.0
![Page 24: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/24.jpg)
Process 1.5.0
![Page 25: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/25.jpg)
Process 1.5.0 (cont.)
![Page 26: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/26.jpg)
Child 1.5.1.0
![Page 27: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/27.jpg)
Child 1.5.2.0
![Page 28: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/28.jpg)
Process 2.0
![Page 29: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/29.jpg)
Process 2.0 (cont.)
![Page 30: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/30.jpg)
Child 2.0 (cont.)
![Page 31: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/31.jpg)
Process 2.5.0
![Page 32: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/32.jpg)
Child 2.5.0 (cont.)
![Page 33: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/33.jpg)
Process 3.0
![Page 34: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/34.jpg)
Process 4.0
![Page 35: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/35.jpg)
Process 5.0
![Page 36: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/36.jpg)
Process 6.0
![Page 37: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/37.jpg)
Process 6.0 (cont.)
![Page 38: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/38.jpg)
Decision Trees
![Page 39: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/39.jpg)
Decision Trees
![Page 40: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/40.jpg)
Decision Trees
![Page 41: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/41.jpg)
Decision Trees
![Page 42: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/42.jpg)
Decision Trees
![Page 43: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/43.jpg)
Structured English
![Page 44: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/44.jpg)
Structured English (cont.)
![Page 45: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/45.jpg)
Structured English (cont.)
![Page 46: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/46.jpg)
Implementation• Website
– Plunge
• Website modules– Phased
• Website– Plunge
• Website modules– Phased
![Page 47: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/47.jpg)
Maintenance
• Work out bugs that couldn’t be predicted
• Enhance user interface and usability
• Work out bugs that couldn’t be predicted
• Enhance user interface and usability
![Page 48: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/48.jpg)
Future Goals
• Add modules to increase functionality
• Create more reports as needs arise
• Add more data checking features to decrease amount of fraudulent data
• Add modules to increase functionality
• Create more reports as needs arise
• Add more data checking features to decrease amount of fraudulent data
![Page 49: Center for Advanced Vehicular Systems Information System and Management Tool Matthew Denton Julie Sparkman Jon Yu Anshuman Ghai Matthew Denton Julie Sparkman](https://reader035.vdocuments.us/reader035/viewer/2022070402/56649f225503460f94c3a008/html5/thumbnails/49.jpg)
Conclusion
• Improves efficiency
• Provides instant report capabilities
• Centralized repository decreasing redundant out-of-date data
• Improves efficiency
• Provides instant report capabilities
• Centralized repository decreasing redundant out-of-date data