02-06-2012, 01:49 PM
Departmental Store Management System
Departmental Store Management System.pdf (Size: 511.8 KB / Downloads: 199)
Abstract:
In recent years computer automation has become of great importance in business and
service sectors. Our project is a simple demonstration of automation of a departmental store
management system using Oracle, world‟s most popular relational database management
system.
Software Description
Main Features:
Departmental Store Management System (DSMS) will be capable of managing daily
sales, purchases, damages, expenditures etc.
It can store information of a product in depth in a very structured way.
Invoices are created and can be printed whenever the shop sells, buys, returns, or
report damages.
The interface of the system will be user friendly and as simple as possible yet
powerful requiring little training of sales manager.
The following paragraphs describe the various features of different parts of the
software.
Software Users:
During the design phase of DSMS software we tried to identify the different
categories of user that would be using this software. It was apparent that some guy who is a
sales person need not to access to employee or product manufacturer‟s details. Similarly a
purchaser need not worry about preparing an invoice. Such thoughts led us to classify the
users in three categories – Administrator, Seller and Purchaser. We then had two options -
firstly we could build one integrated interface including all features, then showing only the
appropriate features to a user, Secondly we could build three separate interfaces for the three
categories each implementing category specific features. The first one had some drawbacks
such as clutter and lower level of security, so we chose to go on with the second option. We
ended up having three interfaces for Administrators, Seller and Purchaser.
Product:
All the product related functionalities are grouped under the „DSMS - Product
Explorer‟ form. Here the admin can add new products, modify the data such as product
name, manufacturer name and address, minimum stock limit, unit description, product
category and subcategory. The admin can also search product based on product id, product
name, manufacturer name, product category and subcategory.
Order:
All the order related functionalities are grouped under the „DSMS – Order Explorer‟
form. Here the admin can see the auto generated orders by DSMS, create new orders and
explore all the currently placed orders.
Supplier:
All the supplier related functionalities are grouped under the „DSMS - Supplier
Explorer‟ form. Here the admin can add new suppliers, modify supplier data such as supplier
id, supplier name & address, supplier ratings and add the new products to the currently
selected supplier‟s supply list.
Employee:
All the employee related functionalities are grouped under the „DSMS - Employee
Explorer‟ form. Here the admin can add new employees. Modification of employee
information such as address, telephone number, salary, job title, work status, resignation date
was not implemented due to time limitation but scope is there.
Manage User:
All the user related functionalities are grouped under the „DSMS - User Explorer‟
form. Here the admin can add new user and modify user information such as user id and
password. The admin can also explore all the users of this software both present and past
under the „All Users‟ tab. The admin can also see the complete log on and log off time
information under the „view User Log‟ tab.
Damage and Expenses:
We did not implement damages and expenses functionality due to time limitation but
scope is there for this functionality.