Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

AbdulBazith's avatar

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.

0 likes
0 replies

Please or to participate in this conversation.