Category: SQL Server Projects

The project titled “Inventory Control System” is to control the general stores department. Hindustan Shipyard Limited is an automation of issuing an item to different departments inside the organization, returning back the item to the stores if the department doesn’t have any need with the item or if the stock is full, issuing the receipt to the department to whom the item is being issued, checking the balance of the stock of each item, making a new purchase of an item if the store doesn’t contains the stock of that particular item.

The purchase of an item is indifferent modes i.e., local abroad and indigenous. If the item is purchased locally then it is said to be local. If the item is imported from other countries then it is said to be imported. If the item is purchased from any department inside the organization then it is said to be indigenous.

The project contains five modules:

Issue Module, Returns Module, Receipts Module, Balance Module and Purchase Module.

The Issue Module contains the information about the item are issued by the department to various other department in the organization. This module contains the following fields as card code, item code, department code, work order number, document number, transaction date, rate of the item, quantity of the item to be issued, its value.

The Returns Module contains the information about the item are issued by the department to various other department in the organization. This module contains the same fields as in the issue module they are as follow fields card code, item code, department code, work order number, document number, rate of the item, transaction date, quantity of the item to be issued, its value.

The Receipts module contains the information about the item that are issued and address of the department to which the item was sold are the supplier details. The details contains the following fields as card code, item code, department Code, order number, document number, transaction date, rate of the item, quantity of the item to be issued, its supplier details.

The Balance module contains the information about the balance that is/was present before/after the issue of each item and about the new stock. This module contains the following fields as card code, item code, department code, rate of the item transaction code, transaction date, quantity of the item to be issued, its value.

The Purchase module contains the information about the purchase that made by the department. Whenever the department needs any new item, the value of the purchased item is calculated according to the mode of purchase i.e. local, abroad, indigenous. We can make addition of a new item, deletion, modification, etc for this file. It contains the fields such as item code, item desc, units, quality grade, item value.

Inventory control system is a client/server application.
Software requirements Visual Basic.Net front end, MS SQL Server back end.

SYSTEM REQUIREMENT SPECIFICATION

The data processing department is accepting many requests, which comes from different department. Currently the request like updates, stop details, issues, returns are done manually. So they would like to automate it.
We have to first understand this problem and produce a requirement documents based on understanding the problem.

End User: Office Staff

While studying the current system, after speaking with the director, front office staff we found the system as follows.

Whenever a new work comes, the work is divided into different parts and each part is submitted to the respective department. The respective department checks their work and the material needed for their work. If the material is sufficient for them for doing their work to carry out with it otherwise they send a request for Data Processing Department for the issue for the material. The data Processing Department then sends a request to stores department whether the mat is available or not. If the material is available they will issue it otherwise they will place as an order.
If the allocated material is more than sufficient, the respective departments will handover that extra material to Data Processing Department by a note. Then the Data Processing Department will update their respective stores. In automating the whole process we find that the inventory system consists of three main parts.

1. ISSUES:
This process is used to store the issue details of the item which is requested by the respective department.

2. RETURNS:
This process is used to store the return details of the item, which IS the respective department.

3. RECEIPTS:
This process is used to store the receipt details of the item, which is attested by the respective department.
After discussion with the staff the following decisions were taken regarding what the automated systems should do and what new environment will be.

1.    The format for each entry should be similar over currently being used.
2.    Entries might have errors, so system should be able to check for errors.
3.    Information about the items, departments, and work orders should be kept in permanent database.

Requirement Specification Document:

Introduction:

Purpose:

The purpose of this document is to describe the external requirement for the atomization of stock details. The atomization will provide management to accept item details and quality. It also describes the interface for the system.

Scope:

The document is the only one that describes the requirements of the system. It is meant for the use by and will also be the basis for validating the full system. Any change made to the requirements in future will have to go through a formal change approval process. The developer is responsible for asking for classification whenever necessary and will give any alteration without the permission of the client.

Conversion Methods:

Conversion methods are of four types these are parallel systems, direct cut over method, pilot method and phase in method. Each method has some advantages it offers and some problems that it may cause. However some situations force one method to be used over others, even though other methods may be more beneficial. In general, system conversion should be accomplished as quickly as possible. The present module contains the same fields as in the issue module they are as follows card code, item code, department code, work order number, document number, transaction date, rate of the item, quantity of the item to be issued., its value etc.,

Receipts Module:

This module contains the information about the items that are issued and their the details of the department to which the item was sold and the supplier details. This module contains the following fields as card code, item code, department code, order number, document number, transaction date, rate of the item, quantity of the item to be issued, its value, supplier details etc.

Balance Module:

This module contains the information about the balance that is/was present before/after the issue of each item and about the new stock. This module contains the following fields as card code, item code, department code, transaction date, rate of the item, quantity of the item to be issued, its value.

Purchase Order Master:

This module contains the information about the purchases that are made by the department. Whenever the department needs any new item, system is developed using ORACLE 7.3 as backend and VISUAL BASIC 6.0 as front end that helps us to create easier and flexible data entry.

The system automation that has been developed will be installed in the organization in a phased manner. This helps the end user who will be using the system in future to get a feel of the system. This also helps the end user to clarify their doubts and get rid any reservations or inhabitations that they have. The phased manner approach that the organization is implementing makes it possible systematic automated system.

CONCLUSION

After completing the proposed system successfully it is worth to talk about the limitations and advantages of the system.

LIMITATIONS:

This system is capable of fulfilling the current requirements, but it is required to make modification to meet the future requirements. Disk space to increased when information increases.

ADVANTAGES:

As all the screens are self explanatory it is easy to work with the system with a little training for new operator. The system eliminated the problem of the existing system and enhances its capability.

Inventory Management System is a system which is used to keep track of sales and purchase of electronic goods. Its main objective is to keep track of stocks, sales and purchase of goods, maintain staff and customer information and generate reports.

The main functionalities of this system are as follows:

• To maintain information about current availability of stock based on which it decides whether there is a need to purchase goods, if they are out of stock.
• To display the information about dealer and also add information about new dealer.
• To maintain the information about staff, their personal details such as contact number, name, address, qualification, birth date, etc.
• To maintain the information about customer who visit the store for shopping.
• It also provides discounts to customers who frequently visit the shop and purchase goods.
• To provide information regarding sales and purchase of goods.
• To provide information about sales summary.
• The system can be accessed by administrator and accounts department.
• It provides the functionality to create new user who can access the system.
• It also provides the records of the defective products which the customers return back to the shop for replacement.
• It also generates the purchase bill.

Project Scope

This document covers the requirements for the Inventory Management System. This Software will provide a graphical environment in which the users of the system will be able to perform various operations that are associated with storing, marinating, updating   and retrieving Stock information. The purpose of this is to guide developers in selecting a design that will be able to accommodate the full-scale application.

Product Perspective

The product Inventory Management system, is an independent product and does not depend on any other product or system. The product will automate various tasks associated with handling stock details and better organizing the Megastore information and  optimum performance, thus helping  the manager to ensure smooth working of these processes.

Product Features

The product, IMS will automate various tasks associated with handling stock details. The software will be used by the Megastores to Megastore the details of new and existing product. Periodically it will be used by the Megastores to input the total sales and sales rate information after the month/years. His software inherently makes automatic calculations on sales rate. And all this information is accessible to administrators and manager to keep track of their selling progress of the product. Also the software has a provision that will allow administrators to print the required reports of various products .

User Classes and Characteristics

This software gives access to 2 kinds of users.

Administrator: The manager and Megastore administrator will have administrator access to add, delete and modify information Megastore in the database.

Authorized User: computer operator staff will have access to only view the data Megastored in the database in the form of formatted reports.

System Features

Login

Description and Priority

The login form is used all the users. This module has the highest priority when compared to all the other modules. This model allows the the user to enter his username and password in order to make use of the software.

Stimulus/Response Sequences

This module has text boxes where the user can enter the his username name and password. If the necessary information is not provided or if invalid inputs are given by the user then the system will pop a message box.

Functional Requirements

Only authorized users are allowed to login.. If invalid user Name or password is given by the end-users then system should inform the user. If Unauthorized   users try to access then it should not allow the user to work on the System.

Data Entry module

Description and Priority

This module is used by data entry operator who is responsible for entering the details of products. The module requests that the Data entry Operator specify the function he/she would like to perform (either Add a product, update a product, or delete a product details).

In “Update a product” Once the Data entry Operator updates the necessary information ,the system updates the product record with the updated information.

In “Delete a product” Once the Data entry operator deletes the record, the system prompt s the user to confirm the deletion of the product.

Stock Entry Module

Description and Priority

This module allows the stock entry operator to add, delete or modify the product information from the system.

Stimulus/Response Sequences

The system requests the stock entry staff to specify the function she/he would like to perform(either Add stock, Update stock, Delete stock and Generate Report)

Functional Requirements

In “Add stock” Once the stock entry clerk provide the requested information, the system saves the stock and an appropriate message is displayed.

In “Update stock” the stock entry operator makes the desired changes to the stock details and at the same time the database will save the changes that are made by the stock entry operator.

In “Delete stock” if the clerk wishes to proceed with the deletion of the record on click of this the record is deleted from the system.

In “Report generation” the computed result of a particular product is displayed.

Download the complete Grocery Inventory Management System PHP & MySQL Project.

This project implements a network print spooler, which can accept multiple simultaneous print requests and handle them gracefully. The Client and Server architecture is built to receive the print requests from various users and aggregate all request in the server and manage them effectively according to the prioirity / rights / privileges of each and every user in the network.

The administrator of the network who is nothing but spooler manager can reorder jobs and remove any jobs from the queue and he as the final discretion as far as the processing of print requests are concerned .This project ensures the Network Sprint Spooler supports multiple requests from different users at the same time. In the Server, the queue status is displayed and the spooler manager re-orders the jobs and remove any jobs from the queue at his discretion.

The first is a client program that interacts with the user for accepting print requests of their documents files. The Client Program sends the request to the server program that runs in the network server to which the all the systems and printer are connected. The server program of this project  accepts requests from clients over the network, and serves them according the rights / permission / privileges.

The connection between the Client program and server program is established by using TCP/IP protocols using the .NET components. The management hierarchy of the company is studied and the access rights, permission and privileges of each every user of the network printer is given and configured in the Server program of the project.

The administrator ie. Spool Manager is the authorized person to login with the administrator username and password and login and configured the rights and permission accordingly to the respective users.

MODULES:

1. Client –server architecture establishment module.
2. Client side request processing module.
3. Server side request processing module.
4. Rights and permission checking and process module.
5. Reporting and administration module.
6. Client side request processing module:

In this model the client login into their resource by using login and his password. The client in the particular network will send a request to the server in the network. The request is about to take print in the network and ask whether the Printer are connected with the network and the request may be delete any. The response may be printer is connected in network, client can give request to see their file in server buffer to take print out, it can also delete any document file has been in server buffer by given request to server by him.

3) Server side request processing module:

In this module all the request from the client are process according to their priority. And all the request is process according to client request the response will be send the clients. The response may be yes printer is connected u can send the file or print is not connected so wait for some time.

4) Rights and permission checking and process module:

In this module the client will send set of files to the server to take print out. And that set of files will be store in the queue. The entire request from the server will process and find out he is authorized client if he is authorized client his request will    be store in queue and priority will be allocated according to the request time from the client and output will be given to the user. Using this module support display of the queue status, and allow users to remove their own jobs from the queue are delete according to the client request.

5) Reporting and administration module:

The administrator can login their area by admin user name and password. Admin is the one he has authority to control all the client system in the network. he has authorized   person to process all the request and send response to all the client in the network.

INTRODUCTION

This Remote Device Explorer System project is done specifically catering to the requirements of the educational institutes Computer Laboratory.   We create a Client Server architecture where in the Clients  software runs in  all students and staff systems and the server is maintained in the Network administrator System.

The Students and Staff ip addresses are maintained separately in a database.We use separate colors like green , red etc for identifying which of those system pen drive is accessed.  We track the various activities of the students and staff like taking print outs, Reading and writing CDs also files accessing , creating and modifying it.  We use VB.NET which is an Object Oriented Programming Language for the Construction of Client Server architecture. We use Sql Server  for storing the data like Ip address of the system etc.

For the alerts of various hardware and software usage, we use Special Controls in .net Platform. This Remote Device Explorer System project will help the network administrator to track the accessibility of its various node and  to monitor any misuse of the system resources.  At times, virus software which often get transmitted into the network through the pen drives is to monitored carefully. Also, the reports can be taken day wise or month wise etc for the usage of various network resources. This facility will enable the administrator and the management incharge to take necessary precautions in future to avoid any misuse of the Network resources.

Modules:

Modules:

1. Identifying Systems in Network Group.
2. Registration of Admin / Staff/ Student System.
3. Monitoring of System Peripherals.
4. Monitoring of Software Applications.
5. Performance Comparison by admin.

Modules Description:

Identifying Systems in Network Group:

In this module, we are going to identify the number of System which all connected in the network. And all the system in the network has been categories by Admin, Staff, and Student.

Registration of Admin / Staff/ Student System:

In this module the user in the network has been register according to their category and authority. Admin is the one he has authority for monitoring and controlling the whole network (Staff/Students).The Staff in the network can register in the network by selecting user name and password (unique) according to his need. The Students in the network can register in the network by selecting user name and password (unique) according to his need. All the user name of student/staff has been maintain by the admin and admin user name and password has been maintained very secret in the network.

Monitoring of System Peripherals:

In this module server will monitor the number of user (students/staff) in the network and start monitor them. The admin will monitor that who are all using peripherals device like Pen drive, CD, Printer.

Monitoring of Software Applications:

In this module admin will monitor the user (staff/students) process by files, document, application used by users by file watcher, it also check client connection, web application also.

Performance Comparison by admin:

In this module the admin will calculate the performance of each user (staff/students) in the network by their process, and activity done in the system.

1. Identification of Admin / Client System

In this module, Server identifies the clients which are connected in the network. Server also categories the Client system as student and staff.

2. Monitoring of Remote Devices

In this module, Server get access to all clients which are using the Remote devices such as Pen drive, CD, Printer etc., also Server can get the details of processing of files and documents of clients by File Watcher.

3. Monitoring by Administrator

In this Module, Administrator monitoring the Remote Devices which are get connected in network. And also monitoring the individual access of the client , servers and remote devices.

Existing System :

1) The hardware and systems are maintained only by using the Operating System security features.

2) No Usb slot access control are available.

3) No Acess control and tracking mechanism implemented for CDs,printers and Scanners.

4) No virus protection is updated and maintained.

Proposed System :

Remote Device Explorer System is designed in such a way to categorize as staff and students systems. These IP   addresses are updated in a separate database to monitor each system based on category wise.   RDESServer has the user interactive GUI to display various device status from remote systems.

The colors like green, red are used for identifying staff and students system respectively which of those USB drive is accessed. Also the working status of various devices such as CDs, printers, scanners is tracked in this system.

RDESServer additionally has File monitoring facility such as creations, modifications and deletions of the files from remote systems. Remote Device Explorer is an enterprise endpoint security software solution providing network administrators with the ability to secure, monitor and control computer ports and external devices as part of an information security program.

The solution protects against internal data leakages occurring when confidential data is printed or copied from internal workstations and laptops to unauthorized portable storage devices through unmanaged USB, LTP, COM, Firewire and IEEE 1394 ports.

Advantages of Proposed System :

1)    Any hardware added to the network can be monitored and controlled for access.
2)    The integrated solution for complete network monitoring and maintenance is possible.

3)    The Reports functionality enables the administrator to bring about accountability
To the network access.

4)    This proposed Remote Device Explorer System protects the internal data leakage.

5)    The device explorer system is far safer and sophisticated compared to the operating system security features.

SOFTWARE SPECIFICATION:

Environnent : VB.NET

Back End : SQL SERVER

Abstract: Shares are issued when it is incorporated, or whenever it needs to raise more capital for new ventures expansions. The approval of the registrar of companies (ROC) and the securities and exchange board of India (SEBI) is a necessity.

Synopsis

A computerized share management system would be able to handle the following functions.

Modules

• Maintain shareholders details and the share kept by them
• Keep track of share transfer
• Generate divided warrants
• Provide information on shareholdings to the company management
• Generate statuary reports
  

ABOUT THE PROJECT

INTRODUCTION

Share Management System is an application which manages the shares of a company. Every organization tries to build up their resources and increase their business.For increasing the business they need lots of funds.Raising the funds are of so many types among which issuing of shares is one of the methods.After issuing the shares a private sector converts to a public sector.When an organization becomes a public sector the responsibility and accountability also increases.

EXISTING SYSTEM

The Existing System is not a computerized system.In this method and dependency of human and paper work is lot.As it is depending on the human beings the processing of each and every transaction takes more time.Even though the computers are implemented the data is not centralized.Which leads to lot of difficulties.All  the transactions made by officials and customers needed to be recorded in their individual systems.And the security and privacy of data is always an issue.In order to have a secured database and centralized server the system is to be changed.

PROPOSED SYSTEM
A Proposed share management system is for removing all the disadvantages and difficulties raised by the Existing System.The proposed system is to create a complete application on the basis of client-server architecture.
The system is to provide a website for the shareholder through which the shareholders are get informed in every bid of the share.The facilities needed to be provided for the share holders are :

1.Online Applying for Shares

2.Online Share transfer Facilities

3.Daily Purchase and sales reports

Apart of creating a website for shareholder the system is to provide easy a management system for official and management where management can check out applications for the shares and allot the shares for individual customers.Where the system takes care of auto-generation of folio number and allotment of shares done properly.

For the officials the system is supporting with issuing of shares generating certificates and maintaining  the certificates details.

DEFINITION

Share management system refers to keeping track of the ownership of the shares of a company. A share represents part of a company. The shares department of this company maintains a share register to record details of each shareholder, including the number of shares he owns and the share certificates he holds.

DESCRIPTION

The Share Management System consists of three modules.

1.Share Holder

2.Management

3.Official

Share Holder

A person who applies for the shares will become as a share holder to that company.Each share holder is identified by a unique folio number .With this number only he/she can do all his/her transactions

Management

Management is nothing but the company who issues shares into the market based on their assets and in-order to increase their investment.Management will decide how many shares has to allot to a particular person and dividends also decided by the management.

Official:

These are the middle mans between the share holders and the management.These people are meant for the data entry purpose and for doing the share transactions.And also he/she will give information to the share holders regarding their share information.