super-database

byPatryk Biniek

Create a full-stack web application for managing student tutoring registrations (adding and removing students). The system should allow the user (admin/teacher) to manually input student data into a form and store it in a SQL database. Each new entry should be automatically assigned an incremental ID number (1 to n). Required student fields: Auto-generated ID (1, 2, 3, ...) First name Last name Address Subject (e.g., math, physics, etc.) School class Level (basic or extended) Lesson day (day of the week) Lesson time (start time and end time) Hourly rate Functional requirements: Add Student A form should allow entering all the above data. After submission, the data must be saved in a SQL database. The table displayed on the website should update instantly without requiring a page reload (use AJAX / Fetch API or WebSockets). Display Students Show all students in a dynamic table. Data must be fetched directly from the SQL database. The table should refresh automatically after every insert or delete. Delete Student Provide a way to delete a student by entering their assigned ID number. After deletion, the database should be updated immediately and the table refreshed. Technical requirements: Use a backend (Node.js / Express or Python Flask or Django — choose one). Use SQL database (MySQL, PostgreSQL, or SQLite). Frontend should be responsive and simple (HTML, CSS, JavaScript). Use asynchronous requests (AJAX/Fetch) for real-time updates. Ensure proper validation of form inputs. Keep the UI clean: table view + form for adding + input field/button for deleting. Bonus (optional): Add search/filter by subject or day. Prevent duplicate entries for the same student at the same time slot. Add confirmation before deleting a student.