Transcript Team “B” SDLC Project - California State University, Northridge

California State University,
Northridge Certification
Process
Team B
Carlos Guzman
John Kramer
Stacey LaMotte
University of Phoenix
Feasibility and Planning
Proposal and Scope
 Transfer California State University Northridge
credential students’ records from hardcopies
electronic media
 Minimize paper usage and costs, modernize
processes and centralize student information
 Provide a server that can be network to the
desktop computers
 The server would require hosting a database
Scope Continued …….
Student calls
office
Retrieve
record from
file cabinet
yes
Provide student
Information or
update record
Is student on
File?
Enroll student via
Pen and Paper
Periodically, perform
file maintenance
and
archiving
Create file for
student and file
Secure file cabinets and verify security
upon leaving every night
Goals
 Save the department money without sacrificing
reliability and effectiveness
 Trained employees in the use of the software
and the database for proficiency
 Convert all hard copy files to electronic media
for quicker access and improved security
Cost
 Cannot exceed $30,000
Server ----------------------------------------- $3,000
Network cabling ---------------------------- $1,500
Labor to connect server ------------------ $4,000
Labor to enter records -------------------- $3,000
Labor cleanup ------------------------------ $2,500
Training -------------------------------------- $4,000
Analysis
 Database front-end interface will be hosted via
Web-services
 Develop a specialized Data Base Management
System
 Maximize development by installing a report
wizard that will facilitate usability
 Perform interviews among users and
administration personnel
Implementation & Maintenance
Administration
Faculty
Student
User logs in via user name and
password
Administrato
r?
Yes
No
No
Faculty?
Yes
User has full
privileges
User has faculty
privileges
User has student
privileges
Enter Student name and ID
Provide screen to
enter students
info
No
Student
in
database?
Yes
Display Student information
Info
update?
No
Log off
Yes
Allow update of any
information and any
special forms
Allow update of
grades and
student notes
Save data to disk and request another transaction
Log Off
Figure 2
Allow update of personnel
information; address, marital
status, weight, number of tattoos,
etc, and any forms that can be
filled out by student; financial
assistance, etc
Preliminary Design Model
Documentation Plan Summary
 System Documentation
 Database
 Script to Back-up
database
 Database Internet
connection
 Database Diagram
 Server
 Application tools
 Minimum
Hardware/Software
 System documentation
 User client procedure
 Administration user
settings
 Evaluator user
settings
 Counselor user
settings
 Student user settings
Testing and Training
TESTING PROCESS
 Verifying Design
 Verifying Code
 Integration Testing
 Function Testing
 System Testing
Training
 (OJT) training
 Cross training staff on system process
and maintenance
 Valuing all suggestions and input
from staff
Question or Comment?