Project Title: Pratibha High School System project in ASP.Net & VB.Net.

Environment:  ASP.Net, VB.Net, SQL Server 2000.

Project Description: Pratibha High School System project in ASP.Net & VB.Net is a web-based Final Year information technology school project, which provides complete information about a school like a school name, teacher’s details, student’s details, library information, syllabus & results in information. 

Mainly this project has 3 modules which give details about all departments in a school like a library, laboratory, computer lab, admissions, fee particulars, syllabus, and results.

This project was developed in ASP.Net & VB.Net programming Language using Microsoft Visual Studio and SQL Server used for store the school information.

Developer Role:

1) Architected, designed and developed a three-tier structure for this website

2) Involved in development of the admissions, performance modules.

         SQL Server DataBase Tables  

             Field names  for  “adexam” table

Column name	Data type	Size
Description	Varchar	500
Examname	Varchar	500
Class	Varchar	500
Subject	Varchar	50
[date]	Varchar	500
[time]	Varchar	500

Column name	Data type	Size
Description	Varchar	500
Class	Varchar	15
[section]	Varchar	2
Teachername	Varchar	50
Steacher	Varchar	50
Qualification	Varchar	15
Subject	Varchar	15
Phone	Varchar	20

Column name	Data type	Size
Description	Varchar	800
Totalsys	Varchar	4
Processor	Varchar	50
Harddisk	Varchar	30
Ram	Varchar	50
Os	Varchar	50
Clockspeed	Varchar	10
Monitor	Varchar	50
Software	Varchar	50
Fa1	Varchar	50
Fa2	Varchar	50
Fa3	Varchar	50
Fa4	Varchar	50

              Field names for “adcontact” table

Column name	Data type	Size
Post	Varchar	50
Phone	Varchar	30
Email	Varchar	35

 

 

 

                       

Field names for “adfee”table

Column name	Data type	Size
Description	Varchar	80
Feedate	Varchar	20
Class	Varchar	20
Section1	Varchar	2
Name	Varchar	50
Adnumber	Varchar	10
Generalfee	Varchar	5
Maintainancefee	Varchar	5
Admissionfee	Varchar	5
Due	varchar	5

             Field names for “adfeedetails” table

Column name	Data type	Size
Nursery	Varchar	8
Lkg	Varchar	8
Ukg	Varchar	8
Fclass	Varchar	8
Sclass	Varchar	8
Tclass	Varchar	8
Foclass	Varchar	8
Ficlass	Varchar	8
Siclass	Varchar	8
Seclass	Varchar	8
Eiclass	Varchar	8
Niclass	Varchar	8
Tenclass	Varchar	8
Mnursery	Varchar	8
Mlkg	Varchar	8
Mukg	Varchar	8
M1class	Varchar	8
M2class	Varchar	8
M3class	Varchar	8
M4class	Varchar	8
M5class	Varchar	8
M6class	Varchar	8
M7class	Varchar	8
M8class	Varchar	8
M9class	Varchar	8
M10class	Varchar	8
Af1	Varchar	8
Af2	Varchar	8
Af3	Varchar	8
Af4	Varchar	8
Af5	Varchar	8
Af6	Varchar	8
Af7	Varchar	8
Af8	Varchar	8
Af9	Varchar	8
Af10	Varchar	8
Af11	Varchar	8
Af12	Varchar	8
Af13	Varchar	8

            Field names for “adholi” table

Column name	Data type	Size
[year]	Varchar	5
[month]	Varchar	15
[date]	Char	4
[day]	Varchar	10
Holidays	Varchar	200
Totalno	Varchar	5

            Field names for “adlib” table

Column name	Data type	Size
Class	Varchar	15
Subject	Varchar	15
Bookname	Varchar	50
Bookav	Varchar	5

            Field names for “adlibrary” table

Column name	Data type	Size
Des	Varchar	500
Total	Varchar	5
Eng1	Varchar	20
Eng2	Varchar	20
Eng3	Varchar	20
Eng4	Varchar	20
Tel1	Varchar	20
Tel2	Varchar	20
Tel3	Varchar	20
Tel4	Varchar	20
J1	Varchar	30
J2	Varchar	30
J3	Varchar	30
J4	Varchar	30
Class	Varchar	20
Subject	Varchar	15
Booksav	Varchar	5
Bookname	Varchar	50

             Field names for “admission” table

Column name	Data type	size
Admissionno	Varchar	10
Registationno	Varchar	10
[section]	Varchar	3
Date1	Varchar	20
Name	Varchar	50
Gender	Varchar	8
Date2	Varchar	20
Placeofbirth	Varchar	15
Mothertongue	Varchar	10
Nationality	Varchar	8
Religion	Varchar	10
[cast]	Varchar	6
Castcertificate	Varchar	3
Classjoined	Varchar	10
Firstlang	Varchar	10
Secondlang	Varchar	10
Previousschool	Varchar	20
Previousclass	Varchar	10
Promoted	Varchar	3
Reason	Varchar	200
Tcrsno	Varchar	10
Mole1	Varchar	35
Mole2	Varchar	35
Sports	Varchar	2
Ncc	Varchar	2
Nss	Varchar	2
Cap	Varchar	2
Otheractivity	Varchar	2
Fgname	Varchar	25
Relation	Varchar	10
Mother	Varchar	25
Fatherquali	Varchar	10
Motherquali	Varchar	10
Caddress	Varchar	100
Paddress	Varchar	100
Residence	Varchar	20
Cell	Varchar	20
Email	Varchar	20
Income	Varchar	20
[date]	Varchar	20

Column name	Data type	Size
Name	Varchar	50
Adno	Varchar	10
Class	Varchar	20
[section]	Varchar	2
[1first]	Varchar	5
[1second]	Varchar	5
[1eng]	Varchar	5
[1maths]	Varchar	5
[1science]	Varchar	5
[1social]	Varchar	5
[1comp]	Varchar	5
[1gt]	Varchar	5
[2first]	Varchar	5
[2second]	Varchar	5
[2eng]	Varchar	5
[2maths]	Varchar	5
[2science]	Varchar	5
[2social]	Varchar	5
[2comp]	Varchar	5
[2gt]	Varchar	5
Qfirst	Varchar	5
Qsecond	Varchar	5
Qeng	Varchar	5
Qmaths	Varchar	5
Qscience	Varchar	5
Qsocial	Varchar	5
Qcomp	Varchar	5
Qgt	Varchar	5
[3first]	Varchar	5
[3second]	Varchar	5
[3eng]	Varchar	5
[3maths]	Varchar	5
[3science]	Varchar	5
[3social]	Varchar	5
[3comp]	Varchar	5
[3gt]	Varchar	5
Hfirst	Varchar	5
Hsecond	Varchar	5
Heng	Varchar	5
Hmaths	Varchar	5
Hscience	Varchar	5
Hsocial	Varchar	5
Hcomp	Varchar	5
Hgt	Varchar	5
[4first]	Varchar	5
[4second]	Varchar	5
[4eng]	Varchar	5
[4maths]	Varchar	5
[4science]	Varchar	5
[4social]	Varchar	5
[4comp]	Varchar	5
[4gt]	Varchar	5
Afirst	Varchar	5
Asecond	Varchar	5
Aeng	Varchar	5
Amaths	Varchar	5
Ascience	Varchar	5
Asocial	Varchar	5
Acomp	Varchar	5
Agt	Varchar	5
Workingdays	Varchar	5
Daysattended	Varchar	5
Perattended	Varchar	5
Grade	Varchar	5
Rank	Varchar	3
Percentage	Varchar	8

Column name	Data type	Size
Admno	Varchar	10
Name	Varchar	50
Class	Varchar	20
[section]	Varchar	10
Strength	Varchar	5
Atelugu	Varchar	5
Telugu	Varchar	5
Antelugu	Varchar	5
Ahindi	Varchar	5
Hindi	Varchar	5
Anhindi	Varchar	5
Aenglish	Varchar	5
English	Varchar	5
Anenglish	Varchar	5
Amaths	Varchar	5
Maths	Varchar	5
Anmaths	Varchar	5
Agen	Varchar	5
Gen	Varchar	5
Angen	Varchar	5
Asocial	Varchar	5
Social	Varchar	5
Ansocial	Varchar	5
Com	Varchar	5
Acom	Varchar	5
Ancom	Varchar	5
Rank	Varchar	5
Grade	Varchar	5
Percentage	Varchar	5
Classhighest	Varchar	5
Working	Varchar	5
Attended	Varchar	5
Apercentage	Varchar	5

Column name	Data type	Size
A1	Varchar	25
A2	Varchar	25
A3	Varchar	25
A4	Varchar	25

Genscience	Varchar	50
Gentotal	Varchar	50
Asocial	Varchar	3
Social	Varchar	3
Socialtotal	Varchar	50
Acomputer	Varchar	3
Computer	Varchar	3
Comtotal	Varchar	3
Gtotal	Varchar	3
Rank	Varchar	3
Grade	Varchar	3
Percentage	Varchar	3
Classhighest	Varchar	3
Working	Varchar	50
Attended	Varchar	50
Apercentage	Varchar	50

  Field names for “query” table

Column name	Data type	Size
Name	Varchar	30
Email	Varchar	50
Phone	Varchar	20
Adress	Varchar	150
[date]	Varchar	20
Query	Varchar	200

Column name	Data type	Size
Class	Varchar	15
Telugu	Varchar	800
Hindi	Varchar	800
English	Varchar	800
Maths	Varchar	800
Biology	Varchar	800
Physics	Varchar	800
Chemistry	Varchar	800
Social	Varchar	800
Computer	Varchar	800
Moralscience	Varchar	800

Download Pratibha High School System Final Year project in ASP.Net & VB.Net