USA Banner
  U.S. flag
              An official website of the United States government Here's how you knowOfficial US Government Icon
              **Official websites use .gov**A **.gov** website belongs to an official government organization in the United States.
            Secure Site Icon
              **Secure .gov websites use HTTPS**
                  A **lock** ( A locked padlock ) or **https://** means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites. 
 U.S. Department of Transportation Icon United States Department of Transportation
 Search DOT
            Search
                    About FHWAFHWA Organization
                Headquarters Offices
                Field Offices
                Strategic Plan
                Business Opportunities
                Staff Directories
                Careers
                Highway History
                Contact UsProgramsAcquisition Management
                Civil Rights
                Federal Lands Highway
                Infrastructure
                Innovative Program Delivery
                Operations
                Planning, Environment, and Realty
                Policy
                Research, Development, and Technology
                Safety
                Browse by TopicsResourcesCore Highway Topics
                Federal Aid Essentials
                Automation
                Complete Streets
                Laws and Regulations
                Policy & Guidance Center
                Section 508
                Publications and Statistics
                Professional Development
                National Highway Institute
                Resource Center
                Accessibility Resource Library
                FHWA Research LibraryNewsroomPress Releases
                Speeches & Testimony
                Photos
                Videos
                Media ContactsMenu FHWA Highway Safety Programs Home
                        Development of a Structure for a MIRE Management Information System


            
            In This Section
        Safety Data Analysis & Tools
                Crash Modification Factor Clearinghouse
                Roadway Safety Data Program (RSDP)
                                Overview
                Data Driven Safety Analysis
                Data Management
                Safety Data Analysis Tools
                Local Data Integration
                Technical Assistance
                Case Studies
                Training
                Resources
                Highway Safety Manual (HSM)
                Model Inventory of Roadway Elements (MIRE) and FDEs
                Systemic
                                Overview
                Why Systemic
                Training
                Resources
                Road Safety Audits
                                Overview
                Benefits
                Legal Issues
                Steps of Conduct
                Training
                Resources
                
                APPENDIX C. LOGICAL MODEL ENTITY RELATIONSHIP DIAGRAM
This diagram expands on the conceptual model to demonstrate the structures within a relational database. There is an ERD for segment, intersection, intersection leg, interchange and curves and grades.
      
  Book traversal links for APPENDIX C. LOGICAL MODEL ENTITY RELATIONSHIP DIAGRAM
      ‹ APPENDIX B. CRASH DATA OVERVIEW ENTITY RELATIONSHIP DIAGRAM
                    Up
                    List of Figures ›
                
                Book:Development of a Structure for a MIRE Management Information System
              EXECUTIVE SUMMARY
                INTRODUCTION
                Introduction
                DEVELOPMENT OF THE CONCEPTUAL STRUCTURE OF THE MIRE MIS
                TESTING THE MIS STRUCTURE
                DATA QUALITY
                CONCLUSION
                REFERENCES
                APPENDIX A. KEY TO DATA FLOW DIAGRAMS
                APPENDIX B. CRASH DATA OVERVIEW ENTITY RELATIONSHIP DIAGRAM
                APPENDIX C. LOGICAL MODEL ENTITY RELATIONSHIP DIAGRAM
                List of Figures
                ACRONYMS U.S. DEPARTMENT OF TRANSPORTATION

**Federal Highway Administration**

1200 NEW JERSEY AVENUE, SE

WASHINGTON, DC 20590

202-366-4000Subscribe to email updates
                    About
  

        
              About FHWA
                Careers
                Org Chart
                Staff Directories
                Work with UsPrograms
  

        
              Acquisition Management
                Civil Rights
                Federal Lands Highway
                Infrastructure
                Innovative Program Delivery
                Operations
                Planning, Environment, and Realty
                Policy
                Research, Development, and Technology
                SafetyPolicies, Rights, Legal
  

        
              About DOT
                Accessibility
                Budget and Performance
                Civil Rights
                FOIA
                Information Quality
                No FEAR Act
                Office of Inspector General
                Privacy Policy
                USA.gov
                Web Policies and Notices
                Web StandardsNews & Events
  

        
              Newsroom
                Press Releases
                Speeches & Testimony
                Media Contacts
                Connect with Us