MT Fire Training Services

Project Notes and Files

• MFS Questions

  This area has answers to some of the questions that were asked to allow for creating a "how to" section.
  • MFS Question Log

• MFS System Backlog

  This area is concerned with the components that need to be completed to finish this project. The listed items will be in order of preference and will be continually updated to reflect what is remaining on the project and what is going to be worked on next.
  • MFS Backlog System

• MFS Entire System

  • ER Diagram
  • Table Definition in DDL system (Project id: 1 Password: mfs)
  • FILE DISTRIBUTION DIRECTORY (current Files for this system)

• RS - Resource Center

  This subsystem is concerned with managing the resource center items. This includes the tables necessary to store the physical items and the tables necessary to reserve and loan out the items.
  • MFS- Resource Library Item document

• PS - Personnel System

  This subsystem is concerned with tracking the users of the MFS system. Users include organizations, fire fighters, instructors, etc.  It contains the information about a person, organization, address, phone number, mailing list, and membership.
• PS-Person and Organization document

• CT - Certification System

  This subsystem is concerned with tracking the certifications that fire fighters earn.
• CT-Certification and Certificates document

• CL - Course/Classes System

  This subsystem is concerned with tracking the offering of classes.
• CL-Class and Course System

• SY - System tables

  • SY_ADDRESS -- Stores all the addresses in the system
  • SY_SYSTEM -- Stores some system settings
  • SY_COUNTY -- Stores the Counties for locations and reporting.