Adding data in pivot table with array structure in form

@abdulbazith I think it would be easier for you if you just create a basic blog project first just to get used to the database relationships. Look into the "belongsToMany" relationship in laravel documentation and try understand how that works. Your form is wrong. You need to have topic linked to chapter AND the chapter to a subject so once you add chapter_id in your form you don't really need the subject_id because you have access to it through the chapter already. You associate the class with the topic with a pivot table and that is being done backend after you created the topic.

@mironmg thank you. i understood what you say.

but as a end user he/she may not have any knowledge about class or subject or topics. he is just a data entry operator

so when he come in the application first he will enter all the class through a single form. then he will enter all the subjects through a single form. then he will add chapters

the chapter form looks like this

Subject_id (dropdown)

chapter1
chapter2... so on

here he will choose a specific subject and then he will enter all the chapters in a single click.

Next when it comes to topic you are saying that chapter and subject has relationship so there is no need of subject field in the form. but what iam saying is,

he dont know anything. so he must enter a topic so what he will do,

hee will choose to which class he is gng to enter, then he will choose, which subject, then based on the subject the chapters will be listed (for example if he choose maths then that particular chapters will be listed) listed in the chapter field, then he need to choose that specific chapter and then he is going to enter all the topics.

as you said, if i remove the subject field means, then all the chapters will be listed in the chapter field. i need to sort out. the is just given a paper when for specific subject for specific chapter these are the topics.

am i right??? dont hesitate to reply please.. if am wrong kindly correct me.

i will say my objective of the project.

this is a online examination.

step1: need to add question with answers.

step 2: creating assessment with the stored questions

step 3: students need to write exams

step 4: making different kind of reports with students mark

step1: need to add question

Before adding question i need the following. for which class, for which subject, for which chapter, for which topic this question belongs to.

so this is my plan,

Add Class - > this has a form and a table to add classes(1st std, 2nd std, 3rd std ... so on)

Add Subject -> this has a form and a table (Maths english , chemistry, english)

Add Chapters-> has a form and table. for specific subject those chapters belong to (one to many relationship one subject many chapters)

add Topics -> this has a form and table. for specific chapter these topics belongs to (one to many relationship. one chapter can have many topics)

now i need to add the question, i have a question form where the form has controls such as asking about which class, which subject,which chapter, which topic, which level.

so i planned to have my question table like this

id
class_id   (fk)
subject_id (fk)
chapter_id (fk)
topic_id (fk)
level (easy,medium,hard)
question_number
question_description
question_image(optional)
optionA:
optionA_image:(optional)
optionB:
optionB_image:(optional)
optionC:
optionC_image:(optional)
optionD:
optionD_image:(optional)
correctanswer
explanation
explanation_image (optional)
explanation_pdf (optional)
explanation-video(optional)

so totally 5 forms adding-class, adding-subject, adding-chapter, adding-topic, adding-question

totally five tables class-table, subject-table, chapter -table, topic-table, question-table

everything is a one to many relationship. each subject has many chapters, each chapter have many topics.

the class and subject can be many to many relationship, because a class belongs to many subject, and a subject belongs to many class.

is these forms and tables ok. else do i need to reduce my forms and tables???

is this right???? Kindly suggest. i said everything.

when i googled it, i got whatever expected. but the problem is they gave only topics. no subject, no class, no chapters..

Kindly suggest please

@snapey @BOBBYBOUWMANN @mironmg