database

Database needed: Elementary school database holding parent, student and employee info.

Person interviewed: first last .

After explaining the benefits of a newly designed database that is comprehensive in fulfilling the required elements and secure from outside breaches and is owned in house instead of paid for by a monthly subscription, the school’s administration agrees that a new system would be of benefit to their school.

Details:

· What is the data to be maintained: Student and parent demographics, student grade levels and scores, state test results, discipline records, health and immunization records, tuition records

· Data elements:

· first name, last name, middle name of parents and students

· street number, street name, city, state, zip code of home address

· grade level of each student

· grade of student in each class

· class names [English, Math, Social Studies, Reading, Foreign Language, Art]

· first name, last name, and middle name of teachers and other employees

· tuition rates, fees amounts

· immunizations [MMR, Varicella, DTP, Hep A, Hep B, Meninigitis]

· banking routing numbers and account numbers for ACH payments

· New or existing system? There is a system in place but it is not performing satisfactorily and is missing some desired elements.

· Consequences if data is not maintained properly—If the data is not maintained properly, security breaches could reveal bank account numbers, health information concerning students, marital statuses of the student’s parents and any attached legal judgments, scores of students could be exposed, personal info such as birthdates, addresses and social security numbers of parents and employees

· What is wrong now that new system would fixThe current system has the following deficiencies:

· No place to enter state test scores

· No place for social security numbers

· No way to enter immunizations

· No way to scan in incoming records from other schools

· Is this replacement, why is existing system inadequate:

· System is clunky

· System crashes/freezes frequently

· Above items are necessary to have in the database

· Current system ‘loses’ info and it has to be re-entered

· Monthly subscription to database is costly

· Who are stakeholders: School board and administration

· Are there any legal, ethical, or privacy concerns that should be taken into account when creating and implementing the system? Because so much personal and private information is held in the school database, it is vital that it is highly secure to prevent any loss of personal or financial info

· Is this project feasible within the constraints of this class? ie: technology, budget???

Yes

· Validate the plan with the person interviewed and get approval

Approved by first last