CSC340S ASSIGNMENT 3 Information Systems Analysis and Design Names Lie A Cheong Ching Ching Lorna 990054203 Kenneth Ho Kin Leung 980968140 Ching Wah Janice Lo 990432858 TA Attila Barta Prof John Mylopoulos Date Apr 12th 2002 Table of Contents Feasibility Study Introduction P 3 Company Development History P 3 Brief introduction to production process P 3 The current information system P 3 5 Problem Solution P 6 7 Recommendation P 7 Global Architecture P 8 15 Program Design P 15 21 DataBase Diagrams P 21 32 User Interface Design P 32 36 Appendices Appendix A Comparison Chart P 37 39 Appendix B Class Diagram P 40 Appendix C Sequence Diagram P 41 46 Appendix D State Diagram P 47 55 Appendix E State Dialogue P 56 59 Appendix F Mockups windows P 59 64 Appendix G Web design P 65 68 Appendix H Data Dictionary P 69 79 Appendix I Details of Group meeting P79 80 Appendix J Interview P 80 Appendix K ER Diagram P 81 Appendix L Class diagram after restructure P 82 Appendix M Team Report Form P 83 Introduction Bestley Enterprises Co Ltd Bestley in short is a company producing plastic bags which located in Scarborough Bestley mainly centralized in producing and printing logo on finished plastic bag The goal of this design report is to decide upon the proper hardware software database and interface design required to implement a new information system for Bestley Decisions made in this report is based on the previously study of the functional and non functional requirements of the company Company Development History Bestley founded in 1993 by Mr Allen L H Tang currently CEO The company was first a family owned plastic bag company which had only two employees Mr and Mrs Tang At first the company only responsible for production of more popular type of plastic bag and act as a middleman between clients and printing company In 1995 the company expanded as a result of market pressure The expansion included employed more workers and bought more up to date machinery Mr Tang hopes to capture more of market share in the near future Therefore computerization is a must in the current business environment The implementation of information system is essential in order to increase efficiency of data transfer and overall performance of company The current information system To determine problems with the current system of Bestley understanding the business routine of the company is important The daily routine The customer representative meets the customer to figure out their requirement Customer s contact information is recorded into the Customers Contact Ledger The owner designs a few patterns according to the customer s requirement He then provides samples and materials for the customer to choose The design and ideas are kept in the Ideas Design Ledger The customer makes a final decision of the outlook of their products and sign up an order invoice The invoice is then kept in the Customers Invoice Ledger The secretary orders raw materials from the supplier and records this transaction in the Raw Material Order Ledger Once the materials arrive production process can be started Workers put a proper amount of raw materials into the extruder machine and generate the plastic rolls The amount of raw material used is recorded into the Raw Material Order Ledger Based on the description in the Ideas Design Ledger workers start to print the specified pattern on the plastic rolls The plastic rolls are then cut into pieces of plastic bags and packed into boxes Driver delivers the finished products to customer The accountant collects the account receivable from customers and makes a stamp on the customers invoice to indicate the transaction have been completed and paid The monthly routine The accountant prepares the balance sheet trial balance and income statement These data are stored into the Accounting Ledger The secretary organizes the data in the GST Record Ledger and prepares monthly sales report chart for the owner to determine future business plans Summary of the current information system From the description above it is known that the 6 Ledgers play a very important role throughout the entire business operation These 6 Ledgers are the fundamental information system for Bestley Each ledger records different type of information and data 4 of them record the information for all customers and suppliers 2 of them are used for internal accounting purpose Detail descriptions for each of them are list below Ledger for Customers and Suppliers 1 Customers Contact Ledger It contains records of all customers contact information such as company address telephone number email etc Each customer record consists of a list of invoice numbers which represent all the previous invoices made by this customer 2 Ideas Design Ledger It contains records of all plastic bag pattern design as well as customers special requirements on their products The designs are produced using CorelDraw 9 Often one hard copy is kept inside the ledger and one soft copy is kept on computer Each record has a number which is used in the invoice to identify the design of product 3 Customers Invoice Ledger It contains records of all transaction with customers It keeps information such as the amount of customer s order i e number of plastic bags the date for shipment and the price for each transaction Each transaction has a unique invoice number 4 Raw Materials Order Ledger It contains records of all transaction made with the suppliers It also keeps track of the quantity of raw materials in inventory and the quantity used in production Ledger for internal accounting purpose 5 Accounting Ledger This ledger information is prepared monthly At the end of each month the accountant will gather all invoices from Customers Invoice Ledger and Raw Materials Order Ledger and then prepares monthly balance sheet income statement and trial balance for the company 6 GST Ledger This ledger contains all monthly income statements They are used to calculate the GST of the company in order to report to the government every 3 months Many operations of Bestley depend highly on the flow of the information within these 6 ledgers Failure in retrieving or transforming these data will result to inefficient inconsistency and inaccuracy production processes It could possibly provide misleading information for future forecast The Proposed Solutions Among all the alternatives this is the best alternative to correct problems in the current information system Proposed Alternative E Commerce
View Full Document
Unlocking...