School Survey project

School Survey project is a software application useful for analyzing statistics of a school performance by comparing various years’ reports. This application is useful for schools to understand performances and improve standards of university or school. This application is a web based application developed in PHP (PHP: Hypertext Preprocessor) programming language using MYSQL database.


Table design for School Survey project:

Table Name: admin

ColumnTypeNull
admin_idint(10)No
admin_namevarchar(20)No
login_idvarchar(25)No
passwordvarchar(20)No
email_idvarchar(20)No
created_atdateNo
last_logindatetimeNo

Table Name: adv_disadv

ColumnTypeNull
sl_noint(10)No
surveynovarchar(25)No
strong_pointtextNo
weak_pointtextNo
lastupdatedatetimeNo

Table Name: gallery

ColumnTypeNull
album_idint(10)No
inst_idint(10)No
album_namevarchar(20)No
datedateNo
timetimeNo
descriptiontextNo

Table Name: infrastructure

ColumnTypeNull
sl_noint(10)No
surveynovarchar(25)No
infrastrutextNo
lastupdatedatetimeNo

Table Name: institute

ColumnTypeNull
inst_idvarchar(25)No
inst_typevarchar(25)No
inst_namevarchar(25)No
addressvarchar(100)No
telephonevarchar(15)No
pincodevarchar(10)No
emailvarchar(25)No
websitevarchar(25)No
area_typevarchar(20)No
total_populationint(10)No
populationcommwisetextNo
year_ofestablvarchar(10)No
school_statusvarchar(20)No
mediumvarchar(20)No
areavarchar(20)No
school_typevarchar(20)No

Table Name: miscdetails

ColumnTypeNull
sl_noint(10)No
surveynovarchar(25)No
lastupdatedatetimeNo
mis_detailstextNo
any_suggestiontextNo

Table Name: payment

ColumnTypeNull
sl_noint(10)No
surveynovarchar(25)No
lastupdatedatetimeNo
pay_detailstextNo

Table Name: problem_faced

ColumnTypeNull
sl_noint(10)No
surveynovarchar(25)No
lastupdatedatetimeNo
administrativetextNo
financialtextNo
infrastextNo
student_needstextNo
resourcestextNo
new_pointtextNo

Table Name: results

ColumnTypeNull
sl_noint(10)No
surveynovarchar(25)No
lastupdatedatetimeNo
semwise_resulttextNo
annual_resulttextNo

Table Name: staff

ColumnTypeNull
sl_noint(10)No
surveynovarchar(25)No
lastupdatedatetimeNo
staff_strengthtextNo
staff_typevarchar(20)No

Table Name: students

ColumnTypeNull
sl_noint(10)No
surveynovarchar(25)No
lastupdatedatetimeNo
sclassvarchar(25)No
sectionsvarchar(20)No
com_strengthtextNo

Table Name: survey

ColumnTypeNull
surveynoint(10)No
inst_idvarchar(25)No
user_idint(10)No
yearvarchar(10)No
lastdatedateNo
statusvarchar(15)No

Table Name: updates

ColumnTypeNull
upda_idint(15)No
titlevarchar(20)No
descrvarchar(500)No
image_pathvarchar(50)No
datedateNo
timetimeNo
typevarchar(20)No

Table Name: upload_data

ColumnTypeNull
slnumint(10)No
album_idint(10)No
file_namevarchar(100)No
file_sizevarchar(100)No
fle_typevarchar(100)No

Table Name: user

ColumnTypeNull
user_idint(10)No
inst_idvarchar(25)No
emp_fnamevarchar(25)No
emp_lnamevarchar(20)No
gendervarchar(10)No
s_emailidvarchar(25)No
passwordvarchar(25)No
created_atdateNo
lastlogindatetimeNo

Download School Survey project Source Code

0.00Add to cart


To View Synopsis of the project:

2 thoughts on “School Survey project”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.