Janete Perez
jperez1
CS190
A Food Services Dilemma


**************************
1. Overview/Motivation:
**************************
Atomic is a database program currently in place in the SMO(Student Management Office) for 
tracking hours for payroll and for maintaining payrate information. It is based in Microsoft Access 
1997 and was implemented around 1999. It is used to keep track of almost all employee information 
during the semester and is essential to the major efforts of the SMO every semester, including 
recruitment and signing up new workers, reapplications, pay raises, and shift changes. The 
problems include that that: it is outdated and large portions are no longer useful or functional; it 
crashes from time to time and generally requires days to get up and running again; it is not extensible 
and is preventing the office from upgrading from MS Office 1997. Instead of updating Atomic, an entire
new program needs to be created.


**************************	
2. Target users
**************************
The user of this program would be the coordinators, managers, and student manager workers in the 
Student Management offfice that are in charge of keeping track of relevant data. The SMO also hires 
student computer consultants to maintain the system so he/she would also be using the program on 
a regular basis.


**************************
3. Requirements
**************************

*Meet course specifications
	-Useful to others
	-Can be scaled up to PC product
	-Divisible portions for a large group
	-Able to be created by students in C++ on Linux machines


*Graphical User Interface
	-An intuitive interface would need to be developed to allow
	users with various computer skills operate the program
	-Allows users to add data, view data & print


*Database
	-The pogram requires a database to keep track of workers
	-Specific information is maintained for each worker
	(see below for the type of information stored)


*Basic functions
	* Sign up new workers
	* Open Shift List
	* Staffing Reports by Unit
	* Designate Supervisors 
	* Commendations and Warnings records
	* Pay Rate records
	* Commencement Shifts records
	* Summer Shifts records
	* Printing capabilities
	* Search for Employees
		- by year
		- by hired date
		- by first or last name
		- by SIS #
		- by box #
	* Queries
		- birthday list
		- number of warnings issued for a person, unit, or by date
		- less than 8 hours per week
		- more than 20 hours per week
		- reactivation list
		- labor hours total by unit
		- phone list/sub list
		- total hours worked
		- people with carts shifts only
		- box list
		- supervisor box list


*Secure
	-The information stored in this program needs to be entirely secure
	-Only coordinators/managers at the SMO office should be able to directly
	read and add any data into the program.
	-Password protected

*Possible extension
	-Networked
		*There might be a need for two or more managers to access information
		*The security requirements would also apply 
	-Internet Interface
		*Student managers expressed a need to be able to access information
		 outside of the office for meeting or updating purposes
		*The security requirements would also apply 



**************************
4. External Dependencies
**************************
It appears that the current system is running on older machines. 
The hardware in the SMO office would need to be upgraded/replaced entirely. 
The operating system would also need to be upgraded. This would ensure that any
problems encountered are not due to hardware/system problems.