how to get academic year as session in laravel project

Guys have started a new project School Management System.

i have already asked 2 questions related to this. but no one answered. its my mistake only, without any knowledge i just simply asked the question. now i have framed the table structure, so i am asking, kindly correct my errors.

these are my old questions:

1)https://laracasts.com/discuss/channels/laravel/problem-in-table-structure-for-fees-structure-in-school-project

2) https://laracasts.com/discuss/channels/laravel/how-to-make-form-and-db-as-dynamic-based-on-user-requirement-in-laravel

3)https://laracasts.com/discuss/channels/laravel/how-to-make-database-dynamic-based-on-user-selection-in-forms-laravel

i had a form design and table schema design.

let me explain it. kindly guys give your suggestion and correct me please.

let me explain the requirement first.

the project is for a school to manage the students info, staff info, class info, mark info, fee structure etc.

first module i started in student module.

add the new admitted student.

but before adding the new admitted student i need the academic year info, and class and section info.

so what i planned is,

a form to add academic year which has controls like academic year, and note

i have a table academic_year with columns

id      acc_year            note                status

1       2019-2020       current year            active

like the above i will add the academic year details. is this right??

next after adding years, i need to add class and section details, so for that what i have is

a form to add a class with multiple section. that is the below is my form,

academic year: 2019-2020 (drop down from acc_year table)

class: Vth std

section1:A

section2:B

section3:C
.
.
.
section n:N


for this i have a button to add next next textbox for sections.

for the above i have two tables class and sections.

my class table with columns

id      acc_year_id(fk)     class           note        status
1       1                   Vth std         fifth std       active

my section table with columns

id      acc_year_id(fk)     class_id(fk)        section_name        note        status
1       1                   1               A                   A section   active

Refer:https://imgur.com/eFKBxbk (Refer this image for academic year class and section information form and table)

is this format is right?? here i have a problem, i need the academic year for the class and section. so i have that column in all form and in all table. Is this right else can i use it in one place?? if one place means where?

next iam going to add the students details.

so i have different types of forms like,academic details, personal details,contact details, parents details, sibling details, previous qualification details, medical history etc

first academic details form with controls

academic year: 2019-2020 (drop down from year table)

admission no: A101

admin date:10-07-2019

class: Vth std (drop down from class table)

section: A section (drop down from section table)

student Name: Abdul Bazith

hosteler/ dayscholar: dayscholar

status: active

for the above form i have table student_academic_info table with columns

id
acc_year_id
admission_no
admin_date
class
section
stud_name
hosteller_or_dayscholar
status

for personal information i have form

Gender: Male

DOB: 15-08-2009

Nationality:Indian
    
religion: Muslim

Mother tongue: Tamil

and had the personal_info table with columns

id
student_id(fk from student_academic table)
gender
dob
nationality
religion
mother_tongue

like this for parents-details, siblings detaisl etc i have done.

is this right??

for each time i should not choose the academic year for entering a student info. once i choose the academic year(2019-2020) means till my next change it must be in the session.

How to do this??

i have institution form also with controls

Institution name: ABC school
address: 42 west street, india
code: II001
logo:

i have roughly made a pencil sketch for student info is this right: https://imgur.com/MZm3OKx ( just a rough sketch)

for this i have a table institution_details with the same column as form.

now my biggest doubt is users table.

the institution has many users, accountant(handle only fee details), admin(add, employee etc), super_admin(all), staff(add student mark etc), parent(can view student info),

now when adding the student admission details itself, the mobile number fo parent is added. that will be the username and password for that parent. parent can change their password later.

while creating the student admission, the mobile number is given as username and password, and the it is shared to the parent.

i was so confused about this. Kindly some one help please. if possible share any links please.

My doubt is about

1. Academic year need in all form and table else how?
2. student info 3)users table