"ASP application development" period ending
ASP application development period exercises
Purpose: Develop database applications with ASP
Function: a student score management system
Function Description:
1. User authentication, users have three categories: system administrators and grades administrators, ordinary users. Different users have different permissions after logging in. The system administrator can set the permissions of other users, and cannot query the score. Grade administrators can enter and modify students' performance. Ordinary users can only query their own achievements, and the username of ordinary users is consistent with the ID in the transcript.
2. System management function: System administrators can list all users, add, and modify users, modify user passwords, and modify user permissions categories.
Selecting advanced features: increasing users (for example, get all students from the student roster, all added to ordinary users, and set a unified password.)
3. After regular users log in, they can modify their passwords and query my grades.
4. Grade administrators can enter, modify, query, and count all student scores.
Design requirements:
1. The database system uses Access or SQL Server, at least three data tables: user rights table, student list table (field is a student number and name, gender, etc.), student transcripts (fields are students, mathematics results, physical scores ... total grades, etc.)
2. All subsequent pages after the user log in must first check user permissions (implemented with session)
3. The query feature executable by the results administrator includes simple query and comprehensive condition query.