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

Sales Management Portal .Net Project

The Sales Management System should have, but not limited to, the features and functionalities as below

1)  Search: allows users to staff find clients by names, either on the complete or partial match.

2)  A filter for browsing: can shorten the list and separate prospects from current clients.

3)  A sign-in form

4)  Manager Console: Managers can create user accounts, view, and update entries, leave comments on entries, and send messages to staff, etc.

5)  Pipeline Reports: Managers should also be able to run various reports such as lists of prospects, reports of opportunities or proposals by dates, sales projections by month or by the salesperson, project tracking, etc.

Features described in this document may require, but not limited to, the following advanced technical knowledge and skills for:

  • HTML programming and CSS styling
  • Responsive design
  • The user authenticates and authorization
  • SQL database and programming
  • Site navigation
  • Application of state and cookies
  • Validation controls
  • API and Web service programming
  • Test and debug

Students should study and try to incorporate as many features and functionalities as possible in their projects

Portal Homepage

Main page after user logged-in

  • Announcements section displays manager’s messages in the order of dates.
  • Left-hand side panel displays a list of all clients in alphabetical order.
  • Users can search clients by names, also can filter the list by types, client or prospect.
  • The new prospect can be added by clicking Add Client.

Illustration of a pipeline for a client

After staff selects a client from the main client list, the page shows a sales pipeline for the selected client: General Info, Contacts, Notes, Opportunities, Proposals, and Projects.

The illustration shows the Contacts page

Database Design

Below are some essential information used in a real-world sales pipeline. It is recommended to incorporate them in your database design.

Pipeline: Opportunities

  • Opportunities Name
  • Added by
  • Date Added
  • Chance to close (percentage)
  • Estimated Budget
  • Opportunity Duration
  • Opportunity Type (a list of major products and services )
  • Contact Name
  • Contact Telephone
  • Opportunity Description
  • Opportunity Notes

Pipeline: Proposals

  • Proposal Name
  • Account Manager
  • Date Added
  • Chance to Close (percentage)
  • Estimated Budget
  • Proposal Duration
  • Proposal Amount
  • Total Revenue
  • Proposal Status (a project is automatically created when proposal status is set to accept )
  • Rejection Reason
  • Contact Name
  • Contact Telephone
  • Description
  • Proposal Notes

Pipeline: Projects

  • Project Name
  • Project Manager
  • Date Added
  • Project Amount
  • Total Revenue
  • Project Duration
  • Project Status
  • Launch Date
  • Contact Name
  • Contact Telephone
  • Project Description
  • Project Notes

Download The Sales Management System .Net Project Code, SQL Database & Output Screens.

Posted on

Online Resume Management .Net Project Synopsis

Online resume management will basically provide an online platform that will provide an option to upload a resume and then search for jobs relevant to the skill set. It will have admin panel which will allow admin to manage different features. It will maintain information related to users who will register and apply for jobs as per skills. This application will provide an option to apply for different Functions or Verticals and allow users to apply for different skills as per choice.

User Types: Admin, Users

Modules:

Admin Module:

It will be accessible to Admin and he or she can add or manage Filters, Employers of Choice, and Job Openings.
→ Job Openings will have the option to add info related to Job title, Company name, Skills, Location, Experience, Posted On, Company Logo, HR Name, Contact no
→ Filters will have options to add different values to filters, like Bangalore / Hyderabad etc in Location. The grid will be provided with different Filter Names and will have the option to add/ Edit option to add Filter values. The option will also be there to add Filter heads.
→ Employers of choice will have the option to add a company logo. Description / About US, Jobs of that company. Admin can add as many Employers of choice and they will be added to the dashboard.

Home Dashboard:

This is basically the dashboard for all users (registered or unregistered). It will show different options like Search filters, Employers of Choice, Login / Register, Upload resume, Job Openings etc. Employers of choice will be added by admin. Job openings info will be added by admin.
Search: This module will provide filters that will allow searches for different conditions. Filters related to Skills, Function, Industry, Location, startups etc will be provided. This module will be accessible to both admin and user. Admin will manage filter updates, like adding and removing different filter values. Users will able to see these filters managed by admin in the home dashboard.

Registration Module:

It will have a complete and comprehensive form which will lot of options to be selected and save relevant information. It will have options to save First name, Last name, Middle name, Password, Re-Confirm password, Current Location, Total Exp, Industry, Function, Key Skills etc for submitting initial registration information.

Notifications:

This module will show notifications whenever admin adds new Job Openings or add Employers of choice.

Contact Us:

Will show info related to contact numbers and also search filters.

Future Enhancements:

→ We can provide email notifications and SMS integration. This will require web service or API integration with SMS providers and SMTP configuration to handle emails.

→ Provide package plans for users with related services.
→ Add Blogs that can be posted by users.

Software Requirements:

Technical Aspects:

Database: SQL Server 2008 and more

Language: C# and Asp

Framework: .Net

Front-end: HTML, CSS, JavaScript

It can also be done in Php, MySql as back end with other frameworks

Hardware Requirements:

Intel Core processor

RAM 4GB and Above

HDD 100 GB Hard Disk Space and Above

64 or 32 bit OS Windows 8 and above

Posted on

Online Banking System .Net Project Abstract, Report and Source Code

ABSTRACT

Online Banking is one of the most important financial activities which will be carried out by any person who holds a bank account. There are various activities that can be carried out once you log in to your bank account. Once a user logs in he or she can check the bank balance, check bank account transaction history or account summary, add beneficiary accounts, transfer funds to another account, download account summary. Whenever we deal with a banking system main concern should be the security related to banking transactions and account login activity.

Existing System:

The Online Banking System as of now deals with a single sign-in log on and it will not be secure as expected. If a customer logs on from an unknown system outside the usual access device there are chances that it can be hacked easily and this might end up with a lot of issues. There are chances that if the user forgets the password and supposedly changes it and writes down the same somewhere and forgets to erase it or scramble it, there are chances that anyone can misuse the login.

Proposed System:

Once a customer logs in he or she has to generate a transaction password for online banking transactions. It will be an additional password apart from the login username and password credentials. The third security system can be provided by adding a graphical password generator which needs to be punched in before confirming an online transaction. This will involve password strength meter also.

Authentication is an activity of linking an independent or an individual process on the basis of username and password which basically consists of characters, numbers, alphanumeric values, special characters etc. Most of the authentications are complex, though they seem to be boring to the users and are very hard to remember. Every one of us, use the simple textual passwords which can be easily guessed by the attacker.

Let us try a New methodology to improve the authentication process using graphical password generation by making the user selects his/her own set of password as a series of clicks on the image which we will store it as a pattern and for each click the strength of the password is calculated and can be used to classify the password as Low/Medium/High .

Our Online Banking approach will be a click-based graphical passwords authentication system that works by having the user select from images, in a specific order, presented in a graphical user interface (GUI). For this reason, the graphical-password approach is sometimes called graphical user authentication (GUA).

A graphical password is easier than a text-based password for most people to remember. Suppose an 8-character password is necessary to gain entry into a particular computer network. Instead of w8KiJ72c, for example, a user might select images of the earth (from among a screen full of real and fictitious planets), the country of France (from a map of the world), the city of Nice (from a map of France), a white stucco house with arched doorways and red tiles on the roof, a green plastic cooler with a white lid, a package of Gouda cheese, a bottle of grape juice, and a pink paper cup with little green stars around its upper edge and three red bands around the middle.

Administrator Sequence diagram
User Sequence diagram

Approach:

We will implement the strength indicator in a web environment using Html, CSS, Javascript, and Java to run my application. Like unlocking methodologies currently present in Smartphones, graphical passwords may act as a next-generation locking mechanism in which my design of the graphical password strength meter can be induced to suggest the strength of the graphical password which is being set.

In our assumption, we have noted the following two points:

1. The segment size of specific smaller objects (like the eyeballs of a selfie) is small which gives any attacker a clue on where the click might be.

2. The segment size of large spaces in the image (like the sky in the background) gives minimal clue on where the click mostly be.

3. Every pixel in the image belongs to a segment, so choosing a pixel anywhere in the image can give strength to the password.

Based on these two points we will give less weight to smaller/specific objects and more weight to larger objects.

Output Screenshot

Number of Modules:

We will go with below modules:

1. Customer
2. Registration module
3. Security and Authentication
4. Accounts summary
5. Transfer Funds
6. Profile
7. Admin

Specification requirements:

Software requirements:

● Front End : HTML, Css, Javascript
● Data Base : SQL Server 2005 / MySQL
● Technology : Java and Framework

Hardware Requirements:

● Hard disk : 80GB Min.
● RAM : 2 GB Min. & Above
● Processor : Intel Pentium-IV and above

Posted on

My Party Link Service Portal .Net Project Abstract, Full Report & Source Code

Abstract:

INTRODUCTION TO PROJECT:

My Party Link service portal is a .Net based web project wherein Business holders can register their profile and add services as per their Business criteria and services provided. It will provide a platform to service/business providers to showcase or advertise their profiles, services offered or business profiles using the highly customizable features provided in the application. It will be accessible to users who look for a wide range of services for FREE.

The My Party Link project will basically cover registration, login, search functionality etc which are some of the important features for any online service portals or application. It will Admin, User and Vendor logins. Working on this My Party Link project will actually allow usage of important controls used in building or developing an application like Combo boxes, Dropdowns, Data grids, Text boxes, Html usage etc.

EXISTING PROJECT:

PROBLEMS IN THE EXISTING SYSTEM:

The manual process of writing information handmade bills and maintaining the same in books is tedious and time-consuming. It also raises concerns as per incorrect entries and irregularities as per record maintenance is concerned.

Disadvantages:

The following are the disadvantages of Existing system

➢ Highly impossible to maintain information in books and slips.
➢ Working hours for any employee will be more as he or she has to work out maintenance activities with manual work.
➢ Maintaining historical data of patients and employees will be complex and with no security as per data is concerned because they are maintained in papers and books.

SOLUTION OF THESE PROBLEMS

This My Party Link application will have a multi-user login environment and will be secure with authentication being monitored by Admin. The processing of data will be fast as we will use SQL Server 2008 and above version to save data. It will provide a faster processing of complex queries and thereby save time.

PURPOSE OF THE SYSTEM:

The purpose of this My Party Link document is to describe all external requirements for Web Info Model. It also describes the interfaces for the system. This project will teach the most important things that are required in any online application i.e. this project deals with REGISTRATION, LOGIN, SEARCHING and ADMIN modules. Importantly, this project uses the most used controls/techniques such as Data Grids, Emailing Mechanism, and Dropdown List etc

Module Description:

There are four modules for this project listed below:

1. Admin
2. Vendor
3. User
4. Home / Search

Admin:

Admin approves the registration of Vendors and Users who access the application and register to it. Admin can add countries and cities to the application which will then be followed by addition of local areas in cities, will also add the service area for which vendors will belong to like Agriculture, Software, Hardware etc. Registered Vendors and users will be monitored by Admin as their registration can be revoked by admin. Admin can also change the passwords for Vendors whenever a request is submitted to admin. A vendor has to send approval request for the services that will be added to the application for advertising. Once approved services related to registered vendors will be validated and listed out for advertising.

Vendor:

A Vendor will be a Businessman or Service provider who will register and provide info related to the services provided. Will add his profile and initially register his company. Once registered a request will be sent to Admin and upon approval, Vendor will be able to showcase or advertise his service or business details. A Vendor can upload images related to products which he or she deals with. The vendor can upload company logo and all textual information, price info, office info, warehouse info wherein products are manufactured, properties of products that are to be marketed. Information placed by vendors is visible to all users for free.

User:

The user will register initially and the same will be approved by Admin. Once approved a user can search for services he is looking for from dashboard and select whichever service they are looking for.

Search:

Logged in user will be allowed to search services they are looking for depending on country, city, location and service area. This feature is basically a dashboard for logged in users.

Sequence Diagram for Admin
Sequence diagram for User

Features:

Configurable Portal Settings
▪ The option will be provided for approvals requested by Vendors and Users.
▪ All features are customizable and can be modified as per client requirement. UI will be user-friendly.
▪ Will be compatible with all sorts of browsers.

CONCLUSION:

The My Party Link application designed will be a frontrunner as per service-oriented applications are concerned. It will be provided with easy to use and understandable UI with flexible and customizable front-end design. Enhanced Security option will be provided as it will be monitored by Admin. It will be suitable for all service providers/business professionals. It will be a linkage between users/customers and vendors.

Hardware/Software:

Front End Asp.net/C#.net
Web Yes
Server IIS 5.0 or Above
Back End(Database) SQL Server 2008 and more
NET Framework V 5.0 and more
Operating System Windows 8/10
Service Pack Latest

Download the below attached My Party Link Service Portal .Net Project Abstract, Full Report & Source Code & Database Files.

Posted on

Online Real Estate System .Net Project

Abstract:

Online real estate system is a project which provides a friendly format for buying and selling properties. Users can search and browse for property in this application. This application also allows users to book the property online. This application mainly concentrates on maintaining and managing the details of the property. This application deals with buying and selling the houses, lands, commercial properties all over the world.

Existing System:

The existing real estate system is converted to the computerized system. This system is a manual where storing information is very difficult. This is not a web-based system and cannot be accessed easily. A lot of communication gap between customer and seller. If customer/seller wants to update the details of his property, he should contact the agent or visit office. If customer/seller gives any updated details regarding his property then agent have to change all the details on every record-keeping register.

Proposed System:

The proposed real estate system allows a user to store property, customer, seller, and staff details. It allows users to update, search property details and use them whenever necessary. It will also be able to provide financial, sold properties, all staff, all contacts reports.

Modules:

Customer:

The customer can get registered with the system by entering all the details. He can enter into the website by giving a valid username and password. The customer can view all the details on the website. The customer can view the details of the updated properties. The customer can post properties and post emails regarding the properties.

Vendor:

The vendor can get into the website with a valid username and password. The vendor can view all the posted properties of the customer. The vendor can view all the posts of the customers. The vendor can add the details of the new properties.

Conclusion:

Our system provides the facilities of buying and selling of homes and properties in a user-friendly format. The seller can upload his/her property from anywhere. Our real estate system allows users to browse the property according to this requirement.

Posted on

Software Project Organizer .Net Project

This Software Project Organizer .Net Project is developed to maintain organization’s total info like a number of branches, total working employees with their performance, worksheets, talent transformation, Company ongoing projects with full details, coding standards to develop an application, etc..

This project organizer in a software company application has the following main modules:

1. Branch Information Module:

This module handles the information of all the unique branches existing under the organization. The information is maintained in branch master table.
It also maintains the employees working under a particular branch, which can be known a report generated on employee master table grouping on branch id.

2. Employee information module:

It manages the following submodules

  1. Employee’s performance module.
  2. Employees took assignment module
  3. Employee’s skill set information module.

This module maintains the total information related to the employees working in the organization. Their designations and the departments in which they are recruited. It also gives the information regarding the employee’s performance within the organization related to their job targets. It manages a clear history of an employee skill sets and defines the role played by the employee in a project and the area of his interaction in the project i.e., at the level of project or module component of elements.
It also maintains department master table.

3. Project information management module:

It maintains the total information related to the unique projects that have been signed for a contract of development. The module reveals the information regarding which project belongs to which client and the associated employee who is in charge of the overall project.
The major concentration is surrounded by the facts table, which clearly specifies how many modules a project manages with respect to no. Of components in each module and the no. Of elements in association with each component.
The module also specifies the duration of each entity with respect to the role played by each employee and the entity level in charge.

4. Package information module:

This module manages the entire information regarding the different types of packages that are purposefully used by the organization in their project development process and specifies the required packages list to complete a signed project. It also relates itself to know the different packages an employee can handle, which can serve as an information to recognize which employee can be resourceful to which type of project.

5. Project documentation Module:

This module maintains the overall information related to all the documents that are produced in course of project development process by different employees with respect to different areas of the project.
The module also serves to build on online help like system for the sake of user convenience and serves as a reference material to the developers as well as users.

6. Employee’s performance management module:

This module maintains the specific time levels taken by the employer in completing his tasks in turn serving the project analysis team to get the history of employees response towards an assigned task. The information from this module can be used as a cross-referential check to know the rating levels of the employee as designated within the company.

7. Report designing module:

This module practically manages the descriptive reports that are necessary within the organization as per the requirements of the information format at different levels of designations or departments.

Software and Hardware Specifications:

Hardware:

Processor : Intel Pentium 4 Processor with 700MHZ or more
Ram : 256 MB or more
Cache : 512 KB
Hard disk : 20 GB hard disk recommended.

Software:

Operating system : Windows 2000 SERVER
Front End Software : ASP.NET
Code behind : VB.NET (Visual Basic .NET)
Validations : Jscript
Back End Software : SQL Server 2000

Posted on

Secure Multimedia Audio & Video Streaming .Net Project

Introduction

Purpose

This project is used to efficiently uses the Bandwidth when downloading Audio/Video files by using Streaming Procedure. Streaming is nothing but a process of Transferring data(Audio/Video) from source system to destination in the form of bits/ bytes through an application.

For example, suppose 100 users log in to the web server, there will be less bandwidth when uploading/downloading the files from the web. So by introducing a Streaming concept, we can reduce the time required for uploading/downloading the audio/video files.

Document Conventions

To prepare this SRS we had used the lettering style of Times New Roman and Font size we used for sub had subheadings which are of bold. The matter which is mentioned in this SRS is 14 with a lettering style Times New Roman. Then coming to the part of headings which are of lettering style Times New Roman which is of Font size 16.Then next coming to the part of important point in our SRS is shown through the italic box.

Intended Audience and Reading Suggestions

This SRS is for better understanding the concept of Streaming. The rest of the part of the SRS is mentioned with the what our product benefits, how to use the product, how the product was developed, what are the major things we have taken in to the consideration all are mentioned in this rest of  the part of the SRS.

System Features

There are four modules which need to be develop are

Streaming Module:

Defines the procedure of transferring the Audio/video files in the forms of streams. Each audio/video file is converted into bit and bytes while playing the file. Each part of downloaded bit and bytes stream is played along with the corresponding another part is downloaded in parallel.

Users:

It defines how the users have to be interacting with the site. Each user has own authentication based on the registration done. All the users information is maintained corresponding to their audio/video files downloads.

Search Module:

It involves using of various search criteria’s to get required audio/ video files. Various search criteria’s to search for the songs like user can search for the required song based on song wise search, artist wise search etc.

Uploading and Downloading Audio/Video:

It provides the procedure of uploading the Audio/Video Files. Uploading of different audio/video files and downloading is audio/video files based on the file type like payment type or free.

Posted on

Information Screen in Share Marketing .Net Project

In this Information Screen in Share Marketing system, Login Screen contains an online catalog for the user, The menu should contain following screens: Registration Screen it is used by Insurance agent which is for registering this system, Stock registration Screen facilitates the trader to add a new share that he/she has purchased and sold those stocks which are not  purchased. Other forms like Stock Performance Screen 1, Stock Performance Screen 2, Asset Indicator screen, Buy Stock Request screen, Sell Stock Request screen, Sell Stock
Request screen, Buy Stock screen, Sell Stock screen, Sell Stock screen.

PROJECT DESCRIPTION

The project titled “INFORMATION SCREEN IN SHARE MARKETING” is designed using Active Server Pages .NET with Microsoft Visual Studio.Net 2005 as front end and Microsoft SQL Server 2000 as backend which works in .Net framework version 2.0. The coding language used is C#.Net.

The project contains the following main modules:

The project contains three main modules:

1. Home
2. Administrator
3. Share Holder
4. Company
5. Contacts

Home:

The home module is the main page of this system. In this page all modules link are available.

Admin:

The Admin Login page contains the following submodules.
1. View Share Holders
2. View Company Information
3. View Shares.

View Share Holders

• It consists of the information of the shareholder
• Company name, city, mobile number, share amount, number of shares and the name of the shareholder
• It contains the hyperlink to go to first, last, previous and last page

View Company Information

• It consists of the information of the company who announces their Shares
• And also display owner of the company, company name, city, mobile number, Number of the employee, last year profit, and current year profit, group.
• It contains the hyperlink to go to first, last, previous and last page

View Shares:

This page contains all the information about shares who are sold and buy.

Share Holder:

The Shareholder login page contains the following submodules.
1. Buy Shares
2. Sell Shares
3. My Profile
4. View Shares

Buy Shares:

It displays the Share rate and how much shares are available for which company. From that page, we can buy the particular shares online.

Sell Shares:

It is the option of selling our shares to the broker through online.

My Profile:

The profile page consists of the details of that shareholder.

View Shares:

It displays the whole share details with all modifications.

Company:

The Company login page contains the following submodules.

1. Buy Shares
2. Sell Shares
3. New Shares
4. View Shares

Contacts:

The contact page contains the Address of the broker as well as owner.

SYSTEM SPECIFICATION

SOFTWARE SPECIFICATION

The software used for the development of the project is:

OPERATING SYSTEM : Windows 2000 Professional, Latest OS
ENVIRONMENT : Visual Studio .NET 2005, Latest Edition.
.NET FRAMEWORK : Version 2.0
LANGUAGE : C# .NET
WEB TECHNOLOGY : Active Server Pages.NET
WEB SERVER : Internet Information Server 5.1
BACK END : MS-SQLSERVER 2008
REPORTS : Web Form Data Grid control

Posted on

Mobile Payment System .Net Project

Abstract

The project entitled Mobile payment system is an application to assist mobile phone users to access the information of different bills, send and receive a request from almost anywhere, anytime.
At the single touch of a button, the user is provided with an array of information. This project mainly caters to the professionals. Housewives and also business people who like to save their time and do their work in the home.

Mobile Bill Online Payment system has the most advanced set of accessibility features for providing users with a flexible, user-friendly interface. Some of the exclusive features of this application include accessing the data at the server and retrieving the data from the database.
When a user selects to launch Mobile Bill Payment, he is logged on to a screen where he is asked to select which service he would like to access. Then based upon the users choose the user is presented with a list of the particular service bill details. If the user selects the options provided on the screen given he is instantly provided with the information pertaining to that particular service.

Scope:

The objective of this system is to provide a solution to make payment of the Bills and recharge the mobiles using a single window system. In this system, the Administrator should able to add new Vendors of the mobile company to the system. The Administrator will add or update the different offers provided by the company which can be done through online. If the customer is facing issues in Online payment or other transactions he/she should able to register Complaint to the Administrator to the system.

Out of Scope:

• Online Payment for recharge amount is should reflect in customer bank account.
• After recharging to the mobile the SMS should be sent to the mobile as confirmation of the transaction.

Modules:

1 Administrator
2 Customer
3 Web Registration
4 Reports
5 Authentication

Administrator

• Should able to add new Vendors of the mobile connection company.
• Should able to add or update the different offers provided by the Vendors which can be used by the customers through the internet.
• Should able to receive the Complaint from Customers for the transaction related issues.
• Should update the Mobile numbers from Vendors into the system.

Customers

• Should able to register to the site to get pay the Mobile bill online.
• Should able to Recharge their mobile with different top-ups provided by the vendors. The mobile number given by the customer will be cross verified by the Vendors (using the vendor database).
• Should able to register Complaint against the issues in Recharge or Mobile Online payments.
• Should able to check the previous payment details as History.

Registration:

The system has a process of registration. Every User need to submit his complete details in the form of registration. Whenever a User registration completed automatically he/she can get a user id and password. By using that user id and password he/she can log into the system.

Reports

Different kind of reports is generated by the system.

1. Customers Report
2. Complaints Report

Posted on

Software Requirements Specification for Student Management System

This is the Software Requirements Specification for Student Management System, Which is developed using .Net and SQL Server.

1: Introduction

1.1 Purpose

Our product is student management system gives all the services that must be provided to a student over the internet to find fee details provided by that administrator of the college.
This product contains each and every data regarding student, payment etc., personal details which can be updated by the student and viewed by the administrator. It provides the detailed information about the fee details and the location (place) of college. Our product is a subpart of university management system.

1.2 Intended Audience and Reading Suggestions

The intended audience for this Student Management System document is the internal guides of the organization where the team has developed the project. Further modifications and reviewing will be done by the organization and deliver a final version. The final version of this document is reviewed by the Internal Guides and Head of the Department of the college.

1.3 Project Scope

Our Student Management System product usage makes work done at the faster way the software is applicable to view the fee details provided by the administrator of the organization and student can edit his personal details which can be viewed by the administrator.

2: Overall Description

2.1 Product Perspective

Student Management System is capable of managing each and every data regarding student, payments etc. Student Management System helps us in managing in an extremely efficient way. This Student Management System works in an efficient manner.

We have two modules in this project. One is admin and other is the user. Admin can maintain the fee details of students and can generate the reports can export the details to excel. User module can edit their personal details and can view the fee details.

2.2 Product Features

  • Reduces the manual workload.
  • Complete details of the student can be stored and retrieved.
  • Admin can see all the student’s payment details and also export to excel sheets.
  • The student can view all his details, payment details and the location of the college.

2.3 Design and Implementation Constraints

The Student Management System software is designed in such a way that the user can easily interact with the screen because of GUI. The admin and the user are the two users who use the project. The admin inserts the details of the students and the fee details that the students have paid. User/ student can view his/her details, update if required and check the fee details.

Software requirements:

• Microsoft .Net framework 3.5
• Microsoft Visual Studio 2008
• Microsoft ASP.Net 3.5
• Microsoft C#.Net language
• Microsoft SQL Server 2005
• ADO.NET
• HTML

Hardware Requirements:

Processor: Intel Pentium 4 or more

Ram: 1 GB or more

Hard disk: 40 GB hard disk recommended for the primary partition.

2.5 User Documentation

In our user manual, we are going to keep the information regarding our product which can be understandable by a new person who is going to use it. If a new person is using it online help will be provided in that we are going to explain each and every step clearly by our product can be useful for any user.

3: System Features

This Student Management System project is divided into 2 modules

1. Administrator and
2. User

Module Description

Admin: Admin is a person whose responsibility is to maintain the database that contains each and every data regarding the all the student. Admin can add student details into the database, can be able to delete student details and can update the student fee details.
Admin has some other responsibilities they are
• Admin is can maintain the fee details of each and every student.
• Admin can generate the reports of the students and
• Admin can export the details to excel.

User: Here the user means the student. The responsibility of the student is to login into the site and can view his/her fee details and can able update his/her personal details if there is any wrong details are present. Whenever the student will register his/her name then the student will be given by one individual username and password. When the student will type the correct username and password then the will enter into another page. In that page, the student can select two options that are updated details and view details. A student can able to update his/her personal details and can be able to view the fee details but cannot update the fee details.

4: External Interface Requirements

Hardware Interfaces

We require LAN connection for interacting with the database and local computers for any help or any other requirement. We use TCP/IP protocol for communicating with local hosts. We also need a system with P4 processor; 1GB RAM and database memory.

Software Interfaces

We use MS.Net 3.5 and C#.Net 3.5 Programming language for writing the code for the project. ASP.Net 3.5 for creating the web pages, using GUI for login screens and interacting with the database. SQL server 2005 is used for creating the local and global database (server). Microsoft Visual Studio 2008 IDE for writings the programs. Operating system: Windows XP or higher version.

Communications Interfaces

The communications functions required by this product are LAN connection within the whole company so that the Admin, employee, and customer can interact with each other. We use TCP/IP protocol.