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

E-Business of Auto Marketing Project Synopsis

Synopsis : This E-Business of Auto Marketing project aims at developing an application framework that is centered on enhancing and facilitating facilitating the communication among the different participating entities involved in the e business Of Auto Marketing Classified Systems including site owners, buyers, sellers, car dealers, auto classified businesses and market researchers.

With this application, site visitors can search by Make and Model to access new and used car inventories from local dealers & independent sellers. This application framework combines powerful inventory search features for both new and used car configuration with pricing information, separate photo galleries and side-by-side Comparison tools.

This E-Business of Auto Marketing application develops an architectural framework that would help the involving entities in Building a complete and effective e-business infrastructure. The framework presents various ready made and easily extensible features. The framework demonstrates a multi-tiered architecture (involving base configuration & security layer, data access layer and business logic layer), compact design and the availability of various useful web services. The framework contains a separate library of classes that forms the middle layer between the business and data access logic and establishes a base security mechanism for entire application.

The E-Business of Auto Marketing application framework handles connections to database with highly optimized data access layer. The data access and flow to the system is entirely incorporated by means of stored procedures in order to improve data access response time and to enhance the security aspect of the data associated with the participating entities in this system.

The framework effectively manages the caching of data and dynamic html regions with the goal to achieve fast application response time. The framework also includes a site messaging system tool that can be used seamlessly in any web application. This tool, based on the use of XML/XPATH, organizes the expressions validity, messages consistency and site configuration and make it highly extensible and overall consistent.

The framework also includes a comprehensive system control panel feature. This feature allows the web site’s convenient back-hand data and site maintenance by all involving entities of the system, with the site administrator being in charge of this process as a whole. All active entities including dealers and sellers can maintain their accounts, inventories and associated photo galleries.

Entities can keep track of site surfer traffic for their products and can communicate with each other for the quote requests. This system also provides the feature of managing visitor/user’s favorite list of vehicle to his/her online profile. Visitor can save and remove the favorite inventories searched while surfing the web site in the visitor online list of favorites.

In summary, with its several capabilities, this web marketing system is flexible, efficient, user friendly, Customizable and feature-rich and ready to be adopted by any online auto classified system.

The E-Business of Auto Marketing application is divided into two categories for its design and development. Application’s front end and back-end interface design.

Application Framework Design Front-end Interface-Options

• Simple & Advance Search

• Inventory Detail Pages

• Registered Dealers

• My Favorites

• Request a Quote

• System Web Services

• About & Contact pages

Application Framework Design Back-end Interface -Options

• Back-end interface implements system’s control panel used by:

• Site Administrator is in charge of all site related activities, mainly responsible to enroll dealers, to approve registrations, to monitor advertisements & to manage the site parameters.

• Registered Dealer can manage inventory , edit profile information and can enable/disable quote requests.

• Registered Seller, once registered, can edit member profile, can place and edit ads, can upload inventory photos related to ads.

Modules :

1. Site Visitors:

Site Visitors module use search features to search new and used car from dealers & independent sellers.

2. Dealers :

Dealers module can get register to the system’s web site and can promote their dealership with enhanced vehicle listings featuring photos.

3. Individual Sellers:

Individual Sellers module can get register and place ads online for their used vehicle. Seller’s vehicle’ listings appear in the buyer’s search of used cars.

Technologies used in this application include:

Environment: .NET Frame work, Microsoft Visual Studio.NET C#, ASP.NET, XML Web Services.

Data base and web server: Microsoft SQL server and Internet Information Server (IIS).

Web Graphics Design: Macromedia Dream weaver, Adobe Photoshop pro, XHTML/XML/XSLT, Java Script/CSS and NET skm-Menus.

Posted on

Academic Projects Tracking System

ABSTRACT:

Academic projects tracking system is web based application used in organization/institutions. It has both admin and user module.

The main objective of this Academic Projects Tracking System is to store and retrieve the academic projects details in web based applications.

By this the student and staff interaction is reduces for the project work.  The user module includes search by department , By Registration Number , By student name, by Project title name, By course.

They can download the abstract or can view the abstract details project history.  The admin module commonly involved in settings, Course management, departments management, project information management.

Modules:

  • Admin Module
  • User Module
  • Course Management module
  • Project Management module
  • File download modjule
  • Project check module

Existing:

  • Refer student manually in library
  • Ask to seniors rarely 

Proposed system:

  • Got information from Automation system  in library or school data bases
  • Compare the projects
  • Do the best the project in new way than existing

Module Explanations:

Admin Module:

In this module, all the student details and their projects details available in data base.

User Module:

In this module is connected with admin module with various details like department, registration number, student name, project title , course and etc ., User can access the this tracking system only the above detail registered in admin module.

Course Management Module

In this module, the course details ( all details about students and project request user )available with data base. 

Project Management Module

In this module, all the previous projects details like abstract, base paper, and coding, how to run videos stored in this module. User can access those details only registered in admin phase.

File download module

In this module, user can download the project ( tracked from senior data bases)details from admin module with authentication.

Project check the module 

In this module, we can compare the project tiles and other details to data base( seniors projects ) from the admin module.

Software Requirements

  • Operating System : Windows 98/2000/XP/NT
  • Server side Script : ASP.NET with C#.
  • Back-End Tool :    SQL Server 

Hardware Requirements

  • Processor : Intel Pentium III
  • RAM : 256 MB
  • Memory : 64 Megabytes
  • Hard Disk : 20 GB
Posted on

GPS Position Tracker .Net Project

GPS Position Tracker – What is the location of your pal?

1, Introduction

Tracking and monitoring is very essential for the smooth working of any business. It can be vehicle tracking for a transportation company or it can be a marketing employee tracking for a company.

The effective tracking helps the administration to streamline its managerial tasks and so can increase the productivity. Currently it is big challenge for companies to keep track of their marketing employees in order to validate their work.

Position tracker works on GPS (Global Positioning System) and GPRS. The users need to activate the application and application will keep updating the location of the user after particular interval. at any moment Position tracker web portal allows the manager to check the location of a particular marketing agent and can also check entire roadmap of his movement from one location to another.

2, Challenge

Challenge is to create a well planned tracking method which reduces the cost of information exchange, but at the same time automate the entire tracking process.

Challenge is to receive and process multiple user inputs and make it available online for the administration to track and monitor.

Challenge is to develop, integrate and deploy different technological components to achieve one single aim called tracking.

3, Proposed Solution

Proposed GPS Position Tracker solution consists of a Symbian client application which will automatically keep updating the longitude and latitude of the user to the web service after particular interval.

A web service will receive the location based information from the mobile and process it. The portal which implemented via Google maps will show the exact location of the users online. Portal can be accessed by different users.

Administrator or manager can keep track of their marketing employees who roam around for marketing their products. Managers can log in to portal and for a particular user, get the entire report of his location movement.

For a company is into transportation, can track their vehicles easily by checking online at any time from anywhere.

4, System Diagram

5, Technology

GPS Position tracker requires two components:

1. Position tracker Portal software

The responsibility of this component is to receive the location information from several mobile users via Position Tracker mobile software. This component will also store the location data into database. This component will also allow users to see the locations in Google Maps.

Technologies –

• Microsoft .Net
• Visual C# language
• ASP.Net
• ASP.Net web service
• SQL Server
• Google Maps API
• XML
2. Position tracker mobile software

This GPS Position Tracker software widget needs to be installed on mobile. The responsibility of this component is to get the current location of the user via GPS and upload it to web portal via HTTP transfer using GPRS.

Technologies:
• Symbian Operating System for mobiles
• C++
• XML

6, Future enhancements

Position tracker can be developed further to analyze the minimum shortest path between the check points and help administrator to decide routes to minimize the transportation costs.

This system can be used for understanding the time taken between places thus administrator can roughly assess the time taken for a vehicle to reach destination.

7, Conclusion

Position Tracker is a tracking platform, so it can be modified to fit to any business use-case and since it is used on mobiles and internet so we will get upto date information at very less cost.

Posted on

AJAX Based Online Text Support Synopsis

  1. Introduction

AJAX Based Online Text Support is basically a web based chatting application mainly used in companies for tech support. This AJAX Based Online Text Support project features same texture like all normal chatting application with more enhanced features mainly meant for tech support.

This system can be used to improve business relationships and the most important customer satisfaction, as these two are the most essential factors.

This AJAX Based Online Text Support application involves communication between customer and support team member to get the necessary solution for the queries customer is facing with. The customer has a login to website to get the support from where he can select any available support team member from the list shown to clarify his queries and the problem can be resolved.

  1. Challenge

 The challenges in developing this application are to make it more users interactive and faster in the web by reducing the network round trip.

  1. Proposed Solution

Proposed System uses AJAX technology to reduce network round trip and enhance user interaction in web.

The customer has a login to the web site to get the support. Where he can select any available support person. Secure one to one cannel will be established between the two and user can get his problem resolved.

The chat session will be saved as the back up for the review and tracking by the management of the support group. This chat sequences can be emailed to the customer for further clarification.

  1. Features
  • Chat sequence can be mailed to the customer for further clarification.
  • More easy to use, fast, reduces network trips as it is equipped with AJAX tools.
  • Tracking employee or support team members. 
  1. Technology 
  • Microsoft .Net
  • Visual C# or VB.net language
  • Net
  • AJAX
  • SQL Server
  • XML
  1. Future enhancements 

Upgrading software to support Voice and Video Chatting. 

  1. Conclusion 

AJAX Based Online Text Support is a text support platform, so it can be modified to fit to any business use-case and since it is used on internet so we can reduce support cost and en shore customer satisfaction.

Posted on

Customizable Business Workflow System Project Synopsis

Synopsis:

Workflows drive business productivity by automating and coordinating collaboration across people and systems. Business Workflow System is an extremely powerful tool that will quantify the gains in productivity.

Description:

Businesses in the modern world are constantly evolving to satisfy changing market demands and to maintain a competitive advantage over their rivals. In order to evolve more efficiently, businesses must employ internal processes that can be continuously monitored and improved. These processes must manage a business’ complete infrastructure including its employees, computer systems, assets, partners etc.

Large businesses generally have the ability of investing resources into developing and managing their business processes. This can include employing specialists to continuously develop the company’s infrastructure and manage its assets. Small to medium sized business generally only have time to operate their business let alone using resources to invest in self improvement

  • Utilize Business Process Management (BPM) to create, monitor and improve their internal processes.
  • Seamlessly integrate their processes with other organisations and business partners.
  • Manage their Business Intelligence Rules (BIR) to automate workflow.
  • Completely customize their organisational structure and define their business objects.

Eazy Manager can be used by any organization to manage their business processes by creating Business Workflow System.

The solution provided following features:

  • Web service that can be consumed by any organization, so that they can manage their UI as per their requirement
  • Workflow Engine where business processes of the organization can defined and scheduled for execution.
  • Workflow Engine can be defined with various Tasks that can be either manual or automatic.
  • Processes can be defined with complex Business expressions as per need for its flow and decision making.
  • Dynamic Report Generation through Jasper Reporting tool.
  • Dynamic Custom Business Objects creation so that organizations using solution can manage their Entities in their own way.
  • Organization can search for data as per their criteria.
  • Application considered TimeZone and Locale as Globalization support.

Technologies Used:

  • Operating System : Windows XP
  • Platform : Visual Studio .Net
  • Database : SQL Server
  • Languages : C#.Net
Posted on

Info Sniffer Manager .Net Project Abstract

Abstract:

This Info Sniffer project is aimed to developing an online Info Sniffer Manager useful for applications developed in an organization. The Info Sniffer is a web based .Net project that can be accessed throughout the organization.

This system can be used for managing Record against an Organization/Department, and tracking the Record across Inquiry to individuals..

Functional components of the project:

User Maintenance:

Component Maintenance:

Record Tracking: Creating, Modifying and Closing a Record. A Info Sniffer screen should at least have following details:

  • Record Number and Title
  • Date of Joining
  • Department Details
  • Year of experience
  • Previous work History
  • Qualifications
  • Personal Details
  • Address with Contact no
  • Passport and Visa Information
  • PAN Information
  • Status: “Active/ Closed”

Find Employee Record: A search screen to find Employee Record and display results.

Find Department: A search screen to find Department and display results.

Report: Generate reports on Record.

Privileges: Accordingly there would be following levels of user privileges:

  • Level 1: Application admin having all privileges.
  • Level 2: System Operator Having privileges for Record Maintenance, Find User, Find Report
  • Level 3: Users having privileges for view his/her Record, Find limited Details of other Users and checks the mail and notifications.

A System Admin should be able to:

  • Add/Delete/Modify an Employee Record.
  • Add/Delete/Modify a Department.
  • Add a new Operator.
  • Remove an Operator.
  • Login to the system through the first page of the application.
  • Change the password after logging into system.
  • Granting/Remove privilege for Operator and User.
  • View the all employee Record
  • Find details of Users
  • Check/Send the mail and notifications to Department/Operator/Employee
  • Generate reports.

A System Operator should be able to:

  • Login to the system through the first page of the application.
  • Change the password after logging into system.
  • Add/Modify an Employee Record.
  • View the all employee Record
  • Find details of Users
  • Check/Send the mail Admin/Employee
  • Generate reports.

A user should be able to:

  • Login to the system through the first page of the application.
  • Change the password after logging into system.
  • View his/her Record.
  • Check the mail and notifications
  • Send the mail to Operator/other User
  • Find limited Details of other Users.

SOFTWARE SPECIFICATION :-

  • Operating System : Windows XP
  • Platform : Visual Studio .Net
  • Database : SQL Server
  • Languages : C#.Net
Posted on

Ads Online .Net Project Synopsis

Synopsis:

Ads Online is a B-to-B application where the basic functionality of the project is a .NET Portal where the user can advertise the Business Requirements in Internet, any type of classifieds they can advertise through this portal

Some of the functionalities are shown below:

  1. Announcements
  2. Business Opportunities
  3. Information Technology
  4. Employments
  5. Pets and Animals
  6. Services
  7. Auto & Motorcycles

Ads Online is a basic, yet fully functional Ads Online system that you may use as a framework to create an expanded system or use ‘as is’.

The main aim of the Ads Online .Net project specified at customer’s point of view is to advertise the details of their products or company’s details through banners or advertisements.

First the customers as to get registered on the site or portal avail before he needs to make a classifieds.

The Ads Online .Net project is broken down into several steps that will allow completing it rapidly and giving an opportunity to expand on the design once it is completed.

Some of the technical features available in this portal are:

  • User Registration
  • Multi-Level Categories
  • Verify Sign Pay flow Link integration
  • “My Classifieds” section
  • Shopping Cart
  • Administration of Members
  • Administration of Categories

Technologies Used:

SOFTWARE SPECIFICATION:- 

Operating System : Windows

Platform : Visual Studio .Net

Database : SQL Server

Languages  : C#.Net

Posted on

GSM Based Mobile Recharge .Net Project Abstract

Abstract

This GSM Based Mobile Recharge project is developed because, the customer can recharge himself/herself.  In this first the customer should register on their respective mobile center. There are recharge machine centers, and the customer can go to the recharge machine center and he can do recharge without the second person help.

When ever we wanted to recharge our Mobile phones we should do just go to nearest recharge center and provide our details when ever it requested. And when ever we say recharge the system will generate a code and it will send that code to the Mobile number which is specified by the user.

To recharge the number we must type the code which is sent by the system.  When both the codes matches then only the number which is given by the user will recharged and the amount will be deducted from the account.

This SELF MOBILE RECHARGE Authenticates Person’s Using Dynamically Generated GSMID and retrieves the details pertaining to that specific person from the database.  SELF MOBILE RECHARGE is based on a GSM Modems used for sending SMS (Short Message Service) that has advantages over the traditional authentication process in that it tries to read a Constant ID Details.

User GSMID is successfully matched against each other by using Data Base, but only if they had been included in the DataBase. GSMID outside the Data Base pool should be added Updated to GSM ATM System before Performing the task otherwise they would not be handled correctly. The one, which is to be recognized by ATM System, must be updated before Validating.

The major advantage of this GSM Based Mobile Recharge (SELF MOBILE RECHARGE) is the Additional security features it offers. Anti Social events like Credit card, Debit Card etc will soon be things of the past thus ensuring fair, free and easier for Recharging Mobile Phones.

System Specifications

Software Requirements: –

Operating System : Windows

Programming language: C#.NET

Back-End: Sql Server

Posted on

Event Portal Project

This is a conceptual design for a content management website called Event Portal, which showcases a variety of events and facilitates registration and promotion.

In this design document, listings and forms are illustrated with random pictures simply to help students visualize and easily grasp the design concept. Students should conduct application requirement gathering and definition of database, and they should work out a detailed specification on their own.

Students also are encouraged to add innovative twists to their applications.

This Event Portal should include, but not limited to, the components and features as below

1. Convenient browsing such as drop-down menus by locations, types, categories and so on.

2. Easy navigation throughout the website, such as links on the header and footer, or buttons at easy-to-see locations, etc.

3. There should be a sign-up and a login pages.

4. User console: users log in to create or edit events, review registrations or payments, etc.

5. Admin console: site admins log in to edit or delete events, review registrations, and administer user accounts

6. Registration process: registration form, confirmation page and email

7. The website should be mobile friendly by applying responsive design.

This project is a miniature of real world application. A few features described in this document may require, but not limited to, the following advanced technical knowledge and skills:

  • HTML and CSS skill for setting styles for Web forms, paginated listings and dropdown menus
  • Responsive design
  • Authenticate and authorize users
  • Creation of SQL data source and database programming
  • Site navigation
  • State and cookies
  • Server controls and validation controls
  • Test and debug

Students should study and try to incorporate as many as possible in their project.

Screens Description:

Home

  1. This is a short listing. The front page can show multiple rows of featured events.
  2. The thumbnail pictures are hyperlinked to the respective event pages.

Browse Events by

1) This is a short listing for illustration purpose.
2) “Browse Events by” could use drop-down menus for Location, Category, Type, Date and
Price.

Create Event

1) This form should also contain other columns including Event Description, Organizer,
Organizer Description, Event Type, Event Topic, Ticket, feature and so on.
2) Ticket types: paid and free

Register for [event title]

  1. When user clicks CHECKOUT button, a registration page as follows will show.
  2. Below Order Summary, there should be a registration form for collecting participant
    information, billing information and payment detail (if the event requires payment).
  3. If event is free of charge, the form should hide billing information and payment detail sections.
  4.  Once the registration form is submitted, a confirmation page should show event detail and
    payment receipt (if the event requires payment).
Posted on

Overseas Employment Training and Placement

Abstract:  The  project entiled as OVERSEAS EMPLOYMENT TRAINING AND PLACEMENT  monitors the training and placement activities of the company.  The aspirant who wants to go abroad can register his name for the job he is willing to take and he will be trained for required skill set.

The system takes care of the registration of the aspirants and his performance are monitored till he is placed in the job. The training given to him at various phases are monitored. The aspirants who completed the training successfully with the required skill will be called for interview with the overseas client.

The company provides the required Accident and Health Insurance coverage to the job aspirants  and also provides the  foreign exchange for persons recruited abroad for employment and for persons for traveling abroad.

The system produces various reports on training, performance, selection, job performance, fees payment, fees pending, insurance coverage and foreign exchange. The system also produces report of his  improvement in the various training phases. The system is to be developed by using ASP.Net 2008 as front end and Microsoft SQL Server 2005 as the back end.

Objective:

  • The main objectives of this project are providing customized views to the aspirant as well as administrators.
  • The system takes care of the registration of the aspirants and his performance are monitored till he is placed in the job. The training given to him at various phases are monitored.
  • The project is to reduce clerical work, provide more options in report generation, make the software more user friendly and increase the accuracy in record manipulation.
  • The system also produces various reports on training, performance, selection, job performance, fees payment, fees pending, insurance coverage and foreign exchange. The system also produces report of his  improvement in the various training phases.

Problem Identification:

  • The existing system is manual system. The details are stored in  manual ledgers only.
  • In the existing system, there are limitations like inconsistency of data,  repetitition and                          time-consuming reference work.
  • The training details are stored manually. The fees collection and money handled are maintained in ledgers

Drawbacks of Existing System:

  • The manual system results in storage of huge volume of ledgers.
  • The adhoc reports are not easily available
  • The business progress is not known.

Proposed System:

  • The proposed system removes all the ledgers and paper works,
  • The aspirant who wants to go abroad can register his name for the job he is willing to take and he will be trained on the registered area.
  • The training details are stored and the performance of the aspirant is monitored and analyzed through the system
  • The message can be sent to be  aspirants whenever a client interview is scheduled
  • The system produces various adhoc reports based on the management requirements on application, training, performance, selection, recruitment, fees collection, insurance and job performance.

Software Requirements:

  • Operating system   :   Windows 7.
  • Coding Language  :  VB.NET
  • Tool  :  Visual Studio 2008
  • Database  :  SQL SERVER 2005

Modules:

  1. Registration
  2. Training module
  3. Interview module
  4. Client module
  5. Insurance
  6. Foreign Exchange
  7. Training Fees
  8. Report module

Registration

This module stores the complete personal and academic details of the aspirants who register him for the job. The details includes his id, name, address, phoneno, mailid, passport details,educational qualification, the job, preferred country, expected salary, prev. experience, total fees, fees paid etc.,

Training module

This module stores the details of the training given to the registered aspirants such as course id, course name, duration, fees.

Interview module

This module stores the details of the interview held for the aspirants such as date, client id, place, aspirant id, interview performance, selection, salary, expected date of joining, remarks etc.,

Client module

This module stores the details of the client such as client id, name of the company, address, phone no, contact person, mail id, nature of business, no of candidates presently working, remarks etc.,

Insurance

This module stores the details of the insurance done for the aspirants selected by the clients to work abroad. The details such as name of the insurance, sum assured, no. of years, premium amount, mode of payment such as quarterly/ half yearly/ annual, name of the nominee, nominee details etc.,

Foreign Exchange

The aspirants require foreign exchange to travel abroad. The details of the foreign exchange rendered to the aspirants such as date, amount in rupees, foreign exchange tendered are stored.

Training Fees

The training fees paid by the aspirants for the job training such as date, course id, reg id, amount are stored.

Report module

This module generates the reports on no. of registrations, training details, training completion details, client interview schedule, interview performance, selection list, pending list, rejected list, insurance details, insurance expiry, training fees collected, pending, foreign exchange requested, tendered etc.,

Architecture Design: