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