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 |
Field names for “adclassteacher” table
| 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 |
Field names for “adcomputer” table
| 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 |
Field names for “adprogress” table
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 |
Field names for “adresult” table
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 |
Field names for “adsports” table
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 |
Field names for “syllabus” table
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