NavSys NROTC Database System

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 Womens 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 whos 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
On To EER Diagrams
Zoom -zoom
13
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.

14
Person Entity
15
Person Subtypes
16
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.

17
Event Entity
18
Rest of Entities
19
The Big Picture

• Take a deep breathblast off!!!!

20
(No Transcript)
21
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

22
Any Questions?