Simple Practice CRUD with 7 case studies
First open and login to database
Guest Book
Problem context : Classes often have visitors (parents, alumni, stationery suppliers). It's important to note who's coming, what they need, and their contact information—so you can easily follow up.
Main Flow :
Guests arrive → are recorded.
The homeroom teacher reviews today's guest list.
If there are any typos, correct them.
Invalid entries → delete them.
solution
Create table
Insert data into table
see the result
update and delete data
Daily Activity Agenda
Problem Context: Lots of activities: on duty, studying, sports, competitions. I often forget the time and who's in charge. Keep a simple daily agenda.
Main Flow: Create agenda → view today's list → mark status as complete → correct/delete if necessary.
Solution
Create table and insert data into table
update and delete data
Contact List
Problem Context: Likely to lose friends/parents/dormitor numbers. Create a simple contact book.
Main Flow: Add contact → search contact → update number → delete duplicate.
Solution
Create Table
Insert data into table
see the results
update and delete data
Daily Memorization Notes
Problem Context: Students need to record their memorization notes so that they can see their progress day by day.
Main Flow: Record deposits → see weekly recap → correct if wrong.
Solution
Create table
Insert data into table
See the results
Update and Delete data
Personal Savings Notes
Problem Context: Students want to keep track of small savings (pocket money). A simple in/out transaction table.
Main Flow: Record income/expenses → see the final balance → correct if there are any wrong numbers.
Solution:
Create table
Insert Data Into table, and see the remaining money results
Update and Delete data
t
Classroom Item Loan (Simple Log)
“This single-table version is just a log, not a full inventory system. It's enough to know who borrowed what today.“
Problem Context: The class has equipment (balls, markers, speakers). They're often borrowed but I forget who brought them.
Main Flow: Record borrowing → when returned, update the return column → active borrowing list.
Solution:
Create Table
Insert data into table
Update and Delete data
Simple Assignments/Quizzes (Grade Per Assignment)
Not a report card system; simply record the grade for one assignment/quiz per line.
Problem Context: Teachers want a quick recap of daily quiz scores without the hassle of lots of tables.
Main Flow: Input value → see today's ranking → correct value if written incorrectly.
Solution
Create Table Insert data into table
Update and Delete Data
ERRORS
My error just because of typos and use the ‘
Follow me for more practice
