1 / 20

NavSys NROTC Database System

Our project aims to create a centralized database for Navy ROTC, streamlining alumni tracking and event management. Addressing the current ad hoc system, the database will provide accessibility, security, and functionality for staff, students, and alumni.

wilton
Download Presentation

NavSys NROTC Database 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. NavSysNROTC Database System Team 7 ◊ George Datskos ◊ Danny Greenia ◊ James Park ◊ Jeff Pickelman ◊ Dmitry Shafranov ◊ Gareth Williams ◊ Adnan Zubair

  2. Design Project Review 1 • Meet the team • Naval ROTC Overview • Vision • EER Diagram • Project Schedule

  3. Background • Navy Reserve Officer Training Corps • Founded in Berkeley in 1926 • Students train to become active officers in the US Navy • Located in Hearst Women’s Gym

  4. System Organization Navy Navy ROTC Active Duty Personnel • ROTC Alumni Battalion Staff • Active Duty • Reserve Student Trainees • Retired • Deceased

  5. By the numbers… • Approximately 90 students and staff • Thousands of alumni • Retired • Active in the military • On reserve

  6. Non-student staff… • 2 Chief Petty Officers • Admin • Supply & In Charge of Students • 4 Instructors • Lt. Victor Garza • Contact • Instructor • Most responsibilities are delegated to students

  7. Problems With Current System • Ad hoc system of storing information • No centralized database • File cabinets filled with folders of loose paper • Students bear many responsibilities • Keep track of who’s in charge of what

  8. Our Vision… From and

  9. Our Vision To

  10. Client Requirements… • Keep track of Alumni • Donation purposes • Reunions, banquets • Problem: deceased alumni receiving invitations • Include method of extracting contact information for label making

  11. In so many words… • The database must: • Be accessible from numerous computers • Be accessible by different staff members, students • Have some degree of security clearance

  12. Textual Summary • The Naval ROTC consists of people, who can be split into students, staff and alumni. People receive publications (which our database will make labels for), which students are in charge of and which also are NROTC expenditures. • Students declare Chits (requests), receive grades, earn PT scores and are responsible for uniform items. Students make payments to the ROTC and receive stipends. Each student has a rank, which form a non-linear hierarchy. • Alumni often donate money to the NROTC.

  13. Person Entity

  14. Person Subtypes

  15. Textual Summary (Continued) • The NROTC holds events at times and locations. These events use supplies and their costs show up as expenditures. A person is in charge of events. A key feature of our database will be tracking who attends events. • Supplies can be broken down into Military and Recreational. Someone is in charge of them and they are checked out by people. They also show up as expenditures.

  16. Event Entity

  17. Rest of Entities

  18. Project Schedule Task: Estimated date: • Revised EER diagram 10/23/05 • Queries, database design 10/28/05 • Beta version of database 11/03/05 • Beta2 version of database 11/10/05 • Final version of database/report 11/15/05

  19. Any Questions?

More Related