DUET ONLINE CONSIGNMENT STORE
Contents
1. EE com 3p Net Economic Benefit 0 12 750 00 12 750 00 12 750 00 12 750 00 Discount Rate 6 596 1 00000 0 93897 0 88166 0 82785 0 77732 PV of Benefits 0 00 11 971 83 11 241 16 10 555 08 9 910 87 NPV of All BENEFITS 0 00 11 971 83 23 212 99 33 768 06 43 678 93 43 678 93 One Time COSTS 8 075 0 0 Recurring costs 0 7 500 00 7 500 00 7 500 00 7 500 00 Discount Rate 6 5 1 00000 0 93897 0 88166 0 82785 0 77732 PV of Recurring Costs 0 00 7 042 25 6 612 44 6 208 87 5 829 92 NPV of All COSTS 8 075 15 117 21 730 27 939 33 768 33 768 Overall NPV 9 910 44 Overall ROI Overall NPV NPV of all 0 29 COSTS Break Even Analysis Yearly NPV Cash Flow 8 075 4 930 4 629 4 346 4 081 Overall NPV Cash Flow 8 075 3 145 1 483 5 829 9 910 Project break even occurs between years 2 and 3 Use first year of positive cash flow to calculate break even fraction 4629 1483 4629 6796 Actual break even occurred at around 1 6796 years Note All Dollar values have been rounded to the nearest dollar Page 14 of 95 GROUP 9 Duet Online Consignment Store One Time Cost 8 075 00 Recurring Cost X 7 500 00 Discount Rate 6 5 PV X 1 1 6 5 NPV Sum of all PV s NPV Benefits NPV Cost One Time Cost Total Profit 43 678 93 33 768 00 8 075 1835 93 Net Pr2. Page 94 of 95 GROUP 9 Duet Online Consignment Store 11 REFERENCES e Garlan David An Introduction to Software Architecture Advances in Software Engineering and Knowledge Engineering World Scientific 1993 e Leinecker Richard Special Edition Using ASP NET Que Corporation 2002 e Balena Francesco Programming Visual Basic NET Microsoft Press April 2002 e Forgey Bill Gosnell Denise and Reynolds Matthew Beginning Visual Basic NET Databases Wrox Press 2001 e Blair Richard et al Beginning VB NET 2 ed Wrox Press 2002 e Blair Richard et al Professional VB NET 2 ed Wrox Press 2002 e Sceppa David Microsoft Ado Net Microsoft Press 2002 e Oberg Robert Thorsteinson Peter and Wyatt Dana Application Development Using Visual Basic and NET Pearson Education 2002 Page 95 of 95
3. 3 4 Use Case Scenario Diagram 3 9 Requirements Definition 3 5 1 Functional Reguirements 3 5 2 Non functional requirements 3 6 Requirements SpecificatiONS 3 7 Data Flow Diagrams DPD sara tO Ka 3 7 1Grammatical analysis wns 3 7 2 Context Diagram EE 3 L3 General DED E 3 7 4 Decompositions EE Ga E Di OU R NETTO 13 16 16 17 jnak 22 25 25 27 29 30 32 M 32 PORZE 33 CRT 34 35 35 e 36 ee 37 41 T 42 KAA 42 43 S ebe 44 adai 46 obie 46 ia 48 49 50 Page 2 of 95 GROUP 9 Duet Online Consignment Store 4 PROCESS SPECIFICATIONS LIA Boa SI 4 2 Decision ER II i a d erT EaR EER EARE 52 4 Decision KE 53 5 DATA TIONG lee 54 6 SYSTEM DESIGN NH eM UE VI m 58 2 Abstract MICHIE EE GRE 59 6 3 SERENE CIA ur oo MT 60 6 4 Client Server Architecture 61 7 ERM MUBEL cla 62 8 STRUCTURE CHART 5 0 ANT RR RA 62 8 1 1 Manage Consignor ADNE EO EG OE A eo wia 63 8 2 1 Manage MYERS aio 64 IN Re 65 ZIA MR 66 9 USER INTERFACE DESIGN SUMMER LEN Aio oo P 68 10 STATIC OBJECT MODEL DIAGRAM 94 11
4. _ lx 4 piecze Sia Flomter Tie bebe ora Pasi Gaty liliss Detail So EET Find First Tire ea bate ate zotz Hama wania Brian mew eee 12 a Eig tii zip 5 T H5 Tam di Hun incre pin n pe rat rica Tonal bg Page 77 of 95 GROUP 9 Duet Online Consignment Store Invoicing continued Duet Consignment Store How Terry tre Dee Page 78 of 95 GROUP 9 Duet Online Consignment Store Inventory Search By Range of Prices Inventory Item List Item Sold List Ou Monday Novemb e Page 79 of 95 GROUP 9 Duet Online Consignment Store View a Consignor Consignor The LEE First Mama erinin widdla Initial Last Hama renea Address Details Address Ling i Beasewelt Drive iliac Raisi e Home Phone ozea Addrass Line z E gt el Phere 87 5 21 4475 City joli State pu Zipcode 7222 Work Phone 073 222 1475 Email Addrass illo atm itadu Statt Ela all Prica ConsignorI ID By re Fd Carai Consignor LE UZE First Hama Wisen Middle Initial Last Kame inem Address Details Aare Cire 501 Poosevalt Drive Cantat Detalki Fame Priore 01 25 7412 colo ji 5 Cell Phone 973 221 4475 City Kodwali Stara pu Zidi DES Wark P hana 073 222 147B Email Addrani vittis tadu Je els Page 80 of 95 GROUP 9 Duet Online Consignment Store Main Screen to Duet Consignment
5. a Di tau New 10 112 How 17 De Wie 24 02 Dec 1 YA D TaskMeme Duraion Stat Arsh uHfrfw z r s s u r w y F sS s m r w r F 5s Mm a n r F s s M Tw 43 System Development Wide Tue HS Wed 12702 T SS 4 System Prolotype Design Bes Tue ine Fins 45 Find System Design Bars MTAA Wed 1270 48 System Testing dds MedTLETAI Men 12202 Ore Fri hile Bes Testing Idy Wed 10290 Fiese 100 48 Hack Box Testing Ids P12 ion E E 48 Project Release and Presentati is Tue OI Tue 10 10 Page 24 of 95 GROUP 9 Duet Online Consignment Store 2 3 COCOMO II 2 3 1 Function Point Analysis and KSLOC Estimation All group members have had previous experience with similar projects We qualified our project as a medium complexity project with two team members to perform prototyping and one working on the database design Total unadjusted functional points were calculated as follows Function Point Count Page 25 of 95 GROUP 9 Duet Online Consignment Store Value Adjustment Factor eeereeeeeneeee ee RA e Leti e ee o e e e e e cio elio oo olo e oo o e e e 1 e e 02 0 0 e LI e e Le e se LL es e e e Di E Tala Deane Censi renani Shea Pre pge he Tea Flarsagaeski De gori prian Fun pign Palm amp ashsis ged KSLOC Kila Gowns Lives Of Cade Egtimaiine Lagech Fuackoa Polar TEM Value amp djustimen Fach IE x Kij Function Point VE Largmagri Visual Basic jos 25 BLOG S
6. Account Info Inventory Login Logout Logout Data Data Data Item To From Inventory Updated Info Consignor Info Updated Inventory N Reports ew Accoun Updated t Account Payout History Check to Consignor Consignor amp Item Info Payrol Info Paycheck Consignor Inventory Item and Employee Info Reports Page 49 of 95 GROUP 9 Duet Online Consignment Store 3 7 4 DECOMPOSITIONS Consignor History Consignor Info Modify Info Updated Info Item To From Update to i Inventory Inventory Re aa D Consignor Info Total Amount i ka i Hed e Update Total Hours Paycheck Payroll Info Employee Info Worked Amount Paycheck Page 50 of 95 GROUP 9 Duet Online Consignment Store 4 0 Process Specifications 4 1 Structured English For all Access attempts by the Store Manager 1 2 5 Access Login Page and Enter Account Name and Password Read instructions on Online System Navigation Access Store Manager Home Page If the Store Manager wants to Generate Reports 4 1 Enter Generate Reports Page 4 1 1 Ifthe Store Manager wants to Generate a Daily Report 4 1 1 1 Select Daily Report 4 1 1 2 Else select another option 4 1 2 If the Store Manager wants to Generate a Weekly Report 4 1 2 1 Then select Weekly Report 4 1 2 2 Else select anot
7. CONSIGNOR PAYOUT STORE OWNER pa Reports E Updated Inventory Report w All Info Wid Check to Consignor 1 Employee Info Paycheck 32 MANAGE PAYROLL Page 63 of 95 Sh GROUP 9 Duet Online Consignment Store 8 1 MANAGE CONSIGNOR ACCOUNT 1 1 MANAGE CONSIGNOR ACCOUNT Updated Consignor Info Consignor Info 4 Modified pm Account Kiel EE 1 1 3 ADD MODIFY DELETE VIEW CONSIGNOR HISTORY CHECK PERSONAL INVENTORY CONSIGNOR ACCOUNT Page 64 of 95 8 2 MANAGE INVENTORY Page 65 of 83 GROUP 9 Duet Online Consignment Store 8 3 CONSIGNOR PAYOUT 3 1 CONSIGNOR PAYOUT Consignor Check to and Item Info Consignor J UPDATE PAYOUT PRINT AND SEND CHECK HISTORY Page 66 of 95 GROUP 9 Duet Online Consignment Store 8 4 MANAGE PAYROLL 32 MANAGE PAYROLL Employee Paycheck Infomation 321 3 24 ADD MODIFY DELETE Modified EMPLOYEE Employee Information SEND PAYCHECK Paycheck Amount 523 CALCULATE TOTAL CALCULATE PAYCHECK HOURS WORKED AMOUNT Page 67 of 95 GROUP 9 Duet Online Consignment Store 9 0 USER INTERFACE DESIGN Screen shots of the In Store TO BE system About Duet Consignment System D HSH Burl Consegna Sefbwarr all 2002 CIS 491 Project Team 9 oytech Application beseloprent Taa New Jersey Institute of Technology Software Deeglrtegent bey Veytech besaletegent Tao Cop
8. GROUP 9 Duet Online Consignment Store 8 In the future would you like to buy items from Duet using Internet LI Yes LI No 3 2 2 Questionnaire Results The following are the results of the questionnaire from customers of Duet consignor store We distributed 65 questionnaires and we received 53 responses 1 How often do you use Duet Consignment Store At least once a week Every second week Once a month 2 Do you use Duet to 4 Are you using any other consignment store other than Duet Yes To Sell Yes To Buy No 5 If you answered Yes To Buy please specify why When the item was less expensive When couldn t find item in the store near me It was convenient to me No reason 6 Would you like to have ability to access and check your account online for Duet Consignor Store Page 33 of 95 GROUP 9 Duet Online Consignment Store My knowledge about computers is limited Its not secure I don t use Internet 3 2 3 Questionnaire Results Summary Results from our questionnaires distributed among customers of Duet Consignment Store shows that new system is needed and recommended for this store Out of the 7396 of active customers that use this store at least once in the period of two weeks 63 is using it to buy and sell items For 40 of respondents Duet is the only consignment store they are using Over 90 would l
9. REFERENCES 95 12 APPENDIX A Diagram References Al 13 APPENDIX B User Manual e Bl 14 APPENDIX C Setup Instructions CI 15 APPENDIX D DUET Source Code DI Page 3 of 95 GROUP 9 Duet Online Consignment Store 1 0 Introduction 1 1 Abstract We will build an online and in house solution for improving the organizational and operational activity performed at the DUET Consignment Store The store manager sales personnel as well as the customer consignor will function as the principal users of the new system The consignor will also have the ability to perform such tasks from the console located at the consignment store For added convenience the consignor will have the ability to view his account online and track all the items that he is willing to sell or buy On the other hand store personnel directly associated with this system will access the system from the store The system will include the following features Consignor Records Zo Access to contact information including postal and email addresses phone numbers account balance items and commission percentages Consignor s detailed inventory data including number of items dates in prices and settlements Inventory Organized by item number category description date in price and quantity Pricing
10. including original current and lowest price for each item Items sold date price invoice number and consignor Page 4 of 95 GROUP 9 Duet Online Consignment Store Reports Consignor reports with printable lists P Inventory reports including type category consignor price range date in date of last sale date discounted Sales reports by date salesperson total amount and payment method Financial reports D User customized sales invoices This list of features contains every function needed to keep sellers buyers inventory sales accounting and reporting flowing smoothly 1 2 Background Given the current state of financial stability people are looking to save money in every possible way One of the many ways to do this is through purchasing used goods that are still exploitable yet are not desired by their original owner Over the past few years consignment shopping has become more popular and the stigma that was once associated with buying pre owned clothing no longer exists Today people are beginning to realize that a savvy shopper is a smart shopper and that there can be great satisfaction finding a great bargain There is a consignment store located in New Jersey named Duet that carries a wide variety of high quality and brand name clothing and accessories including but not limited to shoes belts scarves purses and even hats Over the last few years Duet has seen a
11. slow but steady increase in its customer base With the increase in business the current work situation is becoming more difficult to run and manage One of the areas that are hindering potential increases in business growth is its reliance on an outdated software application Page 5 of 95 GROUP 9 Duet Online Consignment Store The existing As Is DOS based system is built around the necessity to create paper documents The inventory control system and open to buy system is built around a database spreadsheet program The consignment store s activities and inventory are tracked by spreadsheets The computer is located at the main office and is not connected with the register on the floor which provides summary information At the end of the day the register report is forwarded to the main office and is entered into the computer In all the entire process is a combination of manual work along with computer work Unfortunately the current work setup makes it very hard to perform important tasks such as updating inventory information producing summary reports bill payments to the consignors or even showing consignor account information on demand The system currently being used involves a great amount of manual data entry which leads to a high amount of time spent on input and output activities and system maintenance 1 3 Problem Statement We propose to design DUET s Consignment Store a user friendly software system that
12. Consignment Store that are being sold the user must open at least six other pages before being directed to the place where the user can begin his shopping experience Organizational problems continue once in the shopping area All categories are listed on the side of the screen yet the user does not have a firm grasp of where exactly on the site the user is located Furthermore the site oddly includes links to other web sites that are selling new items at higher prices than what can be found on the current page The Product List link placed on the consignor site will take you to other retailers This web site gave insight into what kind of mistakes should be avoided in the design of the DUET System http www edoubletake com Edoubletake com is a web based consignment store that benefits from good organization planning and implementation The entire sidebar evident for all pages has the same layout with the most important links highlighted and easy to see This helps for quick navigation to various important information and services Consignors can search for specific items by using a search engine which helps expedite the entire process Overall this site is user friendly and effective and it implements a reliable design http www consignmentsuccess com Consignmentsuccess com is a site that provides a downloadable package that includes an application along with Web capabilities The package implements well designed da
13. Routing Number Bank Account Number Consignor Login Login Username Password PIN Username Letters Numbers Password Letters Numbers PIN Numbers Page 56 of 95 GROUP 9 Duet Online Consignment Store Letters AIBICI IZlalblcl 1z Numbers 01 1121 19 Page 57 of 95 GROUP 9 Duet Online Consignment Store 6 0 System Design 6 1 SYSTEM STRUCTURING SYSTEM DESIGNER CONTROLLER SYSTEM SALE PERSON CONSIGNOR DATABASE CONTROLLER CONTROLLER SALE PERSON STORE MANAGER CONTROLLER owner Page 58 of 95 GROUP 9 Duet Online Consignment Store 6 2 ABSTRACT MACHINE Page 59 of 95 GROUP 9 Duet Online Consignment Store 6 3 SEQUENCE DIAGRAM 1 Authenticated use gt 2 Authenticated 3 Select Item type Reply price Acknowledge 4 Report Item Number DP Send price 5 Report Price Page 60 of 95 GROUP 9 Duet Online Consignment Store 6 4 CLIENT SERVER ARCHITECTURE Wide Bandwidth Network Page 61 of 95 GROUP 9 Duet Online Consignment Store 7 0 ERM MODEL Generates Opens Account Buys Page 62 of 95 GROUP 9 Duet Online Consignment Store 8 0 STRUCTURE CHART Consignor Info M To From Inventory 1 Consignor Item To Info From Inventory Updated Consignor Info T MANAGE CONSIGNOR ACCOUNT Updated Inventory Report
14. Store L o eat a Due Page 81 of 95 GROUP 9 Duet Online Consignment Store Login Attempt Failed Password Missing Login Attempt Failed PINs Missing LSA ure uc eee DWET LGConsignon STOPE Page 82 of 95 GROUP 9 Duet Online Consignment Store Login Attempt Successful Breit se report 00 AE r Manth af the vom EE rej ne e n saf 34 maj sa sa se ta Total Sala of The Mere 533 Total Soles Tax Collected Em Total amp of Sales Recorded L Page 83 of 95 GROUP 9 Duet Online Consignment Store Monthly Sales Report continued 5 x Month of the Fear u zl ne sl aal un al ava w cer mes gc neta Burerib Trvbate SubTotol SalesTax GrondTatal Salesepl aaa Teseo Levene 26 EE MA ipsoliz3o swzi4T 122002 350 zl an MEBBUT Total Salad of The Month Tad Total Salas Tax Collacteck 2440 Total of Salis Recorded 2 HORRI AM Sunday December 01 2007 SqiCamnectian Open SS AmE Month of the Year Zn F e e el Mor n sui Am 5w oer riy ze Tnvbatal Euyerih Invbate 1 SubTotal SalsTow GrandTatal Saleshapi Total Soles of The Month kon Tetol Sales Tax Colkectect tuna Total i of Sales Eerardech a kmz AM sunday December 0 SO qkanneefiani Open Page 84 of 95 GROUP 9 Duet Online Consignment Store Snap Shot of MSDE Data
15. The system should be compatible with the Windows operating system which is uploaded on the store computers 10 The system should operate on the hardware CPU Intel Pentium 4 1 GHz or equivalent RAM 512 megabytes Hard Disk 10GB free space for database 3 6 Requirements Specifications The Consignor Store Project will involve designing a system that will help to run and manage Duet Consignor Store with consignor online access to check and update personal accounts The following is a list of requirement specifications for the system 1 The consignors will have secure online access to personal account from any place with the Internet connection and any time 1 1 1 Login name password and personal PIN will be required to access the system 1 1 2 Consignor will be able to check only his personal account 2 The system will include a separate database to maintain information about consignors Page 44 of 95 GROUP 9 Duet Online Consignment Store 2 1 1 The database will contain following information Consignor ID name address phone number E mail address and payout history for all consignors registered in the system 2 1 2 The store manager and salesperson will have an option to add delete or modify consignor information 2 1 3 Consignor will have an option to view his account with remote access 2 1 4 The databases will be created using Microsoft SQL Server 3 The system will include Item Inventory Database t
16. wi shito have mostitssct Cogne cea JJ Care enter the dat shichweli replace he chosen kati Page 90 of 95 GROUP 9 Duet Online Consignment Store Consignor Personal Information Change City Consignor Personal Data ID Ligaer Paseo ACHT STT T 335 DEI MAT UM dep ontipnie edu Hama Mama Zheng Adelina Adel iret City Dari Pawa 12 Kiwa Sr work kaaa MJ DTOST Ua Fiame skri fer held poe ial sh bo have modifiac Pisses enter the daki stach acl epica Ine d Consignor Personal Data D Uger TS EU PIN maladi 335 D n ag 1234 depo Tint edu Hama AFfiamu Liimi Bddlina Adda City Dan Fara 12 his Sr work aaa HI OTOST PSST Eo Fiesse select the held you wi vh tn hayo miite car H Elma enter tha data shichwili replace he chosen kaki kees Etra Raw Back Page 91 of 95 GROUP 9 Duet Online Consignment Store Consignor Personal Information Change City Continued Fame More Ukame Bidii Aadlina City Den Pima 2 ee St eent Meek BL OTOG 1234867050 Fima select the feld you vast in heres modriedj Emmi Fiemme enter the dais which mil repipos the chosen md Commen amur successfully Logout Screen DUET Consignment Store LOGOLT PAGE States Liar DF is comment lo ggesd in Page 92 of 95 GROUP 9 Duet Online Consignment Store Successful Logout Welcome to DUET s Consignment Store Pheaze nuttianii caia yoaurso boon Hew Acco Eongot Password Coprigm 2002 NAT Al Ri
17. 0 cente Bam Apt Suite Citys town States d Zip Code un Clear Emiadd ef LE Duet Consignor Store ia alinin General ontact Options a mene liane ra por pr pz Last Hane fvenesso Middle Initia M Week Tat fora 222 fare First Hane wali gre ur fora dea ars Address Details Type Address Bor Poasa mai aen Suite z Cp d Tran Wiwel State ni Zip Code krezz Record ia Email Add Leni nj cda Page 71 of 95 GROUP 9 Duet Online Consignment Store Add Consignor Items into Database B additem Home Foren 1 238 741z See 7 0 HEEREEEDD zum sa m eist Ta pa Page 72 of 95 GROUP 9 Duet Online Consignment Store Add Consignor Items into Database continued Add New Employee to Database Duet Consignor Store Page 73 of 95 GROUP 9 Duet Online Consignment Store Add New Employee to Database continued Address Details di M pg m mm Address o ze Cm Tem State ax d L 5 Zipcodes waita Stews E Moda Emer Contacte _J EIER E ji ContactMunber submi i Relationship Ta You i Friend D LE Address Details Address 1 be Robeson Ave Address 2 i City d Town Im Zip Ende p7102 En Emergency Contacts Contact Ferzan Probert Lae Contac
18. Consignor Apartment Number Consignor City Consignor State Consignor Zip Code Consignor Identification Number Consignor ID Item Item Number Item Description Quantity Price Sales Person Account Sales Person Account Name Address Sales ID Pay Rate Status Sales Person Name Sales Person First Name Sales Person Middle Name Sales Person Last Name Sales Person Address Sales Person Street Sales Person Apartment Number Sales Person City Sales Person State Sales Person Zip Code Sales Person Identification Number Sales Person ID Pay Rate Hourly Salary Status Part time Full time Employee Payroll Management Page Payroll Name Address Employee Telephone Number Employee Identification Number Store Telephone Number Earnings Taxes Deductions Name First Name Middle Name Last Name Address Street Apartment Number City State Zip Code Employee Telephone Number Area Code Central Office Code Number Employee Identification Number Employee ID Store Telephone Number Area Code Central Office Code Number Earnings Regular Pay Holiday Pay Personal Pay Retroactive Pay Hours Worked Taxes Social Security Tax Medicare Tax Federal Income Tax State Income Tax SDI UC Tax Deductions 401K Deductions Medical Deductions Page 55 of 95 GROUP 9 Duet Online Consignment Store Consignment Store Invoice Invoice Con
19. ES Actual Completion Time TASK TASK PHASE NAME START DATE END DATE HUMAN RESOURCES DESCRIPTION ID ID OF PHASE 1 1 Group Creation September 3 2002 September 9 2002 Group 9 is formed Wojciech Baranowski e 2 Idea Realization September 3 2002 September 9 2002 Grzegorz Baranowski nea is Anthony Lopez Proj 3 Group Creation September 3 2002 September 3 2002 Entire Group Group efforts go 4 2 Initialization September 10 2002 September 17 2002 underway in this phase Project idea is 5 Project Approval September 10 2002 September 10 2002 Entire Group approved by instructor Wojciech Baranowski 6 Abstract September 10 2002 September 10 2002 Grzegorz Baranowski oe Anthony Lopez Wojciech Baranowski The stakeholders 7 Problem Statement September 11 2002 September 11 2002 Grzegorz Baranowski existing problems Anthony Lopez are explained Wojciech Baranowski e 8 Previous Work September 10 2002 September 11 2002 Grzegorz Baranowski Project research is tracked Anthony Lopez Project Wojciech Baranowsk 9 Methodology September 12 2002 September 17 2002 Grzegorz Baranowski methodology cycle is chosen F i Glossary of major Wojciech Baranowsk 10 Glossary September 13 2002 September 16 2002 5 terms and system Anthony Lopes Posi users is listed Proiect Project planning is 1 3 J September 17 2002 September 23 2002 performed in this Manage
20. GROUP 9 Duet Online Consignment Store overview the Consignment Store financial situation What makes the Store Manager more important stakeholder is a fact that he she is also responsible for a Consigner Store employees As a Store Manager he she has ability to manage employee s database and employees account payroll system A Store Manager makes sure that a Consignor Store and any sell buy operations are being done correctly with a customer satisfaction 3 Sales Person Another stakeholder in this system is a Sales Person who regularly has a personal contact with the client He she similarly to the Store Manager has power to use the system to open any new account and update inventory database for a new item that Consignor wants to sell or buy A Sales Person is able to maintain any Consignor s existing account on customer personal request 4 System Designer Another stakeholder is the System Designer a person that originally designed the Consignor Store system It is the responsibility of the designer to satisfy the requirements of the Store Manager and Sales People who come in contact with the system including the potential Consignors The designer has to keep eye on the system by maintain and update any databases files and accounts It is also his her responsibility to identify and eliminate any errors in the system He She knows exactly how the system should function and what features it should contain in order to satisfy custom
21. N The T F S z M rw 17 Analysis days Tue 374282 Mon 10702 E DEE ILE ALDE DST 18 Ehubchcider Andes E dapa Tue DAT Mon 23 M 13 Requirenents Galen Sds Mon SCHUM FIST ET WORD Hethod dys Tue 37442 Thu ONU H Bransironin for ie Po Idy Tue BUND Tue 30382 ES Service Tempisizs 2days Tue Sa red sve za Hierarchy Disoram Zdaja Wed NO muaa a wiem Pani Tenes Idy Wed DOSND Th PEW 25 Use Case Scenerin daya Fri IIC weedi pue 38 Requirements benno Sur Tier 37 Mende Fri Da a Fiowy Diagrams DADI Sds Thu S02 ec Lo 28 Functional Requrenents 3ds ThudDXiND ion ES Hon Funciional Requirena Sdays Thu 10090 Wei 30 Precess Specifications Sdays Tue MU Men ere ET Sructred Engish 5ds Tue MIND Monita ES Decison Trees Sds Tue De nia 33 Decsen Tables Zdays Tue MIND Mond naez 34 Beta Bictionary amp drys Tue HS Tue 102202 10 30 Te Det 27 1 Mov TE Here 10 02 Hor 17 DE D Task Meme Dureon Sisi Finish Mir wiT F s s mitoto m T mT F ls v w T F s s w T lw 38 User Interface Design To Bej ie TR he 0 System Design dayz Wed 0M Tue 18907 E LC 3T System Shruckre Sds V d 1D2102 Tue 1 38 Abels Machine Sara Wied 10 Tue drew KE COC 38 Sequence Diagram Sdara Wad DIO Te ile90z 100 40 Qient Serwer Archiectwe Sms Wed ND eigtl E ir 41 BA Model Ada Wed Man 11 002 es DOC 42 Strecture Chart Ada Wed USD Mon 11 002
22. NEW JERSEY INSTITUTE OF TECHNOLOGY DUET ONLINE CONSIGNMENT STORE COMPUTER SCIENCE PROJECT CIS 491 FALL 2002 Presented to Prof O ELJABIRI Coordinated by Wojciech Baranowski Grzegorz Baranowski Anthony Lopez Thien Le Minghui Hiu Daniel Pitera GROUP 9 Duet Online Consignment Store TABLE OF CONTENTS I Title Page II Table of Contents 1 INTRODUCTION INE IAA Le Bi se re 1 3 Problem Statement ie desu verre Ree 1 4 Previous WOK oO e en Ee e Ee PO a XR C Eva ti AA nas 2 PROJECT MANAGEMENT 2 1 Feasibility Study Cost Benefit Analysis SEENEN Mm 2 2 1 Work Breakdown Structure WBS 2 2 2 Project MilestoneSs oseannnnan 2 2 3 Gatt PA FALLAS e LR eec 2 3 1 Function Point Analysis eese 2 3 2 Cost Estimation using COCOMO II 2 4 Risk Management EE 3 ANALYSIS 3 1 Stakeholders Who and Why wweeo 3 2 Gathering IGEOLTRADOR ilaria 3 2 1 Ouestionnaire 3 2 2 Questionnaire ResultS 3 2 3 Questionnaire Results Summary 3 3 VORD MBA P 3 3 1 Brainstorming for View Points 3 3 2 Hierarchy Diagram 3 3 3 View Point amp Service Templates
23. ORTH ave Home Tel pra EJ sar Apt Suite Cell Tel ors EJ sed City Town ORANGE State i jar Zip Code ori Lo FZ Email Add D 1110 E hotmail com E oe Page 69 of 95 GROUP 9 Duet Online Consignment Store Add Buyer continued Bud yi Fil Fr Ti i fe 1D x Duet Consignor Store New Buyer Information General Buyer Ib pe ema ah catis o SAA picci bri First Hose i i e ML Eo fius mu amp 55862 Eat Fer EN Loo SEI Ei uz gt Address Details tact Options Address Boo w Wine fe Tek E eos beer Apt Suite City Town Kearny State ur ZipCode 07102 CR mm 7 EmailAdd Thomas amp lhotmailcom four Add New Consignor to Database era d nnt Typa Ji WIE Creata on Unda Dh fee hon Consigner Ip Sten x Met Payout R o Middle Initial a Contact Options SZER oo EEA r Address Details Work Tel E Address emra Apt Suie City d Town i State I Zip Code Sen Clear ip Code Record Email Add i Page 70 of 95 GROUP 9 Duet Online Consignment Store Add Consignor continued B Ad New Consignor To Datab ase JE xl Duet Sami Store New Consignor Information General Account Type Consignor ID E Met Payout po 2 Last Mame GG Middle Initial Fest Mame RER m m Address Details Work Tel Address
24. T All Righis Reserved Forgot Password Username does not exist in database Lise rears ma i ns d Copi ght 2002 JT AlFighis Reserved Page 87 of 95 GROUP 9 Duet Online Consignment Store Forgot Password Username exists in database Your password has been sent in your regiziorad ames address Copright 20072 KLIT Aa Fight ened Received E mail Containing Requested Information For testing purposes sent to designer s e mail address DB IUBE 5 F ras D rest m INBOX 97 of 8H kina Casa eire H LI Bea Poids Mp co ad Ate Kowasz Dan s Saad zn mazi is Bcc Cab Dis Tha 3 L Taur bhar Online Ford ims ciri Trac FI Humbar Ls 2504 Data Rama Baca do al act ie cj ade Hina C teu rranraga te Page 88 of 95 GROUP 9 Duet Online Consignment Store Successful Login Duet Consignment Store ri gner Meru Logged in User DP TO is carmen loggedin Users LEX 2125 Ca Paa Pema Logo Consignor Account Balance Page 89 of 95 GROUP 9 Duet Online Consignment Store Consignor Payout History Consignor Payout Report Produc Code Check Amount of Check Dota of Check 1124 256 as quon e 4 Consignor Personal Information Consignor Personal Data D Up Fassaord PIN Emal Acre ps 335 D I cisl UM dep hatin edu F Mama Mami Liame Sed ina Bodine ts Dan Paga 12 bigs St work former HI OTOST HE Fiesse select the heir you
25. asibility Study Cost Benefit Analysis Our group measured feasibility by figuring out how beneficial or practical the development of an information system will be to an organization We defined the cost benefit techniques as such System Costs can be grouped into two areas The first area is the cost associated with developing a system while the second area is the cost associated with its operation System development costs are considered one time costs and therefore will not reappear once the project has reached completion Examples of such costs include personal costs computer hardware and software training supplies and equipment costs Operating costs usually recur throughout the lifetime of the systems Examples are lease payments software license payments salaries and maintenance Benefits will be defined as either increases in profit or decreases in cost Benefits can be classified as Tangible and Intangible Benefits Tangible benefits are those that can be quantified such as a financial gain Intangible benefits are those that are too difficult or impossible to quantify For example one can refer to levels of customer satisfaction employee morale the ability for better decision making and the like Page 13 of 95 GROUP 9 Duet Online Consignment Store Cost Benefit Analysis Chart Project Consignment Store Economic Feasibility Study Cost Benefit Analysis Year of Project
26. base EN 3 KENN YSERVERYTVSDOTNET DLIETCONSIGNM H BE Database Diagrams E Tables ER E Authenticate i i E userid E password i E email E pin E EI Consignor i v E ConsignorID E ConsignorFirstName E ConsignorLastName E Consignormidinitial E ConsignorAddLine1 E ConsignorAddLine2 E ConsignorCity E ConsignorState o E ConsignorZipCode E Employee o E EmployeeNum E EmployeeFirstName E EmployeeMidInitial E EmployeeLastName E EmployeeAddLine1 E EmployeeAptNum E Employeecity E EmployeeState i i E EmployeeZipcode E ItemType Page 85 of 95 GROUP 9 Duet Online Consignment Store Screen shots of the Online TO BE system LOGIN SCREEN Welcome to DUET s Consignment Store Fine authend cale yoursell bakari Leeman lea mami Pri GI Loga Fam Bea Accou Forgot Password Copyright 2002 KIT Al Rights Frazerved Login Attempt Failed Insufficient Parameters Welcome to DUET s Consignment Stare Fiona auteni cale yourself baki lemme Passer PN TA Pam Hey Arccum Forgot Password Ad folds mest ba filled out campioa Copmighi 2002 HIT Al Fighis Frasered Page 86 of 95 GROUP 9 Duet Online Consignment Store Login Attempt Failed Username does not exist Welcome to DUET s Consignment Store Pieter After Bolo bread Login Picsss Fu miss Copy gt 2000 MJ
27. ccessible by a given user Furthermore the interface will be user friendly and easy to learn with minimal or no additional training sessions even for people that are not familiar with the computer technology In greater detail The DUET System will provide complete information about consignors store inventory sales activity and store revenues All information accessed within the online system will be pulled from a series of databases that hold all pertinent information The system will also generate daily monthly quarterly or annual sales reports for use by management Based on such information the DUET System will also provide an easier way to produce Consignor reports based on buying habits in order to do targeted promotions or mailings The databases will be linked in the sense that customers will be tied to their store merchandise which in turn is then tied to a sales invoice This allows for a complete trail of inventory activity to be stored as certain merchandise switches from an Available status to either a Sold or Returned status Page 7 of 95 GROUP 9 Duet Online Consignment Store For Consignors their account balances will be automatically credited and updated during the posting process in real time The DUET System will also keep track of the Consignor s personal information including name address phone number email address and purchase amounts Consignors will have access rights to change and add del
28. cond level of the data flow diagram things are broken down a bit further Both salesperson and consignor have access to modifying the consignors account in some way The salesperson and store managers also have the ability to add and delete accounts wherever this is seem fit The consignor can buy or sell an item to the consignment store Once this happens the inventory level must be adjusted to reflect the transaction Inventory will have its own separate database as will the consignor accounts The store managers receive the updated inventory reports and then do three things They will produce payout checks to consignors who have sold to the store produce payroll checks to store employees and will generate reports that will be sent to and analyzed by the owner of the store Just like the inventory and consignor accounts the employee information and payout history will also have their own separate databases Page 46 of 95 GROUP 9 Duet Online Consignment Store After decomposing further you can see how we broke down the Manage Consignor Account Manage Inventory Manage Payroll and Payout items The decomposition are in plain English and fairly simple to follow along Page 47 of 95 GROUP 9 Duet Online Consignment Store 3 7 2 CONTEXT DIAGRAM Consignor Info Salesperson Account Info Updates Logout Data Login Data Data Log Page 48 of 95 GROUP 9 Duet Online Consignment Store 3 7 3 GENERAL DFD
29. ctober 15 October 25 Anthony Lopez Thien Le iod Hs Pete Comprehensive well detailed October 28 November 4 Deugn design for the software is Minghui Hiu Daniel Pitera aa PHASE VI Implementation Full scale development of the Minghui Hiu software system is carried out November 5 November 29 Daniel Pitera l Minghui and Daniel Beta Wojciech Baranowski version is released upon Grzegorz Baranowski successful testing entire Anthony Lopez team Thien Le PHASE VII Documentation for the project Documentation is created by the team November s December sb Wojciech Baranowski including reference manual Grzegorz Baranowski tutorial manual developer Anthony Lopez manual and online help Thien Le system PHASE VIII Project Review m Final overall review of December 3 December 6 Parr da M software product along with Wojciech Baranowski A f Grzegorz Baranowski completion of system testing Anthony Lopez Thien Le December 7 December 10 PHASE IX Project 20 minute demonstration of Page 17 of 95 GROUP 9 Duet Online Consignment Store Release and Presentation Minghui Hiu Daniel Pitera Wojciech Baranowski Grzegorz Baranowski Anthony Lopez Thien Le entire development process and software product along with the release of the software project and any necessary documentation to the sponsor Page 18 of 95 GROUP 9 Duet Online Consignment Store PROJECT MILESTON
30. e client in the Consignment Store Consignor is the person who is interested in selling or buying different used or new items by opening their account in the Consignment Store As a new customer a Consignor gets a new consignment store personal account that helps him her to keep track of any activities in the store related to selling or buying his her items Consignor will be able to access personal account and modify his her personal information like address or telephone number by using previously assigned store consignor identification number Consignor will be able to verify current account balance check on payouts information and history 2 Store Manager The second important stakeholder in this system is the Store Manager He She is the person who tries to make a store attractive and have more and more new Consignors to keep the business running and making profit The Store Manager is responsible to create and maintain Consignor s account and inventory files He She takes and assigns for each Consignor s new item a price description and locates it in correct inventory database After the specific item is sold he she has to update inventory files and show the money against Consignor s account balance It depends on the store rules when a Store Manager generates final balance report of the account and makes payout to the Consignor A Store Manager has ability to run different kind of reports that they will help him her Page 30 of 95
31. er needs Page 31 of 95 GROUP 9 Duet Online Consignment Store 3 2 Gathering Information 3 2 1 Gathering Information Questionnaire Students from New Jersey Institute of Technology in Newark are developing new software for Duer e Consignment Store This system will be used by store personnel for in store activities as well as by customers consignors who will be able to access their personal accounts online from any location where an Internet connection is available Your feedback will help us design a system that will make buying and selling textbooks less painful for everyone 000 OOO OOO OOOO 0000 CH DO DDDCUGCO How often do you use Duet s Consignment Store At least once a week Every second week Once a month Occasionally Do you use Duet s Consignment Store to Buy items Sell items Both How would you rate your level of computing expertise Beginner Moderate Advanced Are you using any other consignment store other than Duet Yes to Sell Yes To Buy No If you answered Yes to Buy please specify why When the item was cheaper When I couldn t find item in the store near me It was convenient to me No reason Would you like to have the ability to access and check your account online for Duet s Consignment Store Yes No If no why My knowledge about computers is limited Its not secure I don t use Internet I don t need it Other Page 32 of 95
32. ete their personal information as they see fit Built in error checking in the form of warning messages will ensure that all data is entered correctly and completely in all areas and stages of the DUET system For instance all intended changes to Consignor account information would be prompted for confirmation before saving any changes additions or deletions 1 4 Previous Work Consignment has long been an option of doing business in society With the advent of the Internet and the World Wide Web it has become more advantageous to integrate the business structures of consignment for both online and on site By implementing Internet technologies consignment businesses can improve the quality of their work while also providing a much more interactive user experience for the customer With this trend new database software programs and web sites are entering the market During the research phase of the DUET System Project online tools were found that were specifically designed for consignor needs The DUET System aims to synthesize the best features of such existing tools while seeking to best serve the stakeholders http www netshoppingplace com consignment php Netshoppingplace com is one such web site that implements a good level of practicality yet can use some extra work to become a good and powerful site First of all this site seems to be inefficiently organized Before one can look into items Page 8 of 95 GROUP 9 Duet Online
33. ew employee manage this account by making any necessary changes to employee personal information Page 42 of 95 GROUP 9 Duet Online Consignment Store 6 Store Manager will be able to generate different kind of reports that should show financial condition of the store and help him her make any financial decisions 7 Store Manager will create payouts to the consignor on monthly based schedule unless otherwise request by consignor Each payout will be transferred to the payout history that each consignor will be able to check out by access his her personal account 3 5 2 Non functional Requirements 1 2 3 4 5 6 7 The system in general should be well organized and straightforward The system should be user friendly and easy to use It should be understandable to any client and no special training session should be required The system should prevent any unauthorized access and secure any private information The system should be easy to maintain and to provide any necessary updates that are required by users The system should be flexible while used more than one user at the same time The system should be reliable and satisfying all users The system should be available at all times and work with high performance Page 43 of 95 GROUP 9 Duet Online Consignment Store 8 The system should be cost effective The physical cost of the system should be within the system development budget 9
34. ghts Fears envi Page 93 of 95 GROUP 9 Duet Online Consignment Store 10 STATIC OBJECT MODEL DIAGRAM Store Manager Store Manager SS Store Manager Name Store Manager Address Add Consignor Modify Consignor Delete Consignor Add Employee Modify Employee Information Delete Employee Enters New Item Find Item Modify Item Delete Hem Generates Reports Updates Payouts to Consignor Prints Check 1 Hires Adds ile D 1 Generates Daily Daily Totals Sales Person Sales Person SS Sales Person Name Sales Person Address Sales Person Sallary Sales Person Hire Date Add Consignor Modify Consignor Delete Consignor Enters New Item Find Item Modify Item Delete Item Report Report ID Report Date Report Title Create Find Modify Delete Print Save Weekly Weekly Totals 1 Sales Buys Item Item ID Consignor ID Item Description Item Price 5 Add Find Modify Delete Consignor Consignor ID Consignor Name Consignor Address Consignor Telephone Consignor E mail Modify Consignor Info View Account Check Personal Inventory Sells Monthly Monthly Totals Buyer Credit Card Seller Account Direct Deposit
35. hat was explored was the spiral model This methodology was originally used to improve the waterfall design through a risk analysis stage After every small step in the design phase of the system a risk analysis study is done If everything seems to be progressing in an appropriate manner then the next phase of the system is commenced In the case that the risk is great then some backtracking must be done By doing risk analysis after every phase the developers try to eliminate the need to ever have to go back to fix errors in the system This process can also be lengthy and expensive but would save a developer a lot of time in maintaining the system No longer would every step need Page 10 of 95 GROUP 9 Duet Online Consignment Store to be reevaluated as long as the risk analysis is done appropriately The last methodology that was researched was prototyping Ultimately this was the methodology that was chosen for the DUET online consignment store project Choosing between the three was not as hard as initially expected Although each of these methodologies is a well established way about engineering software the DUET system is relatively small in scale and customer oriented By implementing a small scale system valuable input can be received on how to improve the system without building the whole system first The users could comment on the interface ease of use and functionalities before the final system is engineered Gatheri
36. her option 4 1 3 Ifthe Store Manager wants to Generate a Monthly Report 4 1 3 1 Then select Monthly Report 4 1 3 2 Else select another option 4 1 4 Ifthe Store Manager wants to Print out a Report 4 1 5 Then select Print Report 4 1 6 Else select another option Logout Page 51 of 95 GROUP 9 Duet Online Consignment Store 4 2 Decision Tree Store Manager Generating Reports YES MONTHLY Page 52 of 95 GROUP 9 Duet Online Consignment Store 4 3 Decision Table Store Manager Generating Reports Does the Store Manager want to generate a report What type of report does the Store Manager want to generate DA WK MO DA WK MO Select another option from the Store Manager Home Page Generate a Daily Report for the Store Manager Generate a Weekly Sales Report for the Store Manager Generate a Monthly Sales Report for the Store Manager Page 53 of 95 GROUP 9 Duet Online Consignment Store 5 0 Data Dictionary Consignor Personal Account Personal Account Consignor Name Consignor Address Consignor Identification Number Consignor Telephone Number Consignor Name Consignor First Name Consignor Middle Name Consignor Last Name Consignor Address Consignor Street Consignor Apartment Number Consignor City Consignor State Consignor Zip Code Consignor Identification Nu
37. ignment Store Grzegorz Baranowski Wojciech Data Dictionary is 34 6 Data Dictionary October 15 2002 October 22 2002 Baranowski 25 Re this Anthony Lopez 50 pm i vas GUIs and front 35 7 eet in October 22 2002 October 31 2002 Sii nt ni end materials are SR initially designed Front end and Back end System 36 8 System Design October 23 2002 October 29 2002 Architecture Layout is designed 37 System Structure October 23 2002 October 29 2002 Thien Le 38 Abstract Machine October 23 2002 October 29 2002 Thien Le 39 Sequence Diagram October 23 2002 October 29 2002 Thien Le Client Server 40 oi dle October 23 2002 October 29 2002 Thien Le i ERM Model is 41 9 ERM Model October 30 2002 November 4 2002 PERLES designed in this phase Structure Chart is 42 10 Structure Chart October 30 2002 November 4 2002 pire 5 created in this Baranowski 50 hasa Anthony Lopez 50 pee The system is hard coded and i dui the software and 43 11 t November 5 2002 November 27 2002 biol ate i hardware are evelopmen coordinated to produce the final release System Prototype Minghui Hiu 44 Design November 5 2002 November 15 2002 Daniel Pitera Final System Minghui Hiu 45 Design November 15 2002 November 27 2002 Daniel Piter Minghui Hiu Daniel Pitera Wojciech A Baranowski 25 Quality Assurance 46 12 System Testing November 27 2002 December 2 2002 Grzegorz is perfor
38. ike to have ability to access and check their personal accounts on the Internet The remaining 1046 are people that doesn t need this option or people that has limited knowledge about computers On the store manager request we also include a question about future options which is ability to shop online at Duet Over 72 of customers are in favor of this feature as well One of the questions included in questionnaire was about people level of computing expertise Almost 8046 response was at the moderate level This is telling us that new system cannot be too difficult to operate Page 34 of 95 GROUP 9 Duet Online Consignment Store 3 3 Vord Method 3 3 1 Brainstorming for View Points SET OF USERS SET OF FUNCTIONAL REQUIREMENTS SET OF NONFUNCTIONAL REQUIREMENTS Page 35 of 95 GROUP 9 Duet Online Consignment Store 3 3 2 Hierarchy Diagram an e ele Ppap LL Page 36 of 95 GROUP 9 Duet Online Consignment Store 3 3 3 View Point Templates and Service Template View Point Template and Service Template of Consignor Entity Page 37 of 95 GROUP 9 Duet Online Consignment Store View Point Template and Service Template of Store Manager Entity Page 38 of 95 GROUP 9 Duet Online Consignment Store View Point Template and Service Template of the Sales Person Entity Page 39 of 95 GROUP 9 Duet Online Consignment Store View Point Template and Service Template of Deve
39. late 22 Service Templates September 24 2002 September 25 2002 Anthony Lopez diagrams are Thien Le created 23 Hierarchy Diagram September 25 2002 September 26 2002 Wojciech Baranowski UT View Point TEE 24 Template September 25 2002 September 26 2002 Grzegorz Baranowski Template diagrams P are created Use Case Scenario 25 Use Case Scenario September 27 2002 October 2 2002 Grzegorz Baranowski diagram is created Requirements Second sub phase 26 Definition September 26 2002 October 7 2002 of Analysis Data F low Wojciech Baranowski DFD diagrams are 27 Diagrams DFD September 26 2002 October 2 2002 Grzegorz Baranowski created during this 9 Thien Le 5096 period Functional Bunetonal Wojciech Baranowski Requirements 28 keiomask October 3 2002 October 7 2002 Grzegorz Baranowski definitions are d Anthony Lopez 25 created during this period Non Functional Non Funchonal Wojciech Baranowski Reguirements 29 Battes October 3 2002 October 7 2002 Grzegorz Baranowski definitions are 9 Anthony Lopez 25 created during this period Structured English Decision Process Trees and a Specifications Dears 2092 Oche M 2002 Decision Tables are created in this phase 31 Structured English October 8 2002 October 14 2002 Anthony Lopez 32 Decision Trees October 8 2002 October 14 2002 Anthony Lopez 33 Decision Tables October 8 2002 October 14 2002 Anthony Lopez Page 20 of 95 GROU P 9 Duet Online Cons
40. loper Entity Page 40 of 95 GROUP 9 Duet Online Consignment Store 3 4 Use Case Scenario Diagram lt lt Uses gt gt TT LI Store Manager Sales Person Consignor i K ZN System Designer Page 41 of 95 GROUP 9 Duet Online Consignment Store 3 5 Requirements Definition 3 5 1 Functional requirements l Every consignor a store manager salesperson should login to the system using a unique username and password The system will have the option for the users to change their passwords There will be difference in abilities that each person will have after login process is completed store manager will have more accessibility then consignor Store Manager and Sales Person will be able to open a new account for every new customer They will be able to modify or delete existing account on a customer premise Consignor will be required to access his her account to be able to modify personal information check personal item inventory and to view their account balance and history of the payouts Sales People and Store Manager will enter manually any new item that consignor wants to sell into the inventory database They will be able to add any required comments and brief description to the input item There will be an easy way to maintain inventory files by finding item modify item info and delete item Store Manager will be able to open an employee payroll account for any n
41. mber Consignor ID Consignor Telephone Number Area Code Central Office Code Number Consignor Account Balance Account Balance Consignor Name Consignor Address Consignor Identification Number Current Balance Last Payout Payout History Consignor Name Consignor First Name Consignor Middle Name Consignor Last Name Consignor Address Consignor Street Consignor Apartment Number Consignor City Consignor State Consignor Zip Code Consignor Identification Number Consignor ID Current Balance Total Amount of Sold Items Last Payout Check Number Date Issued Total Amount Payout History Check Number Date Issued Total Amount Consignor Payout Payout Receipt Consignor Name Consignor Address Consignor Identification Number Payout Total Check Identification Number Consignor Name Consignor First Name Consignor Middle Name Consignor Last Name Consignor Address Consignor Street Consignor Apartment Number Consignor City Consignor State Consignor Zip Code Consignor Identification Number Consignor ID Payout Total Quantity Price Check Identification Number Check Number Page 54 of 95 GROUP 9 Duet Online Consignment Store Consignor Personal Inventory Inventory Consignor Name Consignor Address Consignor ID Item Consignor Name Consignor First Name Consignor Middle Name Consignor Last Name Consignor Address Consignor Street
42. med on Baranowski 25 D sem Anthony Lopez 25 Thien Le 25 Performed by e people outside of 47 White Box Testing November 27 2002 November 29 2002 Stakeholders the development team ia Hf lane o the id evelopment team 48 Black Box Testing November 29 2002 December 2 2002 Wajciech Barenewsk 29w with full knowledge Grzegorz Baranowski 25 Anthony Lopez 25 Thien Le 2596 of functionality and code Page 21 of 95 GROUP 9 Duet Online Consignment Store Final product i release and 49 13 dai sca December 3 2002 December 3 2002 Entire Group presentation ana POSEWAN scheduled for December 3 2002 2 2 3 PERT Chart TASK ID ACTIVITY TIME Days PREDECESSOR 1 PHASE I 6 Primary Requirements Gathering 2 PHASE II 6 I High Level System Architecture 3 PHASE III Prototyping 16 LU Throwaway or Revolutionary i 4 PHASE IV Formal Requirements 9 III 5 PHASE V Detailed Design 6 II IV 6 PHASE VI Implementation 19 IV V 7 PHASE VII Documentation 23 V PHASE VIII S Project Preview Presentation A MA 9 PHASE IX Project Release 3 Vill Also shown by the Visio charts below PERT CHART Data Flow Critical Path Non Critical Path Page 22 of 95 GROUP 9 Duet Online Consignment Store Gathering PERT Chart for DUET Online Consignment Store System PHASE Primary Re
43. ment phase Financial data for 12 SEN September 17 2002 September 19 2002 Anthony Lopez project is Analysis performed COCOMO Il COCOMO analysis 13 Analysis September 17 2002 September 18 2002 Grzegorz Baranowski is performed S Work Breakdown Wojciech Baranowski Work Breakdown Structure is set for 14 Eet September 17 2002 September 23 2002 pod du mmainder af the i project cycle Phase start and end 15 Project Milestones September 19 2002 September 23 2002 Anthony Lopez dates are set for the project Risk management 16 Risk Management September 19 2002 September 23 2002 Thien Le exercises are performed Page 19 of 95 GROUP 9 Duet Online Consignment Store More in depth analysis of project 17 Analysis September 24 2002 October 7 2002 is performed in this phase Project Stakeholders Thien Le stakeholders must Li Analysis SEET september 30 2002 Wojciech Baranowski be realized by this point Stakeholders are given a 19 P September 30 2002 October 4 2002 Thien Le questionnaire and 9 the results are analyzed here 20 VORD Method September 24 2002 September 26 2002 aw a Brainstorming of Praiano ideas on functional 21 View Points 9 September 24 2002 September 24 2002 Anthony Lopez and non functional requirements and users Wojciech Baranowski Grzegorz Baranowski Service Temp
44. ng requirements is very important however two parties may think differently about the same concept By designing the prototyped system the design team could figure out if it is meeting the needs of the consignment store If not then the design team could easily and inexpensively modify the existing prototype Once everything is finalized and approved the full scale model would be adopted 1 6 Glossary Consignors The customer for the DUET store and the main off site users of the software product These account access pages will feature some personal information on each registered consignor including postal and email addresses telephone numbers account balance and commission percentages Consignor pages will also include detailed inventory data including the number of items bought or sold transaction history product prices and settlements Page 11 of 95 GROUP 9 Duet Online Consignment Store Inventory Inventory pages tables will include information such as item number category product description purchase delivery date price and quantity Prices can include the original current and the lowest price for each item Any price discounts will be displayed along with the dates they came into effect This section will also include information such as items sold sale date price of item s sold invoice number and consignor Sales Organize by date invoice status name description type of payment and total Multi
45. o keep record of every item that consignor wants to buy or try to sell 3 1 1 The database will include item description price arriving date sold date and consignor ID 3 1 2 The Store Manager and Salesperson will have the option to add delete and modify item records as needed 4 By gathering information from consignor database and item inventory database store manager will generate all kinds of reports and manage payout service 5 The Consignor Project in general should be well organized and straightforward 6 The consignors should access their accounts by using all major standards compliant web browsers a Microsoft Internet Explorer 5 x or higher b Netscape 4 7 or higher 7 The system will have information tutorial which will guide all new or inexperience users Page 45 of 95 GROUP 9 Duet Online Consignment Store 3 7 DFD Diagram 3 7 1 Grammatical Analysis There are three main entities in our data flow diagram They are the consignor the salesperson and the store manager In the context diagram all of these entities are providing some sort of input to the Consignor Information System that will be implemented in our store In order to enter the system a person has to login All of these login records will be stored in a database as stated in the context diagram The output of all of the activities that happen inside this system will be reports that will be sent to the owner of the store for analysis At the se
46. ofit is equal to 1835 93 Tangible Benefits Worksheet A Improved Speed and Reliability 4 500 B Cost Reduction or Avoidance 2 500 Management Planning or Control C Improvement 2 750 D Improved Flexibility 3 000 E Other 0 TOTAL Tangible Benefits 12 750 Recurring Costs Worksheet A Application Software Maintenance 5 750 B Hardware Maintenance 1 500 C Incremental Data Storage 200 D Supplies 50 TOTAL Recurring Costs 7 500 One Time Costs Worksheet A Research and Development Costs 5 000 B New Hardware 750 C New Software Application 1 325 D User Training 1 000 E Other 0 TOTAL One Time Costs 8 075 Page 15 of 95 GROUP 9 Duet Online Consignment Store 2 2 Project Milestones 2 2 1Work Breakdown Structure WBS Work Plan Estimated Assigned To Hours Introduction Abstract 5 Wojciech Project Background 10 Anthony amp Le Problem Statement 15 Anthony amp Le Previous Work 10 Anthony amp Le Methodology 10 Anthony Glossary 10 Le Project Management Project Team amp Roles Assignment 10 Wojciech Work Breakdown Structure WBS 20 Wojciech Milestones 5 Wojciech Project Planning Gant amp Pert Charts 15 Wojciech Feasibility Study 15 Anthony Cost Estimation COCOMO 10 Grzegorz Risk Management 10 Anthony Analysis Stakeholders Analysis 10 Anthony amp Le VORD Method 15 Anthony amp Le Use Case Scenario 10 Anthony amp Le Requirements Definiti
47. on 10 Kenny DFD Diagrams 20 Grzegorz Gathering Requirements 20 Wojciech amp Grzegorz Process Specification 10 Grzegorz ERM Model 10 Grzegorz Structured Chart 10 Daniel Data Dictionary 15 Daniel amp Kenny Database Design 20 Grzegorz User Interface Design 40 Daniel System Architectural Design 10 Daniel Static Object Mode Diagram 10 Kenny Programming 30 Kenny Implement 5 Daniel amp Kenny Documentation 10 Daniel amp Kenny Testing 5 Entire Group Page 16 of 95 GROUP 9 Duet Online Consignment Store 2 2 2 Project Milestone Estimated Completion Time PHASE IMPLEMENTED AND BEGIN PHASE END PHASE ALLOCATED RESOURCES DESCRIPTION OF PHASE PHASE I Primary Interact with stakeholders to th th Requirements Gatherin ather information for the Saa Depend Wojciech boni SEN that will be Grzegorz Baranowski developed PHASE II High Level System Architecture Rapid high level design of September 17 September 24 Anthony Lopez system is created with little Thien Le technical details Wojciech Baranowski Developers construct alpha PHASE III Prototyping version of the software client th th Throwaway or Revolutionary Researchers enhance SEO SE Minghui Hiu understanding of project Daniel Pitera based on prototype continued stakeholders analysis etc PHASE IV Formal Requirements Wojciech Baranowski Grzegorz Baranowski Team revisits requirements and adds detail to requirements specification O
48. onths 0 15 0 166 4 42 months Page 28 of 95 GROUP 9 Duet Online Consignment Store 2 4 Risk Management How much will the project schedule depend on availability of end user staff 3 for analysis and testing Will stringent quality requirement for the proposed system add to duration 3 and cost for frequent inspections documentation and testing Is the end date fixed or flexible Do the intended users and their management accept and appreciate the 2 value of the new system or oppose it Will this be user s first experience with the type of system under 2 development Are the functional requirements clear orvague AA Will the new system require new maintenance procedures LZ Could implementation interrupt mission critical operations 4 Will user staff be available during development II Are critical tasks out the project team s control 2 Will the project require major hardware or software upgrades 3 Must multiple departments provide technical resources to the project 3 Is any software i e language database communications or tools for the project new to the development team 3 project __ project Note Rate Low to High from 1 to 5 Page 29 of 95 GROUP 9 Duet Online Consignment Store 3 0 Analysis 3 1 Stakeholders 1 Consignor Consignor plays very important role as a stakeholder in the Consignment Store system He She is the person who is th
49. ource Linzu el Code hi Page 26 of 95 GROUP 9 Duet Online Consignment Store Total Unadjusted Function Points result is 76 Since normal medium complexity appears to be a reasonable assumption our Value Adjustment Factor is 1 03 By multiplying both factors our Adjusted Function Points Factor is 78 3 Unfortunately at the present time there is no information available about the approximate number of lines of code per function point for ASP NET However we expect to those numbers to fall above the value given for VISUAL BASIC This way we have result of 2270 1 lines of code or 2 27 kilo source line of code KSLOC 2 3 2 Cost Estimation Using COCOMO II The scope of the project is well understood the tools used are well known and the similar online sites do exist Therefore we will use the organic mode of the COCOMO II model to calculate the estimated schedule COCOMO Attributes 3 Advanced Page 27 of 95 GROUP 9 Duet Online Consignment Store TEET EHE TN z Dmm alt eaae clade p aleja scoperto mami mr gs on ES LA Tita Duna Cossiga mem ian Pecpared Ehe Cep Hueareranki Wai Ce E gra t COCONO Naam ster ddfariad Hari T E pages maet fine la licwriepo YA czkcadar manidhis Since the six members of our development team will only be able to work on the project a maximum of 6 hours per week each we estimate the total time needed for the analysis design and implementation of our project to equal 4 m
50. ple price tags can be used Detailed invoices can be printed and emailed Taxes and net due payable amounts will be computed automatically The pages tables will include a second sales tax option as well as a user customized sale invoice There will also be drop down invoice menus for payment type payment terms and contact information Reports Consignor Reports will have printable lists Inventory Reports will include the following fields Type Category Consignor Price Range Date In Date of Last Sale and Date Discounted Sales Reports are organized by Date Salesperson Total Amount and Payment Method Financial Reports will also be an option to be used by Management only Settlements Print checks to consignors To be organized by Consignor the Number of Settlement Amount of Settlement Payment Method Sales Value Item Sold and Most Recent Settlement This will also record various other payments aside from cash check or credit card such as store credit or gift certificate Employees This section will be organized by name employee number items sold account balance last update and by the most recent sale Employees will able to Page 12 of 95 GROUP 9 Duet Online Consignment Store view account balances if any items sold commission percentage earned bonuses earned subtractions hire termination dates last updates most recent sales and most recent commission prints 2 0 Project Management 2 1 Fe
51. quirements PHASE VI Implementation PHASE VII Documentation PHASE II High Level System Architecture PHASE V Detailed Design PHASE VIII Project Review PHASE III Prototyping Throwaway or Revolutionary PHASE IV Formal Requirements PHASE IX Project Release and Presentation Page 23 of 95 GROUP 9 Duet Online Consignment Store Gantt Chart 11 02 Sep E TZ Sep 15 02 Sep 27 TE Sep D Tesk Mame Durs Shari F Mrl s wi wila shi wili s d r wIT F SIS 1 Group Creatiun 5 days Tee 9392 Kone W 1 dl E z dea Realirziiani z Tue DE kool w CG 1 den Tue SRO Tuam 4 invtializatinn Edas Tue 34000 Tue E Project Approval ide Tue BOE jean G Abstract los Tue BIO Tue Sam T Probien Shaement Ida Wed 0G Ydan Previous Pork Zdays Tue DOG vagana a Methodology 4days Th AG We r 10 Diosseny Idas FMS MonSnesz 11 Project Managemen 5 days Tue 341 92 Bon wre f Ores 12 Cost Here Analysts Tue IER musna LM m OT 13 COMO Andri idee Tue UTOR Wed SS DO 14 Work Been Sirunture E Tue DITO Manna tlb 45 Project Milestones 3 Thu Mon aaa TE 16 Fast Wanagemeni 4 days Thu Ewe Man S32 DIS La Se 2 112 das DE Du 13 12 Oot 30 DE D Task Meme Durston Stat Hh H T w T F S 5 MiT w r F s s Mm T w rT F s s
52. r plaz ZOZ HIIT Alii Berard Thin Product ir Licerawr Ga Yaman I M WAG AM Tuesday Hosenber 26 2002 SgiCosnactiere Open Add New Buyer Information TUS Arti hara Buyar To Database Duer Consignor Stare Mew Buyer Information General o okee Al Cora om eps DI Far Ia See cn Hep Emgang fi Shep eg Barani Buyer Ib MS First Man MI Geer License Last Home State A e r Addeass Details Coafde1 Options Address quem Aparsuitew mer Cyr tom States far Zip Cade Eraill addi ef WA EE WANA AM Tuesday Momenter 26 2002 SgiCosnectiore Open Page 68 of 95 GROUP 9 Duet Online Consignment Store Add Buyer continued HE Aal Kemer Burger To Database ala xl Duet Consignor Store New Buyer Information Genaral Buyer Ib REAR ZANA een ZE First Mame 1 Driver License Last Mame State m Address Details Contact Options ve I MMM AapySutes cum City Town State Jax Zip Code SWE e Email Add ell Record HE Aal Peer Duger To Chat aliae 7 ll xl Dust Corsignor Store New Buyer Information Genaral Buyer Ib qu W creata ae Mnazi TD For ther Beer og Tar Empheyes dick on the Save Parar First Mame Thomas MI Driver License pizza sons 14523 Last Flame erant State MJ Address Details Contact Options Address 220 LOTW
53. signor Name Consignor Address Consignor Identification Number Sales Person Store Telephone Number Item Consignor Name First Name Middle Name Last Name Consignor Address Street Apartment Number City State Zip Code Consignor Identification Number Consignor ID Sales Person Anna Bill Steve Lucy Store Telephone Number Area Code Central Office Code Number Item Item Number Item Description Quantity Price Subtotal Consignment Store Sales Report Report Store Address Store Telephone Number Item Current Total Sales Last Year Total Sales Store Address Street City State Zip Code Store Telephone Number Area Code Central Office Code Number Item Item Number Item Description Quantity Price Subtotal Current Total Sales Gross Sales Net Sales Last Year Total Sales Last Year Gross Sales Last Year Net Sales Consignor Payout History Store Form Payout History Store Address Store Telephone Number Consignor Consignor Identification Number Consignor Address Check Payout History Store Address Street City State Zip Code Store Telephone Number Area Code Central Office Code Number Consignor First Name Middle Name Last Name Consignor Identification Number Consignor ID Consignor Address Street City State Zip Code Check Store Address Check Number Check Amount Consignor Bank
54. solves the needs of the consignment store manager and its personnel while at the same time providing valuable services for the customer Consignor This new solution which implements NET technologies both along the front end and back end will help save money by automating many time consuming procedures and routines that would normally be done by hand in the store Among these would include updates of Consignor accounts Consignor Account History statements etc By implementing the new system much more time will be saved in administrative duties at a reasonable cost while also providing the Page 6 of 95 GROUP 9 Duet Online Consignment Store Consignor better access and control to his account information within the consignment store The decision to base the solution on Internet technologies allows for flexibility in setting the user requirements for the software Ideally the DUET Consignment Store System will run best under a Windows platform using Internet Explorer but its use will not be limited to such system settings By using Internet technologies the consignor will be able to access the system either on site or remotely 24 hours a day 7 days a week All areas of the system from user access to transaction processing will be protected by security measures such as a login procedure with password checking On top of this access rights will be set accordingly so as to only allow enough access to such information that should be a
55. t Humber 973 243 5560 H Beletionihig To vm Parent Page 74 of 95 GROUP 9 Duet Online Consignment Store Add New Employee to Database continued City Town Lite Falli State a e de Zip Code oral Worital Status ESA j Enail Add i Fighntmail can urbe OT Dependent E E Emergency Contacte sc jute GF Beh M 6r i EET Contact Persan Beinn Leroy ComtactMunber 231 5525685 submi ch Relationship Ta You Ebina D City Town Lire Falla Zip Code aat Email Add i tietemail cc Emergency Contacts arta Of Birth M bb mm Contact Persan Erion Leroy J conactMurber 701 6525564 submit Relationship Ta You EH Page 75 of 95 GROUP 9 Duet Online Consignment Store Generating An Invoice Pis Rust omini turn E i rapera Doh Sang Ha Bota Ad cracia an laica Fire Ta Beni finar Fei Firat Tine Trwc ce tae 258 2002 ey rarer omia ar Drau Pamba Three Fikar ore Pesi Gaby ira Torrey iliss teskaiki Buyer ao pa First tine neos tane zie 2077 e DM MM Page 76 of 95 GROUP 9 Duet Online Consignment Store Invoicing continued me Lrc MX wi Duet Consignment Store Speen wa zacho bot rom f Hee Jonny Dara Ard vacia an Ipsos Eege Tian Fbi ore Read Gaby liliss bstaik ES imm unen bun 30 2002 pe MES
56. tabase screens with buttons that are easy to navigate often in the form of one click access from one screen to another What makes this package very powerful is that it successfully integrates both an application for tracking things such as inventory and point of sale activities but it also gives the online user as good an experience as can be aside from being at the store itself With this said there are still Page 9 of 95 GROUP 9 Duet Online Consignment Store some features that can be added Such lacking features include customer online access to personal accounts payment history screens pages showing the status of items and also a customer information update page The DUET System project will include such features to make the user experience a more empowering one 1 5 Methodology In dealing with our project the team came about many different methodologies to choose from such as the spiral model the waterfall and prototyping The waterfall methodology is the forefather of many other methodologies This method relies on the fact that each process cannot take place until its preceding task has been accomplished If there needs to be any changes in the system then every step must be reevaluated in sequential order starting with the task before it The waterfall method is extremely reliable when it comes to end results but the process can get lengthy and expensive This could make maintenance a nightmare The second methodology t
Download Pdf Manuals
Related Search