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

Airline Ticket Booking System Project

Airline Ticket Booking System Project was developed by Visual Studio 2003 with C#.net for final year BTech students, Mainly  it has the below functions:

  • Flight Status function
  • Accumulate Mileage function
  • Redeem Mileage function
  • Finding Deals function

 Stimulus:  Flight Status

Click “Flight Status” :

Description:  The customer can use this function to check the status of a flight.

Inputs: Confirmation Number, date, origin and destination.

Source: The input is provided by the user.

Outputs: Date, Departure time, Arrival time, Origin and Destination.

Destination: The outputs are displayed on the screen by retrieving information from the Database.

Requires:  User needs to have a confirmation number while inside the secure website.

Pre-condition: The user is on the website.

Post-condition: The user has viewed the information about flight status and schedule.

Side-effects:  None

Stimulus: Mileage Accumulation

Click “Accumulate Mileage” :

Description: This button allows a user to accumulate mileage that he/she has traveled. Once the user clicks on this button, the current flight mileages adds to the previously traveled mileage.

Input: The data will come from the database

Outputs: User gets the message:” Mileage accumulated successfully”.

Source: The data will be in the database

Pre-Condition: The user should be logged in and traveled recently.

Post-Condition: The miles will be posted to the user’s account in the database

Side-effects: None.

Stimulus: Redeem Mileage

Click “Redeem Mileage” :

Description: After user logs into an account, the function should display a mileage redemption form. This form will have the same fields that exist on the Book a flight page, with the exception that it will display the payment costs in miles instead of other traditional payment methods. 

It will also contain a calendar that shows days that are blacked out from mileage users.

Input: Source station, Destination station, Departure date, Return date, number of travelers, one way and round trip, dates available for rewards travel. For new user, first name, last name, middle name (if any), date of birth, gender, mailing address, billing address, and email

Outputs: User gets the message:” Mileage accumulated successfully”.

Source: The keyboard

Pre-Conditions: The user should be logged in.

Post-Condition: The user will be shown verification information regarding their mileage purchase

Side-effects: None.

 Stimulus: Finding Deals

Click: “Finding Deals”

Description:  This function allows the user to search for deals. The user enters the source, destination, time period that  the user wants to go on a vacation, and the price range.

Input: Scheduled flights on the selected date with origin and destination, class( single/double/), check-in and check-out date and time.        

Outputs: A list of deals satisfying the criteria will be displayed by prices from the lowest to the highest.

Source: All the inputs are provided by the user.

Pre-Condition: The user should be logged in.

Post-Condition: The user has viewed the information about stay schedules  and flight schedule

Side-effects: None.

Posted on

Hotel Management System Project in VB

Hotel Management System Final Year Computer Science Engineering student Project was developed in VB.Net is the front-end & MS Access is the back end. This project has the below modules:

Hotel  Booking Module:

Customers will be able to search through available hotels and costs of rooms. The restaurant search function shall offer users the ability to search for hotels by supplying desired location in the city of destination, desired room size and standard, and the price range.

Once restaurant’s that meet the user’s specifications are located, their location, room sizes and standards and pricing information will be displayed to the user for the user to select the actual restaurant and room he/she desires to lodge in.

This module offers easy access to a number of available restaurant’s and rooms and gives pricing information for each of them.

Flight Booking Module:

The function allows a user to book a flight and a hotel. A user will get a 30% discount of the total if he/she does so. This module offers easy access to a number of available hotels and rooms and available flights and gives pricing information for each of them.

Make Payment Module:
This module allows user to present payment information after choosing a flight or restaurant. It will bring the user to a page in which they can submit payment information. Once they have agreed, their payment will be processed & will be posted to the database.

The customer must pay at the end of the transaction to complete it. For this, they must enter their payment information and provide agreement to be charged. That is what this function provides.

Posted on

Travel Management System Project in C#.Net

Travel Management System Project Offers & Deals:

This Project was developed in C#.Net & SQL Server 2000, By using this project we can book airways, train, bus tickets. Mainly this project can be used in all traveling Agencies.

Customers will be able to browse through available travel deals, discounts and offers and corresponding pricing.

This application provides access to lucrative travel deals and offers and gives pricing information for each of them.

Accumulate Mileage:

This module allows a customer to accumulate mileage that he/she has traveled.

By accumulating mileage, the users have an incentive to fly more. This promotes business on the site and allows the site to compete

with other similar sites that offer mileage accumulation

Redeem Mileage:

This module allows a customer to purchase a plane ticket using the mileages accumulated. 50000 miles can be redeemed for a domestic flight and 75000 for an international flight.

The customer has been given the ability to accumulate mileage as the book flights. They must have a way of spending those miles.

This page will present the controlled environment that is necessary for this type of transaction

Account Update:

The update account information function shall give customers access to edit their information.  They can modify name, mailing address, billing address, credit card information, and login password.

This module offers convenience to the customers by allowing changes to account information immediately.

View Booking Status:

The view booking status function shall allow customers to login into their personal website account to check status of booked flight and hotels

This offers convenience to users so they can find out necessary status information to help them prepare for their travel.

Download Travel Management System Project in C#.Net

Posted on

Interactive Correction and Recommendation for Computer Language Learning and Training

Interactive Correction and Recommendation for Computer Language Learning and Training has the below classification modules:

           1. Authentication module

        2. Theoretical study module

        3. Practical implementation module

        4. Visual study module

       5. Recommendation module

1. Authentication module:-

In this module we need to check the authentication weather the concern person is authorized or not. For that purpose we put user id & password to check the validity. We put the authentication related data on to the database when user want to log in it check with database if matching takes place then only the concern person will use the functionality.

2. Theoretical study module

In this module, user needs to study the text document. For that purpose user must be an authenticated one. We have no of documents based on sqlserver. User need to study required documents for implements the ideas as well as to generate some knowledge regarding the database software.

3. Practical implementation module

In this module use need to implement the ideas generated by reading the theory. For that purpose we need the concern software in general. Here itself we programmatically call the concern software so that user can practice & implement the theory.

4. Visual study module

In this module user can visualize some video as well as user can hear some audio file so that he can get some more knowledge regarding sql server.

5. Recommendation module

Here itself some artificial intelligence will added so at the time of practice if some error occur some recommendation comes into picture ,how to rectify that particular mistake.

Hardware Specification:

Processor                  :  PENTIUM IV

Ram  Size                      : 1 GB

Hard disk drive         : 40GB

Software Specification:

Front End                            :  vb.net

OS            :  Windows Vista

Server                              : Sql Server 2005

Posted on

Java Project on Resource Planner

Java Project On Resource Planner software aids the company management not to waste the resources and plan the projects and employees time to time.

When a software development company wants to achieve its goals on time and efficiently use its staff on the projects, it is necessary for the company to have hands on information related to number of employees working on various projects along with their skill set and the number of employees still needed to complete the projects on time. Resource Planner is a convenient tool to handle various projects in a software company efficiently.Resource Planner is an online tool to manage projects currently running with the company as well as future projects.

This is an online tool so more than one user can login into system and use the tool simultaneously. The administrator of this software will be able to create new users and remove any user. He allots passwords and changes them. He can view the details of all employees in the company. 

HR manager should take a decision regarding whether to recruit any employees and whether there is dearth of any resources in a project. The project manager can view the details of the employees in the company and the employees in his projects. He can also get the information of how many employees are there in a particular project and their skill set. When he wants employees for a particular project, he can add that information mentioning how many are working on the project and how many employees are totally needed for the project. This information can be had both for online and offline projects. This information is used in generating a special report called GAP summary.

Conclusion:

The entire project has been developed and deployed as per the requirements stated by the user, it is found to be bug free as per the testing standards that are implemented.  It helps HR people and Project managers of the organization and provides effective communication between them to utilize the resources very promptly with proper planning.The system at present does not take care off collecting the resources as resource which was already implemented earlier. This system was integrated with resourcepool in the production environment to actually get the real info about the resources.

download  Java Project On Resource Planner Project Report.

Posted on

Gas Agency System ASP.NET, C#, SQL Server Project With Code

INTRODUCTION & OBJECTIVE

    Providing the facility to the users (Consumers) that can make online bookings for gas cylinder to concerned distributor or agency

PROBLEMS EXISTING SYSTEM

    Through this existing  consumer unable to make online gas booking. For gas booking he has to make a cal to distributor and book the gas on. Data has located in single system. Making online request is not possible in existing system. Online requests are like gas booking request and connection transfer request. For maintain the large data not possible with the existing system. More physical interaction needed.

GasAgencySystem

Changes have to be made before executing the project

1. Copy the given project folder in your system.
2. Right click on the folder, select the properties and click on web sharing tab
3. Click on share this folder in the following screen

GasAgencySystem4. Select Write, Script source access and Directory browsing GasAgencySystem1

5. Click on ok and then Apply
6. Open web.config file from project folder and change ConnectionString parameters like
•    Database/Initial catalog
•    U id/User id
•    Pwd/Password
•    Data source
8. Then save the web.config file

Download Gas Agency System ASP.NET, C#, SQL Server Project With Code.

Posted on

Social Networking Site Buddy Manager PHP CSE Final Year Project

 BUDDY MANAGER

This PHP Final Year project can be developed by maintain the list and details of your friends.

This can be maintain all the user’s details who are registered in to buddy manager and provides the list to others for establishing the friendship to new users. This project is developed for making the friends.

The important modules are

  • NEW
  • SAVE
  • DELETE
  • MODIFY
  • SEARCH
  • RELOAD
  • PRINT

NEW: This function deals with the new user to get the detailed information and get the avatar also.

SAVE: This function deals with just saves the user’s information which is provided by the user into the database.

DELETE: This function deals with delete the user’s information permanently from the database which is existing in the database

MODIFY:This function deals with the data base for updating the user’s information which has been given by the user and made the modifications into the data base and keep the data into the database which gets the recently updations 

SEARCH: This function is used for search the user and get the user’s information from the database based on search methods with specified column details regarding the user.

RELOAD:This function is used for reloading the web page.

PRINT : This function gives the option for printing the current web page.

Software and Hardware Requirements

 Software Requirements:

Operating System : Windows 2000/xp/Vista

Front End Software :  MacroMedia

Database : MYSQL

Backend Language : PHP

Hardware Requirements:

Processor : Pentium 4.0(1.6 GHz) and Higher

Memory :  512 MB

Hard Disk : 80 GB

Download Social Networking Site Buddy Manager PHP CSE Final Year Project

Posted on

Picture Album CSE Project On ASP.Net & SQL

The Picture Album CSE Project mainly deals with storing the photos/images in a local system its nothing but a desktop project. It stores the images in a specified location user can see the images through the browser in a slide show.

This project mainly has the three modules in the name of steps like step1, step2, step3 respectively.

  • In step1 it deals with the select the folder in which you have photos or    images.
  • In step2 it deals with for generate the album and preview.
  • In step3 it deals for save the album in appropriate location.

Using this project user can store the photos by giving a specific name and title to your album so that user can store images like personal, professional etc. in different names.

After storing images into a local system user can generate photos automatically in a different order.

 Software and Hardware Requirements

 Software Requirements:

Operating System : Windows 2000/xp/Vista

Front End Software :  Microsoft Visual studio 2005

Database: Microsoft SQL Server 2005

Backend Language : ASP.Net

Hardware Requirements:

Processor : Pentium 4.0(1.6 GHz) and Higher

Memory :  512 MB

Hard Disk : 20 GB

Download Picture Album CSE Project On ASP.Net & SQL

Posted on

Email Address Verification System C# & SQL Final Year Project

Personalized mail distribution through SMTP is used to send bulk emails. This project uses SMTP protocol to send emails. Here, we can send email for more than one person at a time. In customized mailing system, we can send emails to a particular person by using the search engine administrator can search the email address.Here, we use intra search engine to search for the email address of a person. Even we can use HTML format also for sending mails. If we have the ads or information in HTML file format, we can copy that HTML codes and post here along with the images also. At anytime, we can get soft copy and hard copy backup also. We can customize the soft copy backup as either xls file or text file format.

Software and Hardware Requirements

 Software Requirements:

Operating System : XP

Front End Software :  Visual studio 2005

Database : SQL Server 2005

Hardware Requirements:

Processor : Pentium 4.0(1.6 GHz)

Memory :  256 MB RAM

Hard Disk : 80 GB

Download Email Address Verification System C# & SQL Final Year Project

Posted on

Library Management System CSE Dot Net & SQL Project

LIBRARY MANAGEMENT

Generally in libraries such as college library, public library, there exist various functions. The head of the library (Librarian) controls all the functions. Students, Faculty, including teaching and non teaching staff, clerks etc are the members in the Library.                       

All the members of the library have some right to use the facility of library depending upon the category. They can issue books, return the books, search for particular one etc. These surveys will be helpful in improving the functionality of the library.

PROBLEMS IN EXISTING SYSTEM:

  • Existing System was manual. Manual System was very time consuming.
  • Processes like Searching for Book, checking for availability for a particular book, takes much time.
  • It is difficult to maintain records of issued books, returned book.  
  • Addition and deletion of members, books need lot of maintenance.

PURPOSE OF THE PROJECT

This project is aimed at developing a Library Management System that is of importance to either college library or public library. All the members of the library are legally the users of the System. The Administrator can add new members, books and also he can create new category for members and books. Here we computerized the existing manual system.

Software and Hardware Requirements

 Software Requirements:

Operating System : Windows XP

Front End Software       :  Microsoft Visual studio

Database              :    Microsoft SQL Server

Hardware Requirements:

Processor             : Pentium 4.0(1.6 GHz) and Higher

Memory               :  512 MB

Hard Disk            : 10 GB

Download Libarary Management System CSE Dot Net & SQL Project