1 / 23

Project Definition: DSS Database Suite

This project outlines the creation of a comprehensive database suite for SIUC's Disability Support Services (DSS). It provides electronic bookkeeping to manage student records effectively, with administrative users granted full access and subsequent users having read-only access. The system will operate on a Windows environment utilizing MySQL for data storage, with a client program developed in C#. Key functional requirements include creating, editing, archiving, and querying student entries, as well as checking in and out equipment. This advanced suite aims to facilitate seamless record management and support for past and future students.

alia
Télécharger la présentation

Project Definition: DSS Database Suite

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. Project Definition: DSS Database Suite Iain Smith & Austyn Krutsinger October 23, 3008

  2. Outline • Project Overview • Definitions • Use Cases • Functional Requirements • Non-functional Requirements

  3. Overview • Provide electronic bookkeeping for past and future students to the Disability Support Services department of SIUC. • Allows administrative users full access • Subsequent users will have strictly read access

  4. Environment • Hardware: • Client: Employee’s Workstation • Server: Department Server • Operation System: • Client: Window XP/Vista with .NET Framework and MySQL extension • Server: Windows Server 2000/2003/2008 with .NET Framework and MySQL • Network Connection: LAN • Code Standard: The database will be MySQL

  5. Environment • The client program will by coded in C# using Microsoft Visual Studio 2005 • The connection to the DSS Database will be done internally with C# using the MySQL ODBC extension • Performance: The system should save and load the records in the appropriate table of the DSS Database 100% of the time

  6. Definitions

  7. Use Cases: Iteration 1 • UC1: Create Student Entry • UC2: Edit Student Entry • UC3: Archive Student Entry • UC4: Query Student Entries

  8. UC1: Create Student Entry

  9. UC2: Edit Student Entry

  10. UC3: Archive Student Entry

  11. UC4: Query Student Entries

  12. Use Cases: Iteration 2 • UC5: Check-out Equipment • UC6: Check-in Equipment

  13. UC5: Check-out Equipment

  14. UC6: Check-in Equipment

  15. Functional Requirements • FR1: Database Access • FR2: Save Student Information • FR3: Search for Student Information

  16. FR1: Database Access

  17. FR2: Save Student Information

  18. FR3: Search for Student Information

  19. Nonfunctional Requirements • NF1: Intuitive User Interface • NF2: Program Package

  20. NF1: Intuitive User Interface

  21. NF2: Program Package

  22. System Evolution • Future Iterations • Forms • Test Scheduling • Text Book Ordering • …and anything else they want

  23. Answers.

More Related