MSE Project Presentation 1 A Threetier Online Model

MSE Project Presentation 1 A Three-tier On-line Model For Transactionbased Applications Using VB. NET Technology By Lian Li Committee: Dr. William Hankley (Major Advisor) Dr. Gurdip Singh Dr. Mitchell Neilsen Department of Computing and Information Sciences

Acknowledgement § Thank: Dr. William Hankley Dr. Gurdip Singh Dr. Mitchell Neilsen Department of Computing and Information Sciences

Overview of the Presentation § Project Overview § Major Contribution § Project Plan § Requirements § Tools and Approaches § Prototype § Cost Estimation § Reference Department of Computing and Information Sciences

Overview - Three-tier Model § Structure of the Model for this project Department of Computing and Information Sciences

Overview – Objective of the Project § Developing a 3 -tier on line College Enrollment System (CES) as well as tutorial with examples, snap shots, instructions to serve students to grasp VB. NET in a possible short time. § There are two deliverables: § § The program The tutorial Department of Computing and Information Sciences

Overview - ADO. net, ASP. net § § ADO. NET – An extension of Microsoft’s Active. X Data Objects that enables. NET applications to access and manipulate database. ASP. NET – An integral technology for creating dynamic Web content marked up as HTML. Web Forms provide GUIs for ASP. NET pages and can contain Web Controls, such as labels, buttons and text boxes with which users interact. Department of Computing and Information Sciences

Major Contribution § Three-tier model set up in VB. net § The tutorial with examples, snap shots and instructions/guide for future students § The framework established in this project can be applied to the small business environment Department of Computing and Information Sciences

Project Plan Department of Computing and Information Sciences

Requirements § § § § Log into the CES system as a student or registrar with appropriate userid and password A student enrolls a course by selecting the course list A registrar updates student information A registrar updates course information A registrar add a student information A registrar add a course information A student view enrollment information A student drop a course Department of Computing and Information Sciences

Tools § Oralce 9 i (version 9. 2) located on Unix box § ASP server as the web server § MS Visual Studio. NET 2003 as the development IDE § ADO. Net for communication development between client and databases § ASP. Net serves web development Department of Computing and Information Sciences

Approaches – Domain Model Department of Computing and Information Sciences

Prototype 1 Department of Computing and Information Sciences

Prototype 2 Department of Computing and Information Sciences

Cost Estimation – LOC Based Total LOC estimate = 1/6(sum of Max + sum of mix + 4*(sum of best guess)) Total estimate LOC of this project: 3650 Department of Computing and Information Sciences

Cost Estimation -COCOMO § Application Program Calculation: PM = 2. 4 * (KDSI)1. 05 = 2. 4 * 3. 61. 05 = 9. 2 (person-month) TDEV = 2. 5 * (PM)0. 38 = 2. 5 * 9. 20. 38 = 5. 8 (month) Department of Computing and Information Sciences

Cost Estimation – FP Based Simple Average Complex Sub. Total Count Weights Count Weight s Inputs 0 3 7 4 1 6 34 Outputs 6 4 0 5 0 7 24 Inquirie s Files 0 4 3 5 0 7 18 0 7 3 10 0 15 30 Interfaces 0 5 0 7 2 10 20 Total 126 Department of Computing and Information Sciences

Cost Estimation – Adjusted FP Complexity Weighting Factors Rate (1 -5) Does the system require reliable backup and recovery 1 Are data communications required? 3 Are there distributed processing functions 2 Is performance critical 4 Will the system run in an existing, heavily utilized operational environment 3 Does the system require on-line data entry? 4 Does the on-line data entry require the input transaction to be built over multiple screens or operations Are the master files updated on-line 3 Are the inputs, outputs, files, or inquiries complex 5 Is the internal processing complex 4 Is the code designed to be reusable 3 Are conversion and installation included in the design 4 Is the system designed for multiple installations in different organizations 4 Is the application designed to facilitate change and ease of use by the user 4 Sum 47 4 Department of Computing and Information Sciences

Cost Estimation – Adjusted FP (cont’) Adjusted FP = FPunadjusted*(. 65+. 01*sum of ratings) = 126 * (. 65+. 01*47) = 141. 12 TDEV = 4 month (40 Function Points per man month) Department of Computing and Information Sciences

References § § § § § H. M. Deitel, P. J. Deitel, Visual Basic. NET: How to Program, 2 nd Edition, Prentice Hall, 2002 R. S. Pressman, Software Engineering: A practitioner’s Approach, 6 th Edition, Mc Graw Hill, 2005 Visual Basic. NET complete, San Francisco : Sybex, c 2002 L. Bernstein and A. Lubashevsky, "Living with Function Points", in Software Management, 5 th Edition, 1997 David Gustafson, Schaum’s Outlines: Software Engineering, Mc. Gral-Hill, 2002 http: //www. startvbdotnet. com/extras/vbdotnet. htm http: //www. johnsmiley. com/visualbasic/vbhistory. htm http: //www. devasp. net/search/display/category 292. html http: //www. projectperfect. com. au/info_fp_oview. php Department of Computing and Information Sciences

Suggestions Department of Computing and Information Sciences