a user has to access multiple class, section, subject. table structure and form design in laravel
Guys iam working with a project. its a school project.
i have 3 separate table, grade, section and subject.
now iam going to create teacher. one teacher can access multiple grade, multiple section, and multiple subject.
so what i planned is to have 2 tables. teacher_personal table and teacher_official table.
teacher_personal table
phno,
email id,
address
status
desc
teacher_official table
teacher_id (from teacher_personal table)
grade_id
section_id
subject_id
is the above format is correct?
then if a single teacher need to access 3 grade, 3 section, and 4 subject means
in teacher_official table there will be 10 records for a single teacher?? is this correct?
But if a class, section and subject is assigned to one teacher means it will not be assigned to another teacher. its a kind of one to many relationship
iam confused with table structure. and form design.
kindly some one suggest your opinion.
Please or to participate in this conversation.