Category: SQL Server Projects

Engineering computer science students who are looking for SQL Database Server 2005, 2008 projects for beginners and can download sample SQL projects with source code and report for free. Download All Latest SQL Database Projects, SQL Projects Ideas, SQL Presentations & PPT’s Here.

Posted on

Pratibha High School System project in ASP.Net & VB.Net

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

Posted on

Simulative CBT Examination With Random Paper Generation

Project Title:    Simulative CBT Examination With Random Paper Generation

The Simulative Computer-Based Testing (CBT) Examination With Random Paper Generation system provides a online testing platform to the users on which Exam questions are keyed into question bank, organize questions randomly and sequence manner, prepare question paper automatically, conduct online test, evaluate results and display score papers. It affords an online practicing platform for students where they can participate in simulative examination in which questions are randomized, provided a realistic examination environment for students. It appraises the candidate’s knowledge on the prepared stream for computerized e-examination.

The online practice test is being conducted based on candidate’s preference in different parameters such as question difficulty level like difficult mode, intermediate mode & easy mode, Subject topic and number of questions to be appeared. The portable document file could also be created with the candidate’s preferred parameters. After completion of their exam students can have an option to take a print and they can send these results to mail address. This Project was developed under Net beans IDE 5.0 Java Programming & MYSQL Database Server. This project can be worked under Linux Operating System & Windows operating System, Distribute Memory method and concurrent Access method used in this project.

Posted on

Human Resource Information System Final Year project

 Minor Project Title : Human Resource Information System

  • Technology:  VB.NET, SQL Server 2005.
  • Editor:  Visual Studio 2005.
  • Team Size:   1
  • Module:  Employee Information, Payroll System, Unique Id creation For Employees.  

This is a Human Resource Information System Final Year project for an organisation who can encapsulate whole department of Organisation like Payroll system, Employee Information System, Account department in a single software etc. This project was developed using VB.Net Programming under Visual Studio 2005 tool. SQL Server 2005 used as a database server to store all employee details. This Computer Science & Engineering Final year mini project has 4 major modules Employee information module, payroll system module, and unique id creation module for employees. Employee information module contains the all employee details like personal details, professional details. Payroll System module contains salary related & income tax related details. Unique Id creation module has a feature to all users/employees to create their unique user id.

Posted on

Distributing And Monitoring The Process In A Network MCA Project

The Distributing And Monitoring The Process In A Network MCA Project is capable of allocating processes to various processors in the network. The Final Year MCA Project is designed using Microsoft Visual Studio.Net 2003 as front end and Microsoft SQL Server 2005 as back end, coding language used is C# .Net & ASP.Net, HTML & Java Script used for web page development.

The main project aims at distributing the processes to various machines processors in the network. It contains both server side applications and client side applications.

Posted on

Online Education System MCA Java Project

Project Detail (MCA Final Year)

Project Name: Online Education System MCA Java Project
Duration: 3 Months
Project Members: 4
Role: Developer

Project Description:

The main objective of developing this Online Education System MCA Java Project is to create a web application to help the end users having very limited time to continue their education (due to a part-time job or people belonging to a remote area). 

This CSE Final Year project provides online certification course according to the candidate qualification.

Responsibilities:

This project was developed in Servlet, JSP,  JDBC to get the request from a user using Servlet and send a response to the user by JSP. 

Analyzing Functional Specification document, designing and developing Java code using Eclipse IDE, unit testing, executing test cases, deploying and testing.

Download Online Education System MCA Java Project.

Posted on

College Website Project in ASP.Net

  Project Title: “College Website Project in ASP.Net”

  Team Size: 3 Members

Programming Language: C# .Net & ASP.Net

Back End Server: SQL Server2005

Description:

The Aim of this College Website Project in ASP.Net is to implement the website for the school, college; the purpose of this final year computer science and information technology project is to provide the clarified information about college to the users (Students, Parents, and Anonymous users) through website and provide the information about students like class, roll number and results for Existing students of all semesters. This project was developed under ASP.Net & C#.Net Programming language using Visual studio and SQL Server 2005 used for storing the data.

Developer Responsibilities: 

-Understanding the business requirements from basic level and converting into solutions.

-Created database using SQLServer2005.

-Implementation of Front End Using ASP.NET & C#.Net under Visual Studio 2010.

-Maintain the connection Between Frontend and Backend Using ADO.NET

Posted on

Personal Identity Management final year CSE project

This is a Personal Identity Management final year CSE project website which is used to store Personal information like passwords, credit card information and important documents. 

Only authorized or registered users can login into the system and they can store the data. Something like a personal data vault.

Nowadays to access any site we have to provide username and password, for remember different sites our personal usernames and passwords is very difficult to remember all those and we may forget a lot of times these credentials.

Then we have to register once again with new login id or we have to recover our previous password.

For avoiding these types of problems we have implemented a new application where this site provides a solution, in this site you can store the passwords and login names of all of your social networking sites like Yahoo, Orkut, Facebook, LinkedIn, MySpace, google plus, etc.

If we forget our usernames or passwords in future we have a chance to collect the username and passwords from this website application.

This project was developed in visual studio 2010 tool and Microsoft.Net is the front end programming language, SQL Server 2008 is the back end to store the personal details of different users.

Download Personal Identity Management ASP.Net final year project full documentation and source code.

Posted on

Rate Allocation and Network Lifetime problems For Wireless Sensor Networks

Project Title: Rate Allocation and Network Lifetime problems For Wireless Sensor Networks

Project Description: Nowadays Wireless sensor networks containing huge battery-powered nodes that are covered with altitude of sensing modalities including multi-media sensors and scalar data sensors. Although there have been significant changes, improvements and enhancements in micro processor design and computing, advances in battery technology still lag behind, making energy resource considerations the fundamental challenge in wireless sensor networks. This Rate Allocation and Network Lifetime problems For Wireless Sensor Networks Final Year ECE Project can solve the above problem. The sum of rates of all the nodes in the network can lead to a severe bias in rate allocation among the nodes we advocate the use of lexicographical max-min (LMM) rate allocation.

Download Rate Allocation & Network Lifetime Problem for Wireless Sensor Networks .Net Project, Abstract, Synopsis, Documentation, Paper presentation, ppt, SQL Database.

Posted on

Online Index Recommendations for High Dimensional Databases Using Query Workloads

Online Index Recommendations for High Dimensional Databases Using Query Workloads projects main idea is to provide solution for problems caused from using lower dimensional indexes using a parametreizable method for specified indexes based on index types which are mainly used in high dimensional data sets and to use a dynamic method for auto changing of indexes as work load changes. In general users use small set of attributes for searching data at a time. In order to accurately represent access patters it is better to use low dimensional indexes. The problem with this query process is when query patterns changes performance of database changes because in physical database design workload will decrease. 

Existing System:

  • In existing system performance of query response is slow if there is any pattern change.
  • This problem arise because of using static query workload.
  • Performance of the system depends on the size of database.
  • There is no data pruning capability available in this system.
Posted on

Library Automation over Network .Net Project

Project Title    :    Library Automation over Network .Net Project
Software / Tools    :    ASP, ASP.NET with C#, HTML, AJAX, Visual Studio 2010, SQL Server 2005
Duration    :    3 Months
Project Description: Library automation over network .Net Final Year Application is actually a web based product developed under ASP, AJAX, ASP.Net, C#.Net, Java Script, HTML, DHTML and SQL Server 2005 Database. Online solution for LIBRARY MANAGEMENT is provided based on the Base product with many additional features and new technologies especially effective utilization of AJAX & SHAREPOINT. We are heading the Main modules like desining in LAN. We have got good exposure and good knowledge of the LAN.

Developer Roles & Responsibilities:
•    Responsible for fixing Design issues & Infragistics control issues.    
•    Responsible for Design & Development.
•    Responsible for Testing & Maintenance.
•    Designed a database for use in development of a control data set.  Environment: Sql Server 2005
•    Programmed in C# with AJAX, ASP.Net, ASP Scripting Language, Sql Server 2005, and HTML.