Product Master Maintenance system
Active In SP
Joined: Apr 2010
31-05-2010, 12:24 AM
Title of the project and implimentation
Development of a Product Master Maintenance system.
Abstract of the project and implimentation
This project and implimentation is aimed at developing an online product master maintenance system used in a manufacturing industry. The Product Master Maintenance (PMM) is a client server based application that can be accessed by a selected group of users. This system can be used for maintaining all the details related to a product like Product hierarchy, product/subÃ‚Â¬components attributes(cost/size/weight etc.) and supplier details. There are additional features like user access control, report generators etc in this system.
Functional components of the project and implimentation
Following is a list of functionalities of the system. More functionalities that you find
appropriate can be added to this list. And, in places where the description of a functionality
is not adequate, you can make appropriate assumptions and proceed.
Following tasks can be performed with the application :
(a) User Maintenance : Granting & Revoking access to users on application
b) Product Maintenance : A user should be able to :
Â¢ Create a new product with attributes.
Â¢ Define the hierarchy of product. The hierarchies can be defined as
Â¢ Relate a product to another product which is higher / lower in hieararchy
using parent-child relationship. ie. Product is child of Class and Class is child
For example an automobile manufacturer can define following hierarchy
Family â€œ Car
Class â€œ Hatchback
Product â€œ Maruti 800
Family â€œ Car
Class â€œ Sedan
Product â€œ Maruti Esteem
Family â€œ Van
Class â€œ Delivery
Product â€œ Maruti Omni
Family â€œ Van
Class â€œ Passenger
Product â€œ Maruti Versa
Â¢ Add a supplier for the project and implimentation.
Â¢ Mark the product as active or defunct.
Â¢ Modify any attribute of the project and implimentation.
© Supplier Maintenance : Allow the user to Add and Modify a supplier.
(d) Find User : A search screen to find users and display results.
(e) Find product : A search screen to find products and display results.
(f) Find Suppliers : A search screen to find suppliers and display results.
(g) Report : Generate reports on product hierarchies, suppliers etc.
Accordingly there would be following levels of user privileges :
Â¢ Application admin having all privileges.
Â¢ Users having privileges for (b),©,(e),(f) & (g).
1. A user should be able to
Â¢ Login to the system through the first page of the application.
Â¢ Change the password after logging into system.
Â¢ Add and/or Modify a product.
Â¢ Add and Modify details about a Supplier.
Â¢ Relate a product to a supplier.
Â¢ Generate product and supplier reports.
2. The Application Admin should be able to do the following tasks in addition to 1 :
Â¢ Add a new user.
Â¢ Remove a user.
Steps to start-off the project and implimentation
There are couple of alternatives to implement such a system.
A. Microsoft platform: The system is developed using ASP.NET \VB.NETas the
front end and SQL Server 2000/2005 as the back end.
B. Unix-based platform: Swing as front end,
EJB / Java programming, any relational database (eg Postgress / Oracle /
My SQL), and tools in Unix
The following steps will be helpful to start off the project and implimentation.
1. Study and be comfortable with technologies such as
VB.NET/ASP.NET and SQL server 2000/2005.
Unix commands, Shell programming, Java Programming, SQL.
Some links to these technologies are given in the ËœGuidelines and Referencesâ„¢
section of this document.
2. Gather some knowledge of product hierarchies and maintenance before starting the
design. Have a full-fledged example with several products and sub-components etc for
testing the application.
3. Create a user database with different access levels.
4. Start with creating the login screen.
5. Create menus for navigation and group the functionalities as sub menus.
5. Create the help-pages of the application in the form of Q&A. This will help you also
when implementing the application.
Use Search at http://topicideas.net/search.php wisely To Get Information About Project Topic and Seminar ideas with report/source code along pdf and ppt presenaion