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

A Project on Medical Shop Management

This web application project is mainly developed for medical shop management related to managing the medical stock and transactions of the business.

This A Project on Medical Shop Management solution will help the medical shop owner to automate all important activities. The main modules covered in this project are:

Medicine information module, transactions information module, sales module, purchase module, personal information management module, supplier module, and customer detail information module.

Refer to:

Download the complete project on Medical Shop Management System in Java & Oracle database using AWT and Swing with ODBC

Posted on

Daily Activities Software System Java Project

  • Mini Project Title: Daily Activities Software System Java Project
  • Technologies Involved: HTML, JAVA, Web logic server, and SQL 2005

Project Description:   The final year software project Daily Activities Software System has implemented on java technologies using web logic server and SQL server database. This software application explains about the staff is responsible for recording the day-to-day activities and may incur losses if not managed properly. The company knows the importance of maintaining quality work   at the workplace.  In the previous related projects many  companies   are using  manual  process  to  record the  topics  covered  in  the classroom. It also record number of classes attended, duration and work load calculation for a week, etc. Sometimes despite of maintaining all records they may fail to produce the output being expected. The reason might be related to mismanagement and wrong handling the data. The implemented software application system is to develop daily activities software system (DASS) which records staff’s activities easily and effectively. It measures the day  to day activities of  the  staff and enables  the  head of  the department(HOD)  to have a glance on their  daily  activities. The proposed system provides communication with the staff regarding various activities in the department. DASS reduces the complexity to simple, secure and more reliable. This project is mainly useful for colleges and schools.

Posted on

Donor Management System ASP.net Project

  • Project Title :         Donor Management System ASP.net Project
  • Project Environment: ASP. Net(3.5), Microsoft SQL Server 2005, ADO.Net, VSS,C #, Windows XP, Visual Studio 2008.

 Project Description  : Donor Management System is a Web application was developed with ASP.net & C#.Net which allows only society employees.

    This computer science engineering project deals with food providers in different places in the world and they are collecting Donations from donors who wants to go for donations. The employee in this organization can able to add donor details and donor donation details. And he can able to print donor ID-Cards, transactions list and balance sheets etc.

Developer Responsibilities:

  • Involved in coding using c#
  • Development of user interface using ASP.NET
Posted on

Cab Management System .Net Project

Project Title   :      Cab Management System .Net Project

    Project Description: Cab Management System is a Web application project was developed with ASP.Net can be useful for common people to use can facility and can useful for corporate company to take care of employees traveling for safe travel. The Cab provider Company Provides Cabs to the small scale industry based on Trips and KMs and it hires vehicle from vehicle owners and pay them weekly, monthly depending on the Plan they belongs. The employees of this company were the data entry operators have unique user ids to log in to the application. They enter the logsheets(roasters) and generate bills for vehicle from this application. They use the application to reduce the dummy(duplicate) logsheets and Back to Back sheets, reports  and repeated work for client and vehicle owner. SQL server 2005 is used for creating database to store all cabs details and employee information who is applying for cab.

  • Entering Logsheets And Fueldetails.
  • Generating Bills on Plantype.
  • Issue Finance For Vehicles.
  • Generating Reports.

   Developer Roles & Responsibilities:

  • Involved in frontend Design and coding of all modules.
  • Database design and writing SP’s.                                                        

   Software environment: ASP. Net(3.5), c#.net, Windows XP pro, Microsoft SQL Server 2005, VSS, ADO.Net, MS Visual Studio 2008,Ajax.

Posted on

Computerizing Computer Training Institute Project

This final year mini project is a windows based application developed with C#.Net and SQL Server 2008. In this Computerizing Computer Training Institute Project for day to day transactions we are implementing the following modules:

1) Login module 2) New User Registration module 3) Welcome module 4) Course module 5) Faculty module 6) Student module 7) Details module.

Each and every module in this computer science mini project comprises of respective records which are user accessible. The index page is a web form which consists of the above listed modules.

Posted on

Server Room Monitoring, Bhel Accounting System, Serial Receive Voucher

6 Months Diploma In Information Technology  Project Management By C-Dac Pune  has done at BHEL and got an opportunity at Informatics Centre (IFX) for Graduate Apprentice Engineering Training in Computer science, The developer has done number of projects in this Government company,  all the projects are based on the computer science programming languages like OOPS concepts, C++, java, Delphi, C#.net (asp.net), SQL server, Oracle 10g, PL/SQL, Oracle Form Builder with the help of some projects can be done, these projects are like Server Room Monitoring, Bhel Accounting System, Serial Receive Voucher etc.

Posted on

Courier Service System Java Project

  • Project Title                              :  Courier Service System Java Project
  • Software technology                :  Java, J2EE, Flex, Oracle.

Project over View: The Courier Service System Java Project contains different modules like Cargo Flight Schedules module, Unit Load Device module, Products & Services module, Rates & Surcharges module, Legal Activities and Conditions module, Airway Bill number module, Reports module, Tracking and Tracing bill module, Bar Code Creation module, Cargo box Calculator and Help module.

The main objective of this project is to provide all courier based services to the small scale and big courier companies. The advantages of this java application are increases throughput, reduce costs & create the necessary condition for optimum customer service.

This Courier Service System Java Project was developed with java programming and Oracle database server.

Posted on

Distributors Software Billing System ASP.net Project

  • Project Title                              :  Distributors Software Billing System ASP.net Project
  • Technology                                : ASP.Net, SQL Server 2005

                   The “Distributors Software Billing System” is developed with ASP.Net & SQL Server 2005, It is the web based software application designed for the distributors who distribute the small scale company Products. The aim of this Project is to supply the wanted products to the customers or users. This project works with different modules; this makes the Distributors to check their daily Stocks details, Sales details, Order details, Invoices details and Ledgers details. Here in this project the suppliers, Distributors, Traders will play the main role. This web base ASP.Net Application was developed to reduce the burden of the users and also to maintain, Updated and accurate reports of the Records. The SQL server database is designed to reduce the redundancy of the data. Other software requirements used in this final year project are C#.net, VB.Net, Web logic tool, Microsoft SharePoint.

Responsibilities:

  • Manual Test cases were created to validate the functionality.
  • Preparation of Test cases.
  • Review the Test cases and analyze with others.
  • Development of the Entry Criteria and Exit criteria.
  • Execution of Test Cases and Generation of Defect Report.
  • Involved in Testing User Interface, Input domain Testing.
  • Performed Regression testing.
Posted on

Forest Department E-Timber Application SQL project

  •  Project Title              :    Forest Department E-Timber Application SQL project
  •  Software Requirements      :   SQL, PL/SQL, TOAD, ORACLE DB 10G

Project Description: The main aim of this Forest Department E-Timber Application project is to provide timber merchant information located in forest, the output of the project defines the navigation between the functions and specifies the actions available to the user of the application. The e-Timber application is specifically designed for the users handling Timber sales at Government Timber Depots of Forest areas. It keeps a track of the forest produce, which is put up for sale at the Depots and also provides information on revenue generated from application is designed for the Karnataka Forest Department. This project was developed with SQL server, Oracle database server.

Developer Responsibilities:

  • Understand the client requirements.
  • Involved in creating different tables like Circle, Division, Depot, Range, Depot_ Auction, and Auction_Purchaser and so on…
  • Involved in creating different stored procedures for binding the data from database.
  • Using Triggers, functions and procedures manage the transactions.
  •  Deploying requirement based on approved design.
  • Develop software for recording all events and transactions relating to transporting goods to designated depots, Classification in the depots, sales and realization of revenue.
Posted on

Human Resource Management .Net and SQL Project

  • Project Title                      : Human Resource Management .Net and SQL Project
  • Software requirements          : .Net technologies, SQL SERVER

Project Description        : Human Resource Management .Net and SQL Project is a Web based project, the main objective of this web based application is to maintaining a tool as one stop tool for client, sub clients, staff and to the company department. This HR tool has some unique features for security measures while hiring employees to the organization, managing staff and sub clients. This application has developed with ASP.Net & SQL.

 Developer Responsibilities:

  • Understand the overall project picture and its main objective.
  • Involved in preparing Test Cases , reviewing test cases & Executing Test Cases
  • Defect Reporting
  • Involved in Peer Review
  • Perform different types of testing like Functional Testing, GUI Testing, retesting , regression testing , database testing etc
  • Database Validation to check the updated data in the database using SQL server
  • Involved in Daily review meetings with the team members and clients to review project status.