Authors

Dr. Manuel D. Rossetti
in cooperation with Dr. William Scherer

Dr. Rossetti: Dept. of Industrial Engineering
University of Arkansas
Fayetteville AK 72701
E-mail: rossetti@comp.uark.edu
Phone: 501-575-6756

Dr. Scherer: Dept. of Systems Engineering
University of Virginia
Charlottesville VA
E-mail: wts@virginia.edu
Phone: 804-982-2069

Description

This course presents an overview of information system architectures and models of computing, database technology, real-time operating system issues, and user interface design concepts. The design and analysis of database systems, such as relational and object-oriented, are explored through exposure to a commercial database system. Particular emphasis is placed on examination of these technologies through the presentation of applications within ITS.

Objectives

Upon completion of the course, participants will be able to:

• Describe software development methodologies
• Estimate software cost/schedule based on functional requirements
• Develop basic database schemas
• Explain information technology security
• Restate the basic concepts of relational database management systems
• Discuss the role of information technology in ITS
• Identify the basic, core, and de-facto information technology standards

Audience

Public-sector Transportation Professionals including US DOT engineers, planners, project managers, and field staff, FTA Regional staff, Intelligent Transportation Systems (ITS) Specialists, and others as appropriate. Transportation professionals from state, regional, and local agencies would also benefit from participation in the course.

Length

Approximately fourteen hours.

Prerequisites

Students should have a basic understanding of ITS and ITS user services, as well as some familiarity with the Telecommunications Technology.

Course Outline

Numbers in parentheses refer to pages.

1. Introduction (1)
2. Information System Architectures (2-9)
1. Processing Models
2. Database management Systems
3. Client Server Computing
4. Three-Tier versus Two-Tier and variants
5. Quizzes 1 and 2
3. Object-Oriented Methodology (10-27)
1. The Waterfall SWDLC Model
2. Five Attributes of a Complex System (Booch, 1994)
3. Object-Orientation
4. Object-Oriented Methodologies
5. Use Case Models
6. Use Case exercise
4. Object Modeling (28-75)
1. Modeling Objects and Classes (28-39)
2. Modeling Attributes (40-52)
3. Modeling Relationships: Links and Associations (53-75)
5. Quiz Bowl Interactive Game (76)
6. Software Estimation (77-107)
1. Method and Example (78)
2. Function Point Analysis (79-80)
3. Detailed Analysis of Incident Management (81-88)
4. Final FPA Count (89-93)
5. COCOMO Analysis (94-106)
6. Sensitivity Analysis Exercise (107)
7. Develop Documents (108-121)
1. Concept of Operations Document
2. Analysis Document
3. Design Document
8. Database Systems (122- 151)
1. Relational Database Design (123-136)
2. SQL Query Operators (137-146)
3. Special Databases (147-151)
9. Data Warehousing (152-160)
1. Architecture and Design
2. Strengths of Data Warehousing in Transportation
3. Weaknesses of Data Warehousing in Transportation
10. Graphical User Interfaces (161-163)
1. Design Issues and Recommendations
11. Quiz 3 (164)
12. Security Issues (165-173)
1. Potential Threats
2. Defense Strategies
13. Session Examination (174)