Kindly some one help please..
How to make Database dynamic based on user selection in forms laravel
Guys iam going to start a new project School Management System(SMS), which handles the modules such as,
1) student (profile, fee, attendance, marks etc).
2)staff (profile, salary, attendance, etc,login).
3)Parent (login, view student info etc).
.
.
.
.
and so on.
currently i started the student module only. need to complete it before jun 10.
just need to get student info during his admission, and after he was admitted , fee payment should be done , then later after examination his marks to be entered.
now what my doubt is,
the project is for a specific school. so i know the full requirement. so can structure the db based on their requirement.
but what my boss decided is to make the school management system application as a tool which suits for all other different kind of schools.
so for this the structure should be made by the school admin.
say for example consider school1 and school2
the both have different admission procedure.
basically all school will collect student fname, lname, DOB, Dateof joining, parent name, phno, blood group, address, etc.
the above mentioned are basic info that all school will collect.
but other then this, think that, school1 will collect only these info.
but school2 will collect extra more info.
so the form must be flexible for this school1 and school2 also.
that is if school2 needs to add extra field about student, then let them have a add button in form using js additional column will be added, but in db how it could be structured, that it must be flexible for any type of school.
same problem in Fee payment.
school1 has TermFee1->books+tution Fee, TermFee2->books+ tutionfee like this
but school2 have TermFee1->books+tutionFee+ transportFee+LabFee, same for TermFee2 also
so the fee structure also carries for different school.
My application should be flexible for both the school. what should i do for this?
Db is the big problem here. how it varies for different school.
i will also mention the fee structure what i planned. just roughly i planned. is it correct.
Have a form with
class
Name of the Fee
structure (divide) of the name.
Add (button)
so first the school admin need to structure the fee form.
Name of the class: 1st std
Name of the fee: TermFee1
structure (divide) of the name1: Book Fee
structure (divide) of the name2 : Tuition Fee
now structure is defined.
so when admin comes to enter the fee form,
it asks
name of the class: when admin select the class,
then automatically, name of the fee will be filled in drop down: if admin selects TermFee1
then in next two text box it must be labeled with Book fee and Tuition Fee. so when admin enters the fee thte total must be displayed.
this will be different for School2.
so this is what the problem.
the form must be structured based on the school. the admin of the school can structure the form.
but db how it is possible..??
I think all may have experience in such type of application.
so kindly do share your ideas please..
and if possible kindly share any video tutorial link or any other link which helps me a lot please.
kindly everyone suggest your ideas please.
Please or to participate in this conversation.