There are three types of users. Admin, student and supervisor.
Admin has LoginId and password.
student has LoginId, password, email and enrolID
Supervisor has name, LoginId and password.
Now the following DB Schema I have designed.
Role (Id, Name)
User (id, RoleId)
Student(Id,UserId, enrolId, email)
Is the above Schema is correct or not?? Plz help me thank you
My question was whether a person can be both a student and an administrator, or a an admin and a supervisor, or a supervisor and a student, simultaneously.
For instance, if an administrator decides to enroll in a class, would they have both roles?
If it's not practically useful, then it's practically useless.