I've decided to create a database as a personal practice.
The project is based on a fictional English language school called "ESL" located in Japan.
The school has 4 branches in 4 different cities. Whoever wants to join the school has to go through a trial lesson. A person from the staff conducts the trial lesson and a teacher assets the student level. Once the student decided to join the school, they can take lessons. Every lesson is private (one teacher and one student)
I'm not sure about the student table. In my project, both potential students and actual students are present in the table. Would it be better to create 2 different tables?