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

ATM WEB Reporter Using JEE (WEB) Technology Follows MVC and DAO Designing pattern

Academic Project (Industrial project) :

Project Title: ATM WEB Reporter Using JEE (WEB) Technology Follows MVC and DAO Designing pattern

Project Description:  The project titled ‘ATM Web Reporter’ is a simulation of ATM log tracing application. 

The present-day trend leaves no space to any sector from spacing from the advanced technology adaptation. As a result, we find almost all banks depending a lot on the ATM centers and situating them at all possible corners of the city in and around. In this scenario, it is difficult to maintain the ATMs, and checking them manually.

Thus we propose this solution. The present project is all about generating graphical analysis report of various operations to be done the atm machines.

The present engine is connected to a simulation database of atm operation logs and using these logs the web reporter generates various graphs on various operations and downtime and uptimes of the ATM machine.

This allows the bank authorities to monitor the frequency of transactions per atm and helps them to keep the condition and in increasing or decreasing their number.

The present project is developed in web interfaces, allowing the bank authorities to view the reports where ever they are in the most customizable colors and variations, through a secure login account.

  • Architecture Of the Atm Web Reporter:

This project uses JEE(WEB) Technology to build the interface. Managed Beans talk to DAO (Data Access Objects), which talk to the database using JDBC.

So overall architecture is – JEE Components -> Managed Beans -> DAO -> JDBC -> Oracle Database. It also uses a filter (Intercepting Filter design pattern) to ensure only authenticated users access secured pages.

 Software Requirements

  • Operating system:     Windows 2000 /XP or later
  • Front End Software:       Java
  • Back End Software:      SQL – SERVER
  • Servers:       Tomcat Server  6.0

ATM WEB Reporter Using JEE (WEB) Technology Follows MVC and DAO Designing pattern.

Posted on

Kerberos Authentication Protocol

  Project Title: Kerberos Authentication Protocol

 Technologies:  HTML, CSS, JavaScript, Core PHP, MySql,  WAMP Server, Adobe Dreamweaver,  Multimedia tools (Xara WebStyle4)

Developer Role: Programmer

Project Description:  This Kerberos authentication protocol will provide a much secure network free from trapping and sniffing as an unauthenticated user like hackers would not be able to access the LAN network by any attempt like trapping or hacking as all his effort would be futile, which will result in a secure LAN with an efficient use of LAN bandwidth and all other factor related to LAN. 

This Project was developed by Using open source PHP & MYSQL.

Download Kerberos Authentication Protocol Reference documents

Posted on

Blood Donor Agent Mini Project in Java

Mini Project: Blood Donor Agent Mini Project in Java

Tools & Technologies : JAVA,SQL SERVER 2000

Description: Blood Donor Agent System is a web application intended to create e-information about the donor and organization that are related to the donation of blood.

This project tracks the status of user’s application by proper utilization of different tools in a transparent way.

This application has different features like any user can search needed blood group here all donors have to submit their contact number & email address.

This project was well designed & tested with Java Programming & SQL Server.

Blood Donor Agent Mini Project in Java

Posted on

Custody Transaction Management System .Net Project

Custody Transaction Management System is a capital market based web application developed with VB under .Net Technologies. CTMS is a final year computer science project which performs various functionalities like Instruction Management, Grid Management, Reporting, Settlement date, Agent deadline date, etc.

 CTMS is the application which is useful for the costumers to instruct their instructions Online. CTMS purely depends on the Corporate Action and sends messages by online. Corporate action is an action announced by a company based upon their company annual growth which affects their shareholders positively or negatively.

 By using this project with VB to .Net to increase the efficiency of the application for their users. In this new application the users can able to access the application much faster than that of the application in VB. The functionalities remain same in both the VB and .Net applications.

Developer Responsibilities:

  • Preparing Test cases, reviewing the Test cases and executing those Test cases without bugs.
  • Functional, System and Regression testing for every iteration and delivering to onsite.
  • Guide the team for working on the deliverables and sending those deliverables timely to onsite for review.
  • Communicating with Project Manager & all team members across the locations.
  • Conducting weekly offshore and onsite meeting discuss the issues and concerns of the modules.
  • Database Validation to check the updated data in the SQL Server Database.
Posted on

The Effect of Pairs in Program Design Tasks .Net Project

Description:  The Effect of Pairs in Program Design Tasks paper explains about concept of pair programming in software development and its positive side and negative side in developing a software application. 

In this paper, we will explain different methods for analyzing standards of pair programming.

This project is implemented using Dot Net technology and database is SQL Server 2000.

The main aim of my project is to create a website to find accurate team members of an organization by calculating the same wavelength of the brain power of the employees of the organization.

Pair programming is a concept where a team of two members works on the single project, one will work on implementing coding and algorithm and other will look after the way the work is moving and analyze the mistakes while programming.

The effect of pairs in the program design tasks projects reference document.

Posted on

Toll Plaza Management system

  • Project Title: Toll Plaza Management
  • Software Requirements:.Net (C#.Net, ASP.Net & ADO)

PROJECT DESCRIPTION

Toll Plaza Management system is a web-based application that can provide all the information related to toll plazas and the passenger checks in either online or on a mobile device and pays the amount, then he/she will be provided by a receipt.

With this receipt, he/she can leave the toll booth without waiting for any verification call. This application can be chosen for the final year students; this project was coded & well developed with .Net Technology using ADO connectivity.

Posted on

Travel Agency Website using ASP.Net & SQL Server

Project Title / Name:   Travel Agency Website using ASP.Net & SQL Server
Software / Tools / Technology Used:    ASP.Net, Sql Server

Project Description

The main aim of the Travel Agency Website using ASP.Net & SQL Server final year Computer Science & Engineering Student project was to develop a travelling related website for a popular Travel Agency.

The Travel Agency company requires a online website that reach customers easily.

The online web application website has to satisfy all types of customer needs without wasting time.

This  Travel website was developed by ASP.Net & SQL Server database.

Travel Agency Website using ASP.Net & SQL Server Project Report & Paper Presentation.

Posted on

News Paper Management System Abstract

Project Title: News Paper Management System Abstract

Technology: ASP.Net.

Database Server: SQL Server 2005.

Tools: Visual Studio.Net, IIS Server.

Contribution: Database designing using SQL, Involved in ASP.Net coding,JavaScript coding

Project Description: News Paper Management System Project is developed by ASP.Net & SQL Server 2005 under Microsoft Visual Studio & IIS Server. By Using this project admin can post news updates every day to the server and users can see the news posts, This can be also available For the people who can also read the news in their mother tongue like Telugu, Tamil, Hindi, English, etc.  

Developer Roles & Responsibilities:

  • ·Involved in Designing of front end and back end applications.
  • ·Involved in ASP.NET coding.
Posted on

Shopping Cart in ASP.Net Project

Project Title: Shopping Cart in ASP.Net Project.

Technology: Asp.Net

Database: Sql Server 2005

Contribution: Database designing, Involved in ASP.Net coding, Java script coding, SQL Server Reporting Services, HTML Coding.

Description: 

The Shopping Cart in ASP.Net project is aimed at automating Shopping mall activities and aiming at paperless operation,

This application starting from user purchasing the product till the delivery of selected products covering all the administrative tasks, like online Shopping cart, order tracking, show status, order confirmation, pay pal and shopping mall activities like new products like food items, clothes, mobiles, computers, shoes, new launches, etc. sending emails to users, model price list, updating status of user etc., are to mention a few.

Roles & Responsibilities:

  • ·Involved in Designing of front-end using HTML and back-end applications using SQL.
  • ·Involved in ASP.NET coding.
  • ·Involved in creating Database Reports.
Posted on

E – Commerce Portal ASP.Net Project

E-Commerce

Electronic Commerce is the process of doing business through the Internet. A person can have the access to buy the products online by sitting in a chair in his home. With this system, we can reduce the physical work of the person i.e buying the goods online.
In this system, we need not work physically to buy the goods. Here the person can access all the types of information about quality, price, rating, discounts, and warranty.

Everyone can also check the review before purchasing a product. The person who wants to buy a product can visit two/or three websites to check the price, rating, and discounts. Here in this system we can update, delete and modify the information.

In the E-Commerce system, we have the feedback form about the products and also have a login page to get into the website. So, this system is very useful for everyone so that they can save their money and time by purchasing online.

Project Title: E-Commerce Portal ASP.Net Project

Project Technology: ASP.Net (Three Tyre Architecture), Ajax

Database  Server:  SQL Server 2005

Tools Required: .Net3.5, SqlServer Reporting, LINQ, Webservices.

Developer Roles: Database designing, Involved in coding, Javascript coding, SSRS.

Project Description:

E-Commerce Portal ASP.Net Project developed for final year computer science & Engineering branch students is mainly an e-commerce web portal involving four main modules 

1) Movies & Reviews module,

2) politics & gossips module,

3) Classifieds module,

4) Connections and Hot deals module.

This project can be used as a worldwide e-business portal where any personal & Professional Ad can be posted with almost easy ( free ads & paid ads). Here We can post a restricted number of free ads.

The developer was involved in coding with ASP.Net, database designing with SQL Server, maintenance & execution. Also worked on new design enhancements to the website. Coming to classifieds module Integrated PayPal and SMS interface was enabled.

In classifieds, any user can search and post the ads accordingly either location wise or category wise. First users want to post their ads they should register through the registration form.

Here We can have exclusively created hot deals & Connections module which gives detailed information about all types of electronics goods & computer hardware.

Roles & Responsibilities:

  • ·Involved in Designing of the front end and back end applications using HTML, JavaScript, ASP.Net & SQL Server.
  • ·Developed Credit card, Debit Card And PayPal Integration.