1 / 9

Database Query Reporting System

Preliminary design overview of a system allowing users to generate reports by selecting query types from the database, including current and archived data. Detailed process of query submission, report retrieval, and storage device interaction. Implementation of various query types and user authentication for secure access.

oreynolds
Download Presentation

Database Query Reporting System

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Title

  2. Agenda • Overview • Life Cycle Model • Data Flow • Data Dictionary • Constraints • Prototype • Summary Preliminary Design

  3. Overview Preliminary Design

  4. The Life Cycle Model LifeCycle Model Software Definition Requirements Specification Preliminary Design Detailed Design Acceptance Test Preliminary Design

  5. Data Flow Preliminary Design

  6. Data Dictionary Generate Reports Process Description: Allows the user to choose from five different query types from the database, this includes current information and archived data. Process #: 5 Process Description: Takes in a query or archive request from the user and returns the report from the database or storage device. Notes: The five types of queries are: annual report, individual summary, individual detailed, squad summary and squad detailed. Location: level 1 ( 0 ) Input Flows: Report-Query Archive-Data Report-Query Query-Results Output Flows: Request-Archive Query Report Date Last Altered:11/24/2002 Date Created:11/24/2002 Preliminary Design

  7. Constraints • Authenticated Login • Activity Form • Redundancy • Tour of Duty • Reports • Archiving Preliminary Design

  8. Prototype Preliminary Design

  9. Summary • Detailed Design Documents • February 24, 2003 • Detailed Design Presentation – February 28, 2003 • Acceptance Test Documents • April 14, 2003 • Acceptance Test Presentation – April 16, 2003 Preliminary Design

More Related