实现一个网站的数据库连接部分，以及网站所需的CRUD部分。
Executive Summary / Definitions
The purpose of this system is to create a website for faculties to keep track of students in St. Anne’s Belfield School. The users of the project mainly are upper school faculties.
Teachers should be able to log into the website by their school email and pull up students through a search function. Students’ profiles will be displayed on the page, including students’ names, headshots, grade level, classes that they enrolled in, and the records of notes.
When adding the notes on the student, a menu of the category of the note will be shown on the screen, including General, Discipline, Medical, and Academic. The notes should be saved below students’ records and be accessible by certain staff members.
Functional Requirements
- Login and registration
- Login by email and password
- Students’ Profile
- Display students’ names, headshots, class, and record
- Searching functionality
- Searching students according to their name/last name
- Note menu and records
- Choosing a category of note from the menu
- The note automatically records under students’ profile
- The note can be accessible after refreshing the page and by other certain people
- The note is editable after being saved.
- Time
- display the time when the note was added
- Debugging
- Successfully saved or fail to save notification
- Login failed notification
- No such student notification
Non-Functional Requirements
- Programs and Applications
- Android applications
- IOS applications
- PWA web applications
- Electron desktop applications for Window, MacOS, and Linux
- Account Integration
- Integration with Google
- Linking account with social media accounts
- Transferring data from veracross.
- Privacy and security
- Google authentication
- Email authentication
- User groups
- Changing password
- Face recognition
- User interface and functionality
- Notification
- Admin control
- Advanced decoration and animation
- Dark & Light mode
- Theme and Color
- Ads
Interface Requirements
[UI-User]
- Login page
- Saving notes
- Select category from menu
- Searching input
Overall UI Breakdown
- Login page for users to input email and password.
- Students gallery with their name and headshot
- A searching bar above students galley for users to input student names.
- [when clicking certain student]: students headshot, name, grade level, class enrollment, and past record notes
- A note-adding button for users to click
- [when clicking the note-adding button]: Menu of the category of record: General, Discipline, Medical, and Academic, and a text entry box for user to input notes.
- Save button and “successfully saved notification”
- Edit button for the user to go back and edit the notes.
Database & Core Relations
Database that store list of username and password on faculty end
Store access permission on different student
Connect with frontend and transfer database to frontend
Store notes under each student in the database
Store record time under each action
Immediate Next Steps (Pre-Phase)
Backend: minimum of Database, determine the way for transferring data from veracross and the way saving the record
UI: Design decisions including layout, color, overall looking