My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
Development of a Product Master Maintenance system.
Posted Date: 19 Mar 2008 Resource Type: Articles/Knowledge Sharing Category: General
|
Posted By: Aparanjitha Member Level: Gold
Rating:  Points: 5
|
|
|
Title of the project
Development of a Product Master Maintenance system.
Abstract of the project
This project 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.
Keywords
Generic Technlogy keywords
Databases, Programming
Specific Technology keywords
VB, MS SQL Server
Swing, EJB, Oracle
Project type keywords
Analysis, Design, Implementation.
Functional components of the project
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
- Family
- Class
- Product
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 of Family.
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.
Mark the product as active or defunct.
Modify any attribute of the project.
(c) 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),(c),(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
There are couple of alternatives to implement such a system.
A. Microsoft platform: The system is developed using VB as the
front end and SQL Server 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.
1. Study and be comfortable with technologies such as
VB and SQL server.
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.
|
Responses
|
| Author: Saravana Muthu M 22 Jun 2008 | Member Level: Bronze Points : 2 | Dear Aparanjitha,
I have seen your post regarding the "Product master maintenace System". I work for a Leading software company , Chennai as software developer. I can contribute my role as a Free lancing Developer (saravanamuthu.m@gmail.com) for the Project you have mentioned here. I have a good experience (5 Years) in developing Database Softwares through my professional work as well as through my previous Freelancing Projects I have handled through VB, Oracle, Access, SQL. The Unix platform based alternative I cant go for as I am not confident to do that. But the Windows based one is very well within my ablity level. A number of Projects I handled includes as follow: Online Learning System Management, Tour Package Reservation System, Library management System, Employeee Time Monitoring System, etc.,. Hence I can accomplish the project for you in a short term of (Max 1 Month) and at a very much reasonble cost. Kindly Let me know If you are interested in my profile I can send you some brief capability report of mine for evaluating my skill set for the same.
|
|
Watch TV Channels
|