RUBBER PRODUCTS MANAGEMENT SYSTEM - Weebly
RUBBER PRODUCTSMANAGEMENT SYSTEMPROJECT REPORTMAJOR PROJECT REPORT SUBMITTED BYAnilkumar Harihar PandaSeat No. : 2527Under The Guidance ofProf. Shaila SunderDepartment Of B.Sc.IT NAGINDAS KHANDWALA COLLEGE OFSCIENCE PRATIMA ENTERPRISES Pratima Enterprises MFG. of Rubber Products A/2, Laxmi Nagar, Link Road, Behind KaaliMata Mandir, Goregaon (W), Mumbai - 400090. Date:25/04/2012 This is to certify that ANILKUMAR HARIHAR PANDA Student of Third year B.Sc.(IT) (Bachelor of Science Information Technology) of NAGINDAS KHANDWALA COLLEGE OF COMMERCE,ARTS & MANAGEMENT STUDIES & SHANTABEN NAGINDAS KHANDWALA COLLEGE OF SCIENCE (University of Mumbai) have successfully completed their project entitled “RUBBER PRODUCTS MANAGEMENT SYSTEM” for PRATIMA ENTERPRISES during in year 2011-12 using NetBeans 7.0.1(JAVA) and MICROSOFT SQL Server 2005.Place : Mumbai Company Stamp Pramod Sahu (Proprietor) ACKNOWLEDGEMENT It is nearly impossible to thank everyone who is involved in the process of taking theconcept of the ‘Rubber Products Management System’ to a live running project of the same. This book is the direct result of the help of all the people who directly or indirectly helped us in making the project successful. First of all I would like to thank GOD for providing me with the potential and rightdecision power on right time to make this project possible. The satisfactory completion of this project is not merely due to my efforts but also due to valuable guidance recommended by our internal guides and the requisite infrastructure and facilities made available by our college. I also express our sincere thanks to the staff of ‘NAGINDAS KANDWALA COLLEGE’ , our project guide ‘Prof. Shaila Sunder’ and ‘Prof. Kiran Raorane’ for their unstinted co-operation and support, which resulted in successful completion of the project. We wish to express my gratitude to Pratima Enterprises for allowing us to carry out this project. It's really a great pleasure to work for such an organization. At last I would like to thank my friends who encouraged me and shown a great interest in my work to make me confident about my work and hence getting the great potential to workahead. iNDEXSr.No. TitlePage No. 4.6Structure Chart Diagram 68-69 1.2Description Of System 8 1.3 Present System 9 1.4Limitations of the present system 10 1.5Proposed system and its advantages 11 1.6Feasibility Study 12-13 1.7About The Technology 14-17 1.8Database (MS SQL) - An Overview 18 1.9Stakeholders 19 1.10Gantt Chart 20 2Software Process 21 2.1Software Development Process Model(Spiral) 22-23 3System Analysis 24 3.1Fact Finding Techniques 25-26 3.2Screen Layouts & Report Layouts 27-36 3.3Event Table 37-39 3.4Use Case Diagram and Use Case Description 40-43 3.5Entity Relationship Diagram 44-46 3.6Activity Diagram 47-48 3.7Class Diagram 49 3.8Object Diagram 50 3.9Sequence Diagram 51 3.10Collaboration Diagram 52 3.11State Chart Diagram 53-54 3.12Data Flow Diagram(DFD) 55-58 4System Design 59 4.1Converting ERD to Tables 60-61 4.2Component Diagram 62 4.3Package Diagram 63-64 4.4Deployment Diagram 65 4.5System Flow Chart 66-67 4.6Structure Chart Diagram 68-69Sr.No. TitlePage No. 5System Coding 70 5.1Menu Tree 71-72 5.2List of tables with attributes and constraints 73-76 5.3Program Description 77 6System Testing 78-80 6.1Test Cases 81 6.2Validations 82-87 7Cross-platform Java executable wrapper(Launch 4j) 88 8Future Enhancement 89-91 9Conclusion 92-93 10References and Bibliography 94 PRELIMINARY INVESTIGATION 1. Preliminary Investigation 1.1 Organizational Overview:We are pleased to introduce ourselves as a manufacturer of 'Rubber Parts'. From the humble beginning as a manufacturer, 'Pratima Enterprises' has come a long way in a short span of time, in being one of the premier manufacturer and exporter, it has built up its image which symbolizes commitment, quality and class.Our focus remains on innovation and offers the consistent quality at a price which gives the best value for money and is constantly adapted to meet the need of the customers. Our company believes in Quality Service and long term Relationship. We are into business since last three years. No wonder that every designer front guard or carrier is a work of art, an expression of emotion that has been honed to perfection.We always believe innovative in developing ideas and supplying best rubber product items in the closest possible partnership for creating mutual trust and growth. ?The diverse range of rubber product we provide is used for several purpose throughout the world. Countries spanning all continents have acknowledged and appreciated our rubber product and our services.Now by the use of Rubber Products Management System provided by the students of NAGINDAS KANDWALA COLLEGE Mr. Anil Panda. We look forward to enter the global market in a more systematic manner. Moreover it would be of great help as it automates our current system of handling and storing records.1.2 DESCRIPTION OF THE SYSTEM:My system is based on NetBeans IDE 7.0.1. It is a Rubber Products Management System where the administrator can work on it different processes like Order, Production, Salary, etc. The database language used is Microsoft SQL Server 2005.Through this system the admin or the user can easily perform their work. So to make the work run comfortably and to save time and energy this software is being implemented. The administrator can get the record of any at whatever time he needs using this system.Introduction to the Project:The main aim of developing Rubber Products Management System is to build a user friendly, efficient and robust system that will handle all operations related to the company. Here, we have build a management system to automate the working of the organization. We provide our customer’s customer secure access to their own personal information. All the information will be stored in consistent and structured format which will allow easier retrieval of data. The system is Management Oriented.Our application is build to eradicate present file system used by the organization to store and maintain records. The data is stored in a structured and consistent format which can be used by the organization to generate reports.The project aims to develop software which will store data about their different Customers, Products and Orders. There are different types of services provided by this project like Sales, Purchasing and Other services. This system provides Various Report Facility That can give a view of Summary Account with Graphics User Interface (GUI). Objectives: The objective of the project is to create a system that:Provides Secure Login.Provides GUI to user for Data EntryHandles and store data in consistent and structured format.Provide user to retrieve and edit data on a clickLess prone to errorsEfficient data storage that will reduce the redundancy of dataLess chances of information Leakage1.3 PRESENT SYSTEM: In the current system, the company work done is totally manual. First of all the management has to manually keep all the information regarding the Stock, Supplier and Customer, etc,Whenever a Customer enquiries or Order for any product, the management quotation for that product. The information regarding the quotation is kept in the files. The management the calculates and make an order form mentioning the amount of raw materials required in regards with the customer’s order which is again stored in files for future reference. Before making the order form the supplier details are checked from the files. If for a particular Customer order, the required product is consumed then the remaining product information must be updated in the respective files. When certain products are purchased then that again must be updated in files. Moreover while delivery of finished products customer make an Invoice manually. So, in the current system all business transactions are made manually and many files and register are maintained and written work is more.1.4 LIMITATION OF THE PRESENT SYSTEM:In the Companies most of the work is done manually.This involves many limitations such as: Increases the paper workThe time to access the data increasesFrequent visit by customer for their product query and enquiryChances of Information Leakage or Loss of Information increasesMaintaining records is not IntegratedDuplication of data is possibleTransaction’s is very much costly and Insecure1.5 Proposed System and its Advantages:Proposed System:The proposed system helps the administrator or the user to enter the data very fast and with greater security.To overcome the difficulties and constraints that are in the present manual system, one can say that the computerized system can solve many problems to a certain extent. Hence, my project serves in interacting with many of the work process that is taking place in the company. The computerization of the inventory control system is more users friendly and reliable.The project will convert the legacy system used currently by the organization into an automated system. It will help them in saving all the required data into one organized database System. Our project will help to generate reports which will help the company to have an overview on their loss or profit by using the data in the database.Different modules included in this system are as follows:1. Login form module,2. Order module,3. Production module,4. Inventory module,5. Summary Account module,6. Backup Connection module,7. Payment module, etc.Advantages of the Proposed System:Computerizing will automate the Order Processing System (OPS).The system also maintains the description of the suppliers along with its products that they sell. This will decrease a lot of time in identifying the details of the suppliersThe system gives customer and supplier a unique identity so that they can be easily identified.Automated computerized system will decrease manual work to some extent and improve work performance.There is also a provision for producing reports that management needs for planning and control which can be then exported to Excel sheets.Last but not the Least our software allows the management to backup and restore the database. In Order to be sure that there is least data loss even if the is a database failure or the system crashes.I provide many of the features like Notepad, Calculator, Calendar and Time. 1.6 FEASIBILITY STUDY:To fulfill the requirement of the organization, acceptance criteria are needed. The user specifies all the needs that they want in their system by giving necessary data. When the developer develops the system he has to take all points into consideration and proceed accordingly. Once, when the system is completed the developer needs to check whether it fulfills the criteria of the user. If it is fulfilled then the user accepts the system. This acceptance criteria depends not only on the designing but also the study of feasibility. So it is necessary to study the feasibility of the system. Feasibility study is to determine whether the solution is feasible (achievable). Three major areas of feasibility are – SCHEDULE FEASIBILITY:Schedule feasibility involves completion of different states of the project in thegiven time.As my software will be completed in the given time period only, it is feasible forthe client. Also in between, different phase completion will be shown to the client whichensures that the project is being made for them.OPERATIONAL FEASIBILITY:Operational feasibility includes whether the software is feasible for the operationby the client. The client is having the ability to do the operation of different softwaresused for the system.Visual Studio 2008 is being used for this software. As the client is having theknowledge to operate this, it is feasible for them.Microsoft SQL Server 2005 is used to maintain database. Thus the user canmaintain the database as the SQL is well known to the user.Thus the software is feasible for the operation. Thus the project is operationally feasible. Sources of information: Information is gathered from the owner of Pratima Enterprises and available Reports. Economic feasibility: Since the project is being pursued as a course assignment, the main costs associated with it are training materials and computing resources. And as the organization has shown faith in us and given us a chance to develop a system for them we will cost them only some of their precious time and some companies resources like their reports. TECHNICAL FEASIBILITY:Technical Feasibility involves different requirements for the system. Different hardware and software requirements are specified below as per the system. HARDWARE & SOFTWARE SPECIFICATION 1: Hardware specification: Our System Required: ? 15GB of Hard Disk ? 512MB RAM (minimum) ? Processor Pentium 4 or newer versions ? Printer 2: Software Specification: Our System Required: ? Operating System: – Windows XP or higher version ? Java Runtime Environment (Version 1.1 to 7.0) ? Front end:- NetBeans IDE 7.0.1 ? Back end:- Microsoft SQL Server 2005Thus the system software is technically feasible for the admin or the user to use it.1.7 ABOUT THE TECHNOLOGY:JAVAJava Runtime System:Source CodeCompiler.Class fileJVMJava InterpreterJava Runtime EnvironmentJava is a high-level programming language developed by Sun Microsystems. Java was originally called OAK, and was designed for handheld devices and set-top boxes. Oak was unsuccessful so in 1995 Sun changed the name to Java and modified the language to take advantage of the burgeoning World Wide Web. Java is an object-oriented language similar to C++, but simplified to eliminate language features that cause common programming errors. Java source code files (files with a .java extension) are compiled into a format called byte code (files with a .class extension), which can then be executed by a Java interpreter. Compiled Java code can run on most computers because Java interpreters and runtime environments, known as Java Virtual Machines (VMs), exist for most operating systems, including UNIX, the Macintosh OS, and Windows. Byte code can also be converted directly into machine language instructions by a just-in-time compiler (JIT). Java is a general purpose programming language with a number of features that make the language well suited for use on the World Wide Web.PrinciplesThere were five primary goals in the creation of the Java language :It should be "simple, object-oriented and familiar"It should be "robust and secure"It should be "architecture-neutral and portable"It should execute with "high performance"It should be "interpreted, threaded, and dynamic"NetBeans IDE 7.0.1 Release InformationThe NetBeans IDE is an award-winning integrated development environment available for Windows, Mac, Linux, and Solaris. The NetBeans project consists of an open-source IDE and an application platform that enable developers to rapidly create web, enterprise, desktop, and mobile applications using the Java platform, as well as PHP, JavaScript and Ajax, Groovy and Grails, and C/C++. The NetBeans project is supported by a vibrant developer community and offers extensive documentation and training resources as well as a diverse selection of third-party plug-in. Release OverviewNetBeans IDE 7.0 introduces language support for development to the Java SE 7 specification with JDK 7 language features. The release also provides enhanced integration with the Oracle WebLogic server, as well as support for Oracle Database and GlassFish 3.1. Additional highlights include Maven 3 and HTML5 editing support; a new GridBagLayout designer for improved Swing GUI development; enhancements to the Java editor, and Beans IDE 7.0 is available in English, Brazilian Portuguese, Japanese, Russian, and Simplified Beans IDE 7.0.1 includes the following notable changes:Full JDK 7 support: Running NetBeans IDE on top of JDK 7 and support for the final version of the JDK 7 language featuresIntegration of the recent patchesPerformance improvementsFeature HighlightsJDK 7 Project Coin supportEditor enhancements: Code completion, hintsWebLogic ServerStreamlined and faster deployment to WebLogicNew server runtime node displaying deployed applications and resources JSF integration with server librariesOracle DatabaseSimplified connection wizardGuided installation to JDBC driverEditing and deployment of stored proceduresGlassFishGlassFish 3.1 support Domain restart and log viewer for remote GlassFishEnable and disable deployed applicationsJavaMaven 3 supportJUnit 4.8.2 integration and various JUnit improvements Remote HTTP URLs supported for Javadoc in libraries and Java platforms New improved visual customizer for GridBagLayoutJava EEImproved support for CDI, REST services and Java PersistenceNew support for Bean Validation Support for JSF component libraries, including bundled PrimeFaces libraryImproved editing for Expression Language in JSF, including code completion, refactoring and hints Web LanguagesHTML5 editing supportJSON formatterPHPGenerate PhpDocRename refactoring, Safe Delete Refactoring PHP 5.3 - Support for aliasesC/C++Easy import of project from user's existing binaryNew Project type where user's source files are located on remote systemNetBeans PlatformAnnotations for generating Action registrations in the layerPerformance enhancements & tight integration with ProfilerAdditional NetBeans API changesGeneralWord wrap in EditorEnhanced Profiler integrationLess intrusive checking for external changes when switching between the IDE and other programs.1.8 Database (MS SQL) - An Overview:A Database is a single organized collection of structured data stored with a minimum of duplication of data items so as to provide a consistent and controlled pool of data. This data is common to all users of the system but is independent of programswhich use the data. The independence of database and programs using it means that they can be changed without changing the other. The users of the database may find it convenient to imagine that they are using integrated file system. RDBMS RDBMS is an acronym for relational database management system and can be defined as data program for general purpose data storage and retrieval that organized data into table consisting the same set of data items(columns). The data is stored in the Kernel to maintain data security. RDBMS is the database in which multiple tables can be associated or related to one another based on common data items or files within the tables. RDBMS provides a way of doing tasks in an understandable and reasonably uncomplicated manner.For Example, a name and address file might columns for name, street, city, state, pin and phone number.A record can be created for each person by filling each field. An another table consists of the name, employer’s name and dept. The two tables holds a relationship where each person has an entity.One of the major features of RDBMS is the ability to generate a new file with data from two related files.Functions of RDBMS : The most important functions of RDBMS are as mentioned below:Defines databaseModifies structure of databaseQueries the databaseAdds and deletes the databaseControls the databaseSecure Access from public usersCommunicate within networkExport and import of data. 1.9 STACKHOLDERS:Stackholders are those persons who are successfully involved in completion of the project at the specified time period. Different stackholders included in the completion of the project are :The Client or Administrator :He is the one for whom the project is being made. He is successfully engaged for the completion of the software as soon as possible.The Technical Staff:They are the people who provides guidance in area of programming language to the programmer. The guidance is given to the student or the programmer so that he can complete the given project properly.The Creator or Programmer:The student itself is the programmer who wants the project to be completed in the specified time. He is the main stackholder for the project.10.10 Gantt chart: GANTT CHARTSr.No. ProcessesExpected (days)Completion(days)Start date End dateDecJanFebMarApr 1. System Feasibility 11 1010/12/201120/12/2011 2. Requirements Analysis and Project Planning 20 21 21/12/2011 09/01/2012 3.System Design 20 2210/01/201202/02/2012 4. Coding 45 4503/02/201218/03/2012 5. Testing and Integration 10 819/03/201227/03/2012 6. Installation, Operations and Maintenance 6 520/04/201224/04/2012 Completion Period Expected Period SOFTWARE PROCESS 2. Software Process A software process is a set of activities, together with ordering constraints among them, such that if the activities are performed properly and in accordance with the ordering constraints, the desired result is produced.2.1 Software Development Process Model:? In the software development process I focus on the activity directly related to production of the software , for example, design, coding, testing.? As the development process specifies the major development and quality control activities that need to be performed in the project, the development process really forms the core of the software process.? The management process is decided based on the development process.? Due to the importance of the development process, the spiral model hava been proposed. Spiral Model Figure:Introduction:? The spiral model is another iterative model that has been proposed.? As the name suggests, the activities in this model can be organized like a spiral that has many cycles as shown in Figure.? Each cycle in the spiral begins with the identification of objectives for that cycle, the different alternatives that are possible for achieving the objectives and the constraints that exist.? The next step in the cycle is to evaluate these different alternatives based on the objectives and constraints.? The focus of evaluation in this step is based on the risk perception for the project.? The next step is to develop strategies that resolve the uncertainties and risks. This step may in- volve activities such as benchmarking, simulation, and prototyping.? Next, the software is developed, keeping in mind the risks.? Finally the next stage is planned. Generally, a version of the product is released that contains some capability.? The first version contains some core capability and more features are added to later versions.Use:? One effective use of the spiral model is often seen in product development, in which the developers themselves provide the specifications and therefore hava a lot of control on which specifications go in the system and which stay out.The main reason:? As businesses are changing very rapidly today, they never really know the complete requirements for the software and there is a need to constantly add new capabilities to the software to adapt the business to changing situations.? Furthermore, customers do not want to invest too much for a long time without seeing returns.? In the current business scenario, it is preferable to see returns continuously of the investment made. The spiral (another iterative) model permits this after each iteration some working software is delivered. This approach to software development is now widely used.Weaknesses:? It can have planning overhead.? Cost may increase as work done in one iteration may have to be undone later.? System architecture and structure may suffer as frequent changes are made.Types of project:? In a customized software development, where the client has to provide and approve the specific -ations, this process model is becoming extremely popular. SYSTEM ANALYSIS 3. SYSTEM ANALYSIS3.1 Fact finding techniques:Interview and Questionnaire?The first step in developing a database system is to clearly define the mission statement. For the database project, which defines the major aims of the database system? Once the mission statement is defined, the next activity involves identifying the mission Objectives, which should identify the particular tasks that the database must support.We started the Interview with the manager of the organization Pratima Enterprises. Following is some part of important conversation between us:What is the purpose of your company?We offer a wide range of high quality products i.e Rubber Products to clients in India. Our ability to offer quality products, of course, depends upon the services we provide to our customers.Why do you feel that you need a database?With the increasing business the level and volume of data is also increasing. As a result it very difficult to handle this huge data in files. Hence we feel a need for a computer system that could handle our data.Moreover it is very hard and time consuming to retrieve data from files.What kinds of tasks does your company perform in a typical day?Our company is a manufacturer of Rubber Products. We get Orders from our customers which we then process and if requires, we create a purchase form for the supplier as soon as the supplier delivers the raw materials we send them for production or products which is then packed in our company and finally it then reaches our customer.What kinds of data do you work with?We mostly have to maintain the orders from the customer. Our main data involves the sales and the purchase which has to be maintained carefully as it is very important. Last we also have data about our employees, customer, suppliers and products.What types of reports do you use?Mainly, we generate Account Summary reports.? Is it a trust based institution? Yes ? Does any operator uses the system? Yes ? How many employees are there in the institution? Less than 50 ? At present how the work is maintained in the institution? FILES ? Does the institution give Salary through Cheque / DD also? No ? Do you want any software that maintains your daily work very easily and without any stress? Yes3.2 SCREEN LAYOUTS & REPORT LAYOUTS:Loading-Rubber Products Management System:Login-Rubber Products Management System:Rubber Products Management System (RPMS):BackUp Connection: Change User Id and Password:CustomerSupplierPlant Maintenance and Other Cost:RowMaterial:Product: Inventory: Order: Payment: Salary: Employee:Operator: Summary Account: Help: Notepad: Calculator: Calculator: Time: Table(in Plant Maintenance and Other Cost):3.3 Event Table:● It is implementing system (one or more) event in a tabular format.● Event table consists of following columns: - Event - Trigger - Source - Use Case - Response - Destination● Event: - It is action affecting the system. Or - It is one that causes the system to do some thing. - Events are external, temporal and state event. - For example : Customer now an item, Customer order an item, etc.● Trigger: - How the system know that the system occurs? - For example : Item enquiry, New order, etc.● Source: - How is initiating that event (always external)? - For example : Customer, Operator, Administrator, etc.● Use Case: - What does the system do that system occurs? - For example : Look up item availability, Place new order, etc.● Response: - It is availability output. - For example : Item details, Invoice, etc.● Destination: - Whom that going? - For example : Customer, Operator, Administrator, etc.Rubber Products Management System Event Table:Sr. No.EventsTriggerSourceUse CaseResponseDestination 1.Plant maintenance and other costInspection/InvestigationManagementPlace costdetailsCost detailsData BaseSystem 2.EmployeedetailsEmployeeManagementRequires employee detailsEmployee detailsManagementand Data Base System 3.ValuableproductProductdemandManagementPlace productdetailsProductdetailsData BaseSystem 4.Administration interactionSign InAdministratorCollects Process detailsDataData BaseSystem 5.OperatorinteractionSign InOperatorData ProcessItem detailsData Basesystem 6.Customer now an itemItem enquiryCustomerLook up item availabilityItem detailsCustomer 7.Customerorders an itemNew orderCustomerPlace new orderOrder detailsManagementand Data Basesystem 8.Check availa -ble (Produc- ts/Row -materials) stockStock statusOperatorCheck (Products/ Row -materials) stock statusStatus detailsManagement 9. Order row-materialsNew orderManagementCreate new orderOrder detailsData BaseSystem 10.Payment tosupplierPaymentManagementEnter paymentdetailsPaymentdetailsData BaseSystem 11.ProductproductionProductionEmployeePlace production detailsProductiondetailsData BaseSystem 12.Customergive paymentPaymentCustomerEnter paymentdetailsPayment detailsData BaseSystem 13.Customerorder status Order statusOperatorCheck orderstatusOrder statusCustomer 14.Managementorder status Order statusSupplierCheck orderstatusOrder statusManagement 15.Customercancels theorderCancel orderCustomerCancel orderCancel detailsData BaseSystemRubber Products Management System Event Table continue:Sr. No.EventsTriggerSourceUse CaseResponseDestination 16.Managementcancels theorderCancel orderManagementCancel orderCancel detailsData BaseSystem 17.Customer replaces orderReplaceorderCustomerModify orderdetailsNew detailsData BaseSystem 18.Managementreplace orderReplaceorderManagementModify orderdetailsNew detailsData BaseSystem 19.Managementwants accountdetailsAccountSystemCombine alldetailsAccountdetailsManagement 20.Generate Account ReportReportAdmin / OperatorGenerateAccountReportReportAdmin / Operator 21.Administratorsign out thesystemSign OutAdministratorClick buttonSign OutData BaseSystem 22.Operator sign out the systemSign OutOperatorClick buttonSign OutData BaseSystem3.4 USECASE DIAGRAM:? Use Case Diagrams model the functionality of system by using Actors and Use Cases: ? Actor is a user of the system. ? Use cases are services or functions provided by the system to its users. ? Actor: ? An Actor can be described as follows: ? Actor is any entity that is external to the system and directly interacts with the system, thus deriving some benefit from the interaction. ? Actor can be a human being, a machine, or a software. ? Actor is a role that a particular user plays while interacting with the system. ? Examples of Actors are End-user (roles), External systems, and External passive objects (entities).? Use Case: ? An Use Case can be defined as a set of activities performed within a system by a User. ? Each Use Case: ? describes one logical interaction between the Actor and the system. ? defines what has changed by the interaction.? A Use Case diagram has the following elements: ? Stick figure: representing an Actor ? Oval: representing a Use Case ? Association lines: representing communication between Actors and Use CasesTypes of relationships between Use Cases are: ? Include ? ExtendInclude relationship: ? ?include? stereotype indicates that one use case “includes” the contents of another use case. ? Include relationship enables factoring out frequent, common behaviour.? Extend relationship: ? ?extend? stereotype indicates that one Use Case is “extended” by another Use Case. ? Extend relationship enables factoring out infrequent behaviour or error conditions. ? Extend relationship represents optional behavior for a Use Case which will be required only under certain conditions.UseCase Diagram of Rubber Products Management System: Rubber Products Management System Rubber Products Management SystemUSE CASE DESCRIPTION:Use case nameGenerate Account Report.ScenarioAdministrator or Operator selects Account report to generate.Triggering eventSelect Account report.Brief DescriptionWhen the Administrator wants to generate report, a report is created as per the details.ActorsAdministratorRelated Use CaseNoneStack holderStudentPre-ConditionAt least enter data related to account calculationPost-ConditionThe account report is generated.Flow of ActivityActor 1. The Administrator wants to generate report.ExceptionNoneNetBeans IDE 7.0.123. NAME: LOAD:OUTPUT: RPMS(MAIN SYSTEM)Use case nameCollect Process DetailsScenarioAdministrator Collect Process DetailsTriggering eventCollect Process DetailsBrief DescriptionWhen the Administrator wants the details, it collects from database throughData sourceActorsAdministratorRelated Use CaseNoneStack holderStudentPre-ConditionAt least enter data related to data collectionPost-ConditionRequire data collectsFlow of ActivityActor 1. The Administrator wants to collect process detailsExceptionNoneUse case nameData Process ScenarioOperator processes dataTriggering eventData ProcessBrief DescriptionWhen the Operator wants the data process, it processes the data in softwareActorsOperatorRelated Use CaseNoneStack holderStudentPre-ConditionAt least data which is processingPost-ConditionData processFlow of ActivityActor The Operator wants to process dataExceptionNoneUse case nameCombine all detailsScenarioSystem combines all detailsTriggering eventCombine all detailsBrief DescriptionWhen the system wants, it combines all detailsActorsSystemRelated Use CaseNoneStack holderStudentPre-ConditionAt least data which is combinesPost-ConditionCombines all detailsFlow of ActivityActor System combines all dataExceptionNoneUse case namePlace Cost DetailsScenario Management Collect Cost DetailsTriggering eventCollect Cost DetailsBrief DescriptionWhen the Administrator wants to place the cost details, it will place the cost detailsActorsManagementRelated Use CaseNoneStack holderStudentPre-ConditionAt least cost detailsPost-ConditionPlace cost detailsFlow of ActivityActor 1. The Management wants to place cost detailsExceptionNoneUse case namePlace Production detailsScenarioEmployee place production detailsTriggering eventProduction detailsBrief DescriptionEmployee will place the production details to the databaseActorsEmployeeRelated Use CaseNoneStack holderStudentPre-ConditionAt least production detailPost-ConditionPlace production detailsFlow of ActivityActor 1. Employee will place production detailsExceptionNoneUse case nameCheck Stock StatusScenarioOperator check statusTriggering eventStock statusBrief DescriptionOperator will check the stock status for order processActorsOperatorRelated Use CaseNoneStack holderStudentPre-ConditionStock in companyPost-ConditionCheck stock statusFlow of ActivityActor1. Operator will check the stock statusExceptionNone3.5 ENTITY RELATIONSHIP (ER) DIAGRAM:An ER-Diagram (Entity Relationship Diagram) is a graphical model of the data needed by a system. This included the entities about which information is stored and the relationship among them. It is produced in structured analysis methods. An entity is a “thing” or “object” in the real world that is distinguishable from all set of objects. An entity set is a set of the same type that share same properties, or attributes.E-R diagram consists of the following major components: The traditional approach to system development places a great deal of emphasis on data storage requirements for the new system. Data storage requirements include the data entities, their attributes, and the relationships among the data entities. The model used to define the data storage requirements is called the Entity-Relationship Diagram.On the Entity-Relationship Diagram:Rectangles represent data entitiesLines connecting the rectangles show the relationships among data entities.Ellipse represents the attributes of the entity.The traditional approach to system development places a great deal of emphasis on data storage requirements for the new system. Data storage requirements include the data entities, their attributes, and the relationships among the data entities. The model used to define the data storage requirements is called the Entity-Relationship Diagram.E-R Diagram of Rubber Products Management System:3.6 ACTIVITY DIAGRAM ? An Activity Diagram has the following features: ? It resembles a flow chart. ? It illustrates the dynamic nature of a system by modeling the flow of control from activity to actiity. ? An activity can represent an operation on some class in the system that results in a change in the state of the system.? Activity Diagrams are used: ? to model business processes. ? to model internal operation of a Use Case / method. ? to model work flows and computations.? Notations for Activity Diagrams include: ? Activity (State) ? Name ? Sub-states ? State - Sub state relationship ? Actions ? Entry Action ? Exit Action ? Transition ? Start and End States ? Event and Guard Condition ? Internal activity ? In addition, there are notations for: ? Alternate Paths (Branching and Merging) ? Parallel Paths (Fork and Join) ? Swim lanes? Alternate Paths: ? Alternate Paths are shown with the following notations: ? Diamond representing a decision with alternate paths ? Guard conditions used to label the alternatesParallel Paths are:? Fork represents splitting of a single flow of control into two or more concurrent flows of control.? Join represents the synchronization of two or more flows of control into one sequential flow of control.? Swim lanes: ? Swim lanes are used for grouping the related activities into columns.? Each column or “Swim lane” denotes distribution of responsibilities to be handled by different actors / parts of system.Activity Diagram for Rubber Products Management System:3.7 CLASS DIAGRAM:? Class diagrams define the basic building blocks of a model, namely types, classes, and general material used to construct the full model.? Class diagrams have the following functions:? They describe the static structure of a system.? They show the existence of classes and their relationships.? Classes represent an abstraction of entities with common characteristics.? Relationships may be Generalization, Association, Aggregation, Composition, or Dependency.? Typical uses of Class diagrams are: ? To model vocabulary of the system, in terms of system’s abstractions ? To model collaborations between classes ? To model logical database schema (blueprint for conceptual design of database)Class diagram of Rubber Products Management System:3.8 Object Diagrams:? Object Diagrams describe the “static structure” of a system at a particular time.? Objects and Links are the constituents of Object Diagrams.? Object Diagrams are different from Class Diagrams? This is because many objects of same class may exist in the Object Diagram.? Object Diagrams can be used: ? to test Class Diagrams for accuracy ? to verify system performance at given instance ? to optimize performance (especially useful for server objects)Object Diagram of Rubber Products Management System:3.9 SEQUENCE DIAGRAM:? Sequence Diagram: ? A Sequence diagram describes interactions among classes in terms of an “exchange of messages over time”.? Some of the facts related to Sequence Diagrams are: ? Sequence Diagrams are used to depict the time sequence of messages exchanged between objects. ? Messages can correspond to operation on class or a event trigger.? Notations of a Sequence diagram include: ? LifeLine: It is a vertical dashed line that represents the “lifetime” of an object. ? Arrows: They indicate flow of messages between objects. ? Activation: It is a thin rectangle showing period of time, during which an object is performing an action.? Direction of arrows: ? Direction indicates which object’s method is being called by whom. ? A circulating arrow on the Object Lifeline is for a self method – called within the object by itself.? Branch Conditions: ? Branch Conditions are depicted as “Guard Conditions” within Square Brackets. ? Repetition or Looping depicted as a rectangle, with condition for exiting the loop placed at the bottom left corner.Sequence Diagram of Rubber Products Management System: 3.10 COLLABORATION DIAGRAM:? A Collaboration Diagram describes interactions among objects in terms of messages.? A Collaboration Diagram: ? Emphasizes on the organization of the objects that participate in the interaction. ? Is semantically similar to Sequence Diagram. ? While Sequence Diagrams show exchange of messages based on time, Collaboration Diagrams are spatial representations. ? Sequence Numbers can be used for numbering messages to indicate their time ordering.Collaboration Diagram of Rubber Products Management System:3.11 STATE CHART DIAGRAM:? A State Chart Diagram describes the dynamic behaviour of a system in response to external stimuli.? A State Chart Diagram helps: ? to model dynamic behaviour of objects based on states. ? to model reactive objects, whose states are triggered by specific events. ? to describe passive objects, which go through several distinct phases during their life time.? State Chart Diagrams describe how the objects work: ? Each object is in a given initial state when it is created ? Object may change states (transition) to other states based on some stimuli ? State is the condition of an object ? Transitions indicate relation between the conditions? Parts of a State are: ? Name: Unique name identifying the state ? Sub-states: Set of “disjoint sub-states” or “concurrent sub-states”. ? State – Sub-state relationship: Useful to understand the modelling of complex behaviours. ? Entry action: An action that happens as a result of transition into a state. ? Exit action: An action that has to happen immediately before a state change. ? Internal activity: Activities that occur within an object while it is in a particular state.? There are some pseudo-states that are used in a State Chart Diagram: ? Start State: ? It is the default start point for an object state. ? Each State Chart Diagram should have exactly one Start State. ? End State: ? It indicates Completion State. ? It may or may not exist for a State Chart Diagram. ? When an object is destroyed, the state is no longer considered. ? Transition includes: ? Event: The “trigger” ? Guard: A logical condition which returns true or false. It is evaluated at the time of event triggering. ? Action: Gets executed when transition is fired. Event [Guard]/ ActionState chart diagram of Rubber Products Management System:3.12 Data Flow Diagram:A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information system. A data flow diagram can also be used for the visualization of data processing (structured design). It is common practice for a designer to draw a context-level DFD first which shows the interaction between the system and outside entities. This context-level DFD is then "exploded" to show more detail of the system being modeled.Data flow diagrams (DFDs) are one of the three essential perspectives of SSADM. With a dataflow diagram, users are able to visualize how the system will operate, what the system will accomplish and how the system will be implemented. Old system dataflow diagrams can be drawn up and compared with the new systems dataflow diagrams to draw comparisons to implement a more efficient system. Dataflow diagrams can be used to provide the end user with a physical idea of where the data they input, ultimately has an effect upon the structure of the whole system from order to dispatch to restock how any system is developed can be determined through a dataflow diagram.There are several common modeling rules that I follow when creating DFDs:All processes must have at least one data flow in and one data flow out. All processes should modify the incoming data, producing new forms of outgoing data. Each data store must be involved with at least one data flow. Each external entity must be involved with at least one data flow. A data flow must be attached to at least one process Data flow diagram notation:External Entities/Terminators? are outside of the system being modeled. Terminators represent where information comes from and where it goes. Processes?modify the inputs in the process of generating the outputs Data Stores?represent a place in the process where data comes to rest. A DFD does not say anything about the relative timing of the processes, so a data store might be a place to accumulate data over a year for the annual accounting process. Data Flows?are how data moves between terminators, processes, and data stores (those that cross the system boundary are known as IO or Input Output Discretions). A data flow diagram (DFD) is a graphical system model that shows all of the main requirements for an information system in one diagram: inputs and outputs, processes, and data storage. Everyone working on a development project can see all aspects of the system working together at once with DFD. That is one reason for its popularity. The DFD is also easy to read because it is graphical model.End Users, management, and all information systems workers typically can read and interpret the DFD with minimal training. The four components of a data flow diagram (DFD) are1819275162560 Context DiagramA DFD (Data Flow Diagram) that summarizes all processing activity within the system in a single process symbol is called Context Diagram. A context Diagram is a DFD that describes the highest-level view of a system are shown in own diagram, with the whole system represented as one process.The context diagram provides a good overview of the scope of the system, showing the system in “context” but it does not show any detail about the processing that takes place inside the system. The context diagram for the security company management system is shown below. The inputs & outputs of the store are shown in the fig. The diagram shows the external entities of the system & how the data that flows through the system. This helps in determining the basic functionalities.A context diagram is a top level (also known as Level 0) data flow diagram. It only contains one process node (process 0) that generalizes the function of the entire system in relationship to external entities.Context Level Diagram of Rubber Products Management System:1st Level Data Flow Diagram for Rubber Products Management System:SYSTEMDESIGN 4. SYSTEM DESIGN4.1 CONVERTING ERD TO TABLES:? Customer:Customer_IdCustomer_NameAgeGenderMobileNoTelNoEmailOffice_AddPINOffice_AddOfficeTelNoParmanentAddPINParmanent_AddC101Ram35Male987654321002225786543ram@Mumbai40000702225342278Mumbai400008C102Suraj40Male876543219801125643789suraj@Delhi11111101126879800Delhi111118? Supplier:Supplier_IdSupplier_NameAgeGenderMobileNoTelNoEmailOffice_AddPINOffice_AddOfficeTelNoParmanentAddPINParmanent_AddS101Raj25Male980054321002225780043raj@Mumbai40001702225342998Mumbai400009S102Sunder41Male871143219801125648889sunder@Delhi11122101126879810Delhi111100? Employee:Employee_IdEmployee_NameDOBGenderMobileNoTelNoEmailJoinDateLocal_AddPINLocal_AddParmaNent_AddPINParmanent_AddE101Raja1988/07/07Male880054321002225780041raja@2010/04/23Mumbai400001Mumbai400001E102Rohit1989/05/04Male971143219802225648880rohit@2010/04/11Mumbai400000Mumbai400000SalaryEmployee_Position15000Admin10000OperatorCalendar:? Product:Product_IdNamePricePerPieceColorP101Jar pad0.80BlackP102Summit Ring5.0Red? PlantMaintenanceOtherCost:SerialNoDescriptionDateTimeCost101Electricity2010/05/03 12:12:125000102Transport2010/04/12 11:01:08500? RowMaterial:RowMaterial_IdSupplier_IdRowMaterial_NameQuantity(Kg.)ColorPriceRM1001S10100150Black1500RM1002S101Silicon Rubber80Orange3000? ProductionDetails:Productionl_IdProduct_IdRowMaterial_IdEmployee_IdDateTimeQuantityPN1001P101RM1001E1022010/04/23 20:09:091500PN1002P102RM1001E1022010/04/11 20:09:09300? SalaryDetails:Salary_IdDateTimeEmployee_IdTotalSalarySL1012010/05/10 12:02:02E1028000SL1022010/06/10 12:00:00E1028500? Operator:DateTimeEmployee_Id2010/06/22 10:08:40E1022010/06/22 11:45:40E102? Inventory_Product:Storage_IdProduct_IdQuantityDateTimeSP101P10120002010/05/10 11:02:02SP102P10210002010/06/10 13:00:00? Inventory_RowMaterial:Storage_IdRowMaterial_IdQuantity(Kg.)DateTimeSP101RM10012002010/05/10 11:22:02SP102RM10021002010/06/10 13:30:00? RecieveOrder:OrderIdCustomer_IdProduct_IdDataTimeQuantityOR101C101P1022010/05/10 11:22:022000OR102C102P1022010/05/10 11:23:041500? GiveOrder:OrderIdSupplier_IdRowMaterial_IdDataTimeQuantityOG101S101RM10012010/05/10 11:32:02200OG102S102RM10022010/05/10 11:33:04150? RecievePayment:Payment_IdOrder_IdCustomer_IdDataTimeRupeesPR101OR101C1012010/05/10 11:22:023000PR101OR102C1022010/05/10 11:23:042000? GivePayment:Payment_IdOrder_IdSupplier_IdDataTimeRupeesPG101OG101S1012010/05/10 11:22:023000PG101OG102S1022010/05/10 11:23:0420004.2 COMPONENT DIAGRAM:? Component Diagrams describe the organization of components, including source code, run-time (binary) code, and executables.? Component Diagrams: ? give the physical view of the system in terms of implementation aspect. ? This is important for reusability and performance purpose. ? constitute the Components, their interfaces and realizations, and dependencies between components.? Component Diagrams are used: ? to depict organizations and dependencies among Component type. ? to show allocation of “classes” and “objects” to Components (also referred to as modules) in the physical design of the system. ? to indicate the “physical layering” and “partitioning” of the system architecture (during development / implementation phases).? A “Component” is a physical, replaceable part of a system. ? A Component packages the implementation, and provides “realization” to a set of “interfaces”. ? Component operations can be used only through the Component interface. ? A Component typically encompasses ? structure and behavior of a “collaboration ? of classes” from the system design.? Interfaces: ? Interfaces describe a group of operations implemented by Components.? Realization: ? Realization is the relationship between an “interface” and the “class” that provides the interface’s ponent diagram of Rubber Products Management System:4.3 PACKAGE DIAGRAM:? A package diagram in the Unified Modeling Language depicts the dependencies between the pack- ages that make up a model.? In addition to the standard UML Dependency relationship, there are two special types of dependen- cies defined between packages: ? package import ? package merge? A package import is "a relationship between an importing namespace and a package, indicating that the importing namespace adds the names of the members of the package to its own namespace. By default, an unlabeled dependency between two packages is interpreted as a package import relation- ship. In this relationship elements within the target package will be imported in source package. A package merge is "a directed relationship between two packages, that indicates that the contents of the two packages are to be combined. It is very similar to Generalization in the sense that the source element conceptually adds the charac- terristics of the target element to its own characteristics resulting in an element that combines the cha- racteristics of both.? Packages containing use cases.? In this relationship if an element exists within source element's definition and target also then the source element's definition's will be expanded to include target element's definitions.? It's different from a class diagram.? Package: It is a general purpose mechanism for organizing model elements & diagrams into groups. It provides an encapsulated namespace within which all the names must be unique. It is used to group semantically related elements. It is a namespace as well as an element that can be contained in other package's namespaces.? Class: It is a representation of objects, that reflects their structure and behavior within the system. It is a template from which actually running instances are created. Classes usually describe logical structure of system.? Interface: It is a specification of behavior. Implementing classes of an interface class are required to support the behavior.? Object: It is an instance of class. It is often used in analysis to represent numerous artifacts and items that exist.? Table: It is a stereotyped class.? Package diagrams can use packages containing use cases to illustrate the functionality of a software system.? Package diagrams can use packages that represent the different layers of a software system to illu- strate the layered architecture of a software system. The dependencies between these packages can be adorned with labels / stereotypes to indicate the communication mechanism between the layers.Package diagram of Rubber Products Management System:4.4 DEPLOYMENT DIAGRAM:? Deployment Diagrams depict the physical resources in a system including nodes, components, and connections.? Deployment Diagrams help to: ? capture the hardware topology. ? model the distributed systems.? Node: ? A Node represents: ? a computational resource ? a physical resource that executes code components? A set of components are allocated to a Node.? Communication Path represents physical connections between nodes.Deployment Diagram of Rubber Products Management System: 4.5 SYSTEM FLOW CHART:? A flowchart is a type of diagram that represents an algorithm or process, showing the steps as boxes of various kinds, and their order by connecting these with arrows. ? This diagrammatic representation can give a step-by-step solution to a given problem. ? Process operations are represented in boxes, and arrows connecting them represent flow of control. ? Data flows are not typically represented in a flowchart, in contrast with data flow diagrams; rather, they are implied by the sequencing of operations. ? Flowcharts are used in analyzing, designing, documenting or managing a process or program in vari- ous fields.? Flowcharts are used in designing and documenting complex processes. ? Like other types of diagram, they help visualize what is going on and thereby help the viewer to understand a process, and perhaps also find flaws, bottlenecks, and other less-obvious features within it. ? There are many different types of flowcharts, and each type has its own repertoire of boxes and nota- tional conventions. ? The two most common types of boxes in a flowchart are: ? a processing step, usually called activity, and denoted as a rectangular box ? a decision, usually denoted as a diamond.? A flowchart is described as "cross-functional" when the page is divided into different swimlanes de- scribing the control of different organizational units. ? A symbol appearing in a particular "lane" is within the control of that organizational unit. This tech- nique allows the author to locate the responsibility for performing an action or making a decision correctly, showing the responsibility of each organizational unit for different parts of a single process.? Flowcharts depict certain aspects of processes and they are usually complemented by other types of diagram. For instance, Kaoru Ishikawa defined the flowchart as one of the seven basic tools of quality control, next to the histogram, Pareto chart, check sheet, control chart, cause-and-effect diagram, and the scatter diagram. Similarly, in UML, a standard concept-modeling notation used in software devel opment, the activity diagram, which is a type of flowchart, is just one of many different diagram types.? Nassi-Shneiderman diagrams are an alternative notation for process flow.? Common alternate names include: flowchart, process flow chart, functional flow chart, process map, process chart, functional process chart, business process model, process model, process flow diagram, work flow diagram, business flow diagram.System Flow Chart diagram for Rubber Products Management System:4.6 STRUCTURE CHART DIAGRAM:A Structure Chart (SC) in software engineering and organizational theory, is a chart which shows the breakdown of a system to its lowest manageable levels. They are used in structured programming to arrange program modules into a tree. Each module is represented by a box, which contains the module's name. The tree structure visualizes the relationships between modules.A structure chart is a top-down modular design tool, constructed of squares representing the different modules in the system, and lines that connect them. The lines represent the connection and or ownership between activities and subactivities as they are used in organization charts.In structured analysis structure charts, according to Wolber (2009), “are used to specify the high-level design, or architecture, of a computer program. As a design tool, they aid the programmer in dividing and conquering a large software problem, that is, recursively breaking a problem down into parts that are small enough to be understood by a human brain. The process is called top-down design, or functional decomposition. Programmers use a structure chart to build a program in a manner similar to how an architect uses a blueprint to build a house. In the design stage, the chart is drawn and used as a way for the client and the various software designers to communicate. During the actual building of the program (implementation), the chart is continually referred to as "the master-plan".A structure chart depicts the size and complexity of the system, and number of readily identifiable functions and modules within each function and whether each identifiable function is a manageable entity or should be broken down into smaller components.A structure chart is also used to diagram associated elements that comprise a run stream or thread.It is often developed as a hierarchical diagram, but other representations are allowable. The representation must describe the breakdown of the configuration system into subsystems and the lowest manageable level. An accurate and complete structure chart is the key to the determination of the configuration items, and a visual representation of the configuration system and the internal interfaces among its CIs(define CI clearly). During the configuration control process, the structure chart is used to identify CIs and their associated artifacts that a proposed change may impact.Structure Chart diagram for Rubber Products Management System:SYSTEMCODING 5. SYSTEM CODING5.1 MENU TREE:1: Menu Tree Main Module (RPMS) File Back to SingIn Exit Change SignIn Account Change SignIn Account Tools Backup Connection Employee Operator Supplier Customer PlantMaintenance/Other Cost RawMaterial Product Inventory Order Production Payment Employee Salary Account Summary Notepad Notepad Calculator Calculator Help Help AboutUs AboutUs2: Menu Tree Notepad (in RPMS) File New Open Save Exit Edit Cut Copy Paste5.2 List of Tables With Attributes & Constraints:TABLE NAME: AdministratorAccount COLUMN NAME DATA TYPE FIELD LENGTH CONSTRAINT Admin_Id varchar 25Primary Key and Not Null Admin_Password varchar 25 Not NullTABLE NAME: UserAccount COLUMN NAME DATA TYPE FIELD LENGTH CONSTRAINT User_Id varchar 25Primary Key and Not Null User_Password varchar 25 Not NullTABLE NAME: TotalInvestment COLUMN NAME DATA TYPE FIELD LENGTH CONSTRAINT Total_Inv bigint - -TABLE NAME: Customer COLUMN NAME DATA TYPE FIELD LENGTH CONSTRAINT Customer_Id varchar 10Primary Key and Not Null Customer_Name varchar 15 Not Null Age int - Not Null Gender varchar 6 Not Null MobileNo varchar 10 Not Null TelNo varchar 11 Not Null Email varchar 50 Not Null OfficeAddress varchar 30 Not Null PIN_OfficeAddress int - Not Null OfficeTelNo varchar 11 Not Null ParmanentAddress varchar 30 - PIN_ParmanentAddess int - - TABLE NAME: PlantMaintenance COLUMN NAME DATA TYPE FIELD LENGTH CONSTRAINT SerialNo int -Primary Key and Not Null Description varchar 50 Not Null DateTime DateTime - Not Null Cost bigint - Not NullTABLE NAME: EmployeeDetails COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT Employee_Id varchar 15Primary Key and Not Null Employee_Name varchar 15 Not Null DOB varchar 14 Not Null Gender varchar 6 Not Null MobileNo varchar 10 Not Null TelNo varchar 11 Not Null Email varchar 50 Not Null JoinDate varchar 14 Not Null Address varchar 30 Not Null PINLocal_Add int - Not Null Parmanent_Add varchar 30 Not Null PINParmanent_Add int - Not Null Salary varchar 10 Not Null Employee_Position varchar 25 Not NullTABLE NAME: Operator COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINTDateTime - -Primary Key and Not NullEmployee_Id varchar 15Foreign Key and Not NullTABLE NAME: Supplier COLUMN NAME DATA TYPE FIELD LENGTH CONSTRAINT Supplier_Id varchar 10Primary Key and Not Null Supplier_Name varchar 15 Not Null Age int - Not Null Gender varchar 6 Not Null MobileNo varchar 10 Not Null TelNo varchar 11 - Email varchar 50 - OfficeAddress varchar 30 Not Null PIN_OfficeAddress int - Not Null OfficeTelNo varchar 11 Not Null ParmanentAddress varchar 30 - PIN_ParmanentAddess int - - TABLE NAME: Product COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT Product_Id varchar 15Primary Key and Not Null Name varchar 25 Not Null PricePerPiece float - Not Null Color varchar 25 Not NullTABLE NAME: RowMaterial COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT RowMaterial_Id varchar 10Primary Key and Not Null Supplier_Id varchar 10 Foreign Key and Not Null RowMaterial_Name varchar 15 Not Null Quantity bigint - Not Null Color varchar 15 Not Null Price varchar 7 Not NullTABLE NAME: SalaryDetails COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT Salary_Id varchar 15Primary Key and Not Null DateTime DateTime - Not Null PricePerPiece varchar 15 Foreign Key and Not Null TotalSalary bigint - Not NullTABLE NAME: GiveOrder COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT OrderId varchar 100Primary Key and Not Null Supplier_Id varchar 10 Foreign Key and Not Null RowMaterial_Id varchar 10 Foreign Key and Not Null Quantity bigint - Not Null DateTime DateTime - Not NullTABLE NAME: RecieveOrder COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT OrderId varchar 100Primary Key and Not Null Customer_Id varchar 10 Foreign Key and Not Null Product_Id varchar 15 Foreign Key and Not Null Quantity bigint - Not Null DateTime DateTime - Not NullTABLE NAME: ProductionDetails COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINTProduction_Id varchar 15Primary Key and Not NullProduct_Id varchar 15 Foreign Key and Not NullRowMaterial_Id varchar 10Foreign Key and Not NullEmployee_Id varchar 15Foreign Key and Not NullDateTime DateTime - Not NullQuantity bigint - Not NullTABLE NAME: Inventory_Product COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT Storage_Id varchar 15Primary Key and Not Null Product_Id varchar 15Foreign Key and Not Null Quantity bigint - Not Null DateTime DateTime - Not NullTABLE NAME: Inventory_RowMaterial COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT Storage_Id varchar 15Primary Key and Not Null RowMaterial_Id varchar 10Foreign Key and Not Null Quantity bigint - Not Null DateTime DateTime - Not NullTABLE NAME: GivePayment COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT Payment_Id varchar 100Primary Key and Not Null OrderId varchar 100 Foreign Key and Not Null Supplier_Id varchar 10 Foreign Key and Not Null DateTime DateTime - Not Null Rupees bigint - Not NullTABLE NAME: RecievePayment COLUMN NAME DATA TYPEFIELD LENGTH CONSTRAINT Payment_Id varchar 100Primary Key and Not Null OrderId varchar 100 Foreign Key and Not Null Customer_Id varchar 10 Foreign Key and Not Null DateTime DateTime - Not Null Rupees bigint - Not Null5.3 PROGRAM DESCRIPTION: NAME: CREATE USER ACCOUNT INPUT: USERNAME AND PASSWORD OUPUT: ERROR MESSAGE OR USER ID AND PASSWORD IF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELD ELSEIF USERNAME AND PASSWORD DOESNOT EXIT THEN CREATE USE ID AND PASSWORD ELSE GIVE ERROR MESSAGE ENDIFNAME: SYSTEM LOGIN INPUT: USERNAME AND PASSWORD OUPUT: ERROR MESSAGE OR NEXT PAGE IF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELD ELSEIF USERNAME AND PASSWORD DOESNOT MATCH THEN GIVE ERROR MESSAGE OF INCORRECT USERNAME AND PASSWORD ELSEIF USERNAME AND PASSWORD MATCHES THEN GIVE ACCESS TO NEXT PAGE ENDIFNAME: CHANGE USER ID AND PASSWORD INPUT: CURRENT_USER ID AND PASSWORD, NEW USER ID AND PASSWORD, CONFIRM USER ID AND PASSWORD OUTPUT: ERROR MESSAGE OR USER ID AND PASSWORD CHANGE. IF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELD ELSEIF CURRENT_PASSWORD DOESNOT MATCH THEN GIVE ERROR MESSAGE OF CURRENT_PASWORD ELSEIF NEW_PASSWORD IS NOT CONFIRMED AGAIN THEN GIVE ERROR MESSAGE OF NEW_PASSWORD MISMATCH ELSE ALL FIELDS ARE PROPERLY FILLED AND MATCHED THEN CHANGE USER ID AND PASSWORD ENDIFNAME: CUSTOMER:INPUT: CUSTOMER ID, NAME, AGE, GENDER, MOBILE NO, TEL NO, EMAIL, OFFICE ADDRESS, PIN OFFICE ADDRESS, OFFICE TEL, PARMANENT ADDRESS, PIN PARMANENT ADDRESS OUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE CUSTOMER DETAILS ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: SUPPLIER:INPUT: SUPPLIER ID, NAME, AGE, GENDER, MOBILE NO, TEL NO, EMAIL, OFFICE ADDRESS, PIN OFFICE ADDRESS, OFFICE TEL, PARMANENT ADDRESS, PIN PARMANENT ADDRESS OUPUT: ADD, REMOVE, MODIFY, SHOW,SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE SUPPLIER DETAILS ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: EMPLOYEE:INPUT: EMPLOYEE ID, NAME, DOB, GENDER, MOBILE NO, TEL NO, EMAIL, JOIN DATE, LOCAL ADDRESS, PIN LOCAL ADDRESS, PARMANENT ADDRESS, PIN PARMANENT ADDRESS, BASIC SALARY, POSITION OUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE EMPLOYEE DETAILS ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: PRODUCT:INPUT: PRODUCT ID, NAME, PRICE PER PIECE, COLOROUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE PRODUCT DETAILS ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: PLANT MAINTENANCE OTHER COST:INPUT: SERIAL NO, DESCRIPTION, DATETIMEOUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF DATETIME FORMATE INCORECT THEN GIVE ERROR MESSAGE OF INCORECT DATETIMEELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE PLANT MAINTENANCE OTHER COST DETAILS ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: SALARY:INPUT: SALARY ID, DATETIME, EMPLOYEE ID,TOTAL SALARYOUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF DATETIME FORMATE INCORECT THEN GIVE ERROR MESSAGE OF INCORECT DATETIMEELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE PRODUCT DETAILS ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: PRODUCTION:INPUT: PRODUCTION ID, PRODUCT ID,ROW MATERIAL ID, EMPLOYEE ID, DATETIME, QUANTITYOUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE PRODUCT ION DETAILS ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: ROW MATERIAL:INPUT: ROW MATERIAL ID, SUPPLIER ID, ROW MATERIAL NAME, QUANTITY, COLOR, PRICEOUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE ROW MATERIAL ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: OPERATOR:INPUT: DATETIME, EMPLOYEE IDOUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF DATETIME FORMATE INCORECT THEN GIVE ERROR MESSAGE OF INCORECT DATETIMEELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE OPERATOR DETAILS ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LAST, AVILABLE TOOLSENDIFNAME:INVENTORY:INPUT: STORAGE ID, PRODUCT ID, QUANTITY, DATETIMEOUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF DATETIME FORMATE INCORECT THEN GIVE ERROR MESSAGE OF INCORECT DATETIMEELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE INVENTORY ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME:ORDER:INPUT: ORDER ID, CUSTOMER ID / SUPPLIER ID, PRODUCT ID / ROW MATERIAL ID, DATETIME, QUANTITYOUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT THEN GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF DATETIME FORMATE INCORECT THEN GIVE ERROR MESSAGE OF INCORECT DATETIMEELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE ORDER ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME:PAYMENT:INPUT: PAYMENT ID, ORDER ID, CUSTOMER ID / SUPPLIER ID DATETIME, RUPEESOUPUT: ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTIF TEXTFIELDS ARE BLANK THEN GIVE ERROR MESSAGE OF BLANK FIELDELSEIF ENTER DUPLICATES PRIMARY CONSTAINT GIVE ERROR MESSAGE OF DUPLICATE CONSTRAINTELSEIF DATETIME FORMATE INCORECT THEN GIVE ERROR MESSAGE OF INCORECT DATETIMEELSEIF CONNECTION FAIL GIVE CONNECTION ERRORELSE PAYMENT ADD, REMOVE, MODIFY, SHOW, SEARCH, FIRST, NEXT, PREVIOUS, LASTENDIFNAME: ACCOUNT:INPUT: PLANT MAINTENENCE AND OTHER COST, EMPLOYEE SALARY, PAYMENTOUPUT: SHOW SUMMARY ACCOUNTIF CONNECTION FAIL GIVE CONNECTION ERRORENDIFNAME: HELP:INPUT: HELP COMMANDOUPUT: SHOW HELPNAME: RPMS:INPUT: TOOLOUPUT: SHOW RELATED WINDOWNAME: CALCULATOR:INPUT: OPERAND, OPERATOROUPUT: SHOW RESULTNAME: CALENDAR:INPUT: DAY, MONTH, YEAROUPUT: SHOW CALENDARNAME: TIME:INPUT: HOURS, MINUTE, SECONDOUPUT: SHOW TIMENAME: REPORT:INPUT: REPORT ATTRIBUTESOUPUT: SHOW REPORT SYSTEM TESTING 6. SYSTEM TESTINGTesting plays a critical role in quality assurance for software. Due to the limitations of the verification methods for the previous phases, design and requirements faults also appear in the code. Testing is used to detect these errors, in addition to the errors introduced during the coding phase.Testing is a dynamic method for verification and validation, where the system to be tested is executed and the behavior of the system is observed. Due to This, testing observes the failure of the system, from which the presence of faults can be deduced. However, separate activities have to be performed to identify the faults.Approaches:Black-Box Testing In the black-box testing, the internal logic of the system under testing is not considered and the test cases are decided from the specification or the requirements. It is often called functional testing. Equivalence class partitioning, boundary value analysis, and cause effecting graphing are examples of methods for selecting test cases for black-box testing. State–based testing is another approach in which the system is modeled as a state machine and then this model is used to select test cases using some transition or path based coverage criteria. State–based testing can also be viewed as grey-box testing in that it often requires more information than just the requirements.White-Box Testing In white-box testing, the test cases are decided entirely on the internal logic of the program or module being tested. The external specifications are not considered. Often a criterion is specified, but the procedure for selecting test case is left to the tester. The most common control flow-based criteria are statement coverage and branch coverage, and the common data flow-based criteria are All- doffs and all-uses. Mutation testing is another approach for the white-box testing that creates mutants of the original program by changing the original program. The testing criterion is to kill all the mutants by having the mutant generate a different output from the original program.Validation Testing Checking to verify that appropriate values have been entered for a text box is called Validation. In this test, if user is trying to enter the invalid data in any field than it will prompt an Message Box showing the “ERROR”There are following types of error :-java.sql.SQlException:[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified,Please, enter create User Id and Password,Please, enter all fields, etc.Authentication TestingIt is use to test that a login user is authorized or not. If a user is not authorizes than it throw an error i.e.” Invalid User”. If user is authorized then system is allow that user to access the system.Integrated TestingIn integrated testing each form is connected to respective program, then each program is connected to its respective menu and the entire system is tested form the top level.6.1 Test Cases: Test Cases Expected Results Field emptyError message shown excludes Backup Connection“Please, enter all fields”OrError message display For Backup Connection“Sorry Connection Failed”OrAppropriate error message shown(if search text empty) Duplicate Primary Key field detail enter Error message shown (Conflict error will shown) User type is not selected Error message shown “Select User type”Backup (Database) Connection is not established and related Button Click??Error message shown “java.sql.SQlException:[Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified”Created User Id and Password is not entered?Error message shown “Please, enter create User Id and Password” Date Format wrongError message shown“java.sql.SQLException:[Microsoft][SQL Natinve Client][SQL Server]Conversion failed when converting datetime from character string”? Enter field length is less than minimum or greater than maximumError message shown(related length information shown) Not enter integer value in text FieldError message shown?“java.sql.SQLException;[Microsoft][SQL Native Client][SQL Server]Conversion failed when converting the varchar value xxx to data type int” Save detailsAlert message shown?“java.sql.SQLException: No ResultSet was produced”?6.2 Validations:1. Create Account Error: 2. Connection Error:3. Login Error:4. Conversion Error (from varchar value to data type integer):5. Data Source Error:6. Conversion Error (from character string to datetime):7. Data Field Length Error: 8. Duplicate Key Error:9. Empty Field Error:10. Password Confirm Error:11. Empty Field for search Error:CROSS-PLATFORM JAVA EXECUTABLE WRAPPER 7. Cross-platform Java executable wrapper Launch 4j:Launch4j is a cross-platform tool for wrapping Java applications distributed as jars in lightweight Windows native executables. The executable can be configured to search for a certain JRE version or use a bundled one, and it's possible to set runtime options, like the initial/max heap size. The wrapper also provides better user experience through an application icon, a native pre-JRE splash screen, a custom process name, and a Java download page in case the appropriate JRE cannot be found.FeaturesLaunch4j wraps jars in Windows native executables and allows to run them like a regular Windows program. It's possible to wrap applications on Windows, Linux, Mac OS X and Solaris!Also creates?launchers?for jars and class files without wrapping.Supports executable jars and?dynamic classpath?resolution using environment variables and wildcards.Doesn't extract the jar?from the executable.Custom application icon with multiple resolutions and color depths.Native pre-JRE splash screen?in BMP format shown until the Java application starts.Process name?as the executable filename to easily identify your application, initial?priority and?single application instance?features.Works with a bundled JRE or searches for newest Sun or IBM JRE / JDK in given version range.Opens?Java download page?if an appropriate Java version cannot be found or a?support website?in case of an error.Supports?GUI and console apps.Supports?Vista manifests?and?XP visual style manifests.Passes command line arguments, also supports constant arguments.Allows to set the initial/max heap size also?dynamically?in percent of free memory.JVM options: set system properties, tweak the garbage collection...Runtime JVM options from an .l4j.ini file.Runtime command line switches to change the compiled options.Access to environment variables, the?registry?and executable file path through system properties.Set environment variables.Option to change current directory to the executable location.The JRE's bin directory is appended to the Path environment variable.Custom?version information?shown by Windows Explorer.GUI?and command line interface.Build integration through an?Ant task?and a?Maven Plugin.Lightweight: 26 KB!It's free?and may be used for commercial purposes.Includes a sample application and?Ant script?that automates the build process from Java sources to native executable.The wrapped program works on all Windows platforms (98/Me/NT/2K/XP/Vista), Launch4j works on NT/2K/XP/Vista, Linux, Mac OS X (build on 10.4) and Sparc Solaris 8-10.LicenseThis program is free software licensed under the?BSD license, the?head?subproject (the code which is attached to the wrapped jars) is licensed under the?MIT license. Launch4j may be used for wrapping closed source, commercial applications. 8. FUTURE ENHANCEMENTSThere is a huge scope of enhancement in the project by adding functionalities to the system. The project can be enhanced in the near future by adding more modules and can be implemented for more better use. History of all can be maintained and can be retrieved whenever requires. Progress report can be generated. This all can be modified and can be implemented in the near future. 9. CONCLUSIONWhile developing the system a conscious effort has been made to create and develop a software package, making use of available tools, techniques and resources – that would generate a proper Technical Institute Support System. While making the system, an eye has been kept on making it as user-friendly, as cost-effective and as flexible as possible. As such one may hope that the system will be acceptable to any user and will adequately meet his/her needs.As in case of any system development process where there are a number of shortcomings, there has been some shortcomings in the development of this system also. These have been mentioned in details under the topic Limitations and Future Scope of the System 10. REFERENCES AND BIBLOGRAPHYSr. No. Book Author Publication1.An Integrated Approach toSoftware EngineeringPankaj JaloteNarosa Publishing House2.Java 2: The Complete Reference(J2SE)Herbert SchildtTata McGraw-Hill Publishing Company Limited3.Advanced Java(B.Sc. (IT))Rupal M. ShahVipul Prakashan4.The Complete Reference SQLJames R. Groff and Paul N. Weinberg TMGTata McGraw-Hill Publishing Company LimitedAlso: ? ? ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- the first electronic game to employ a cathode ray tube was
- rubber products management system weebly
- linux lehman college
- atv documentation edu
- master test plan template va
- your first web server application lab
- high performance computing cookbook for msis data science
- homegenie club
- from sequence to treesaap csl
- introduction michigan state university
Related searches
- customer relationship management system for small business
- treasury management system providers
- treasury management system reviews
- customer relationship management system ppt
- customer relationship management system example
- customer relationship management system examples
- customer relationship management system pdf
- customer management system project
- customer management system software
- document management system small bus
- inventory management system small busi
- inventory management system small business