Разработка базы данных для обработки информации о внеурочной деятельности учащихся средней школы

Abstract

Basic information systems for the general statistics collecting about students and their grades, about homework have long been widely used as part of the school system. But such systems often do not take into account the needs of teachers and head teachers in the information processing about other achievements of secondary school students, for example, participation in local and regional olympiads, about sports, social and other achievements of students. Knowledge of this information may be necessary both to form a portfolio and to participate in various competitions and events held at the school. In this case, it becomes necessary to create narrowly focused software that allows you to analyze and evaluate the extracurricular activities of high school students. This article describes databases for the information processing about various achievements of secondary school students. Relationships between tables that are part of the database are defined. The developed database allows you to automate the processes of adding, editing and the information searching about the extracurricular activities of students. Opportunities have been implemented, such as, for example, the achievements automatic estimation of school students, obtaining a list of school students with gradation by the number of points, and the statistics providing about the achievements of individual students. After installation and initial configuration, the database does not require additional maintenance. User accounts have been created to differentiate the access rights of different user groups. This approach provides details of security levels, that is, allows you to indicate what exactly the user is allowed.