Case Tool Analysis You may do either the Written Assignment or the Hands-On with MySQL workbench Assignment. You are not required to do both. The assignments are quite different. The written assignment will require research on CASE Tools. You will look at a variety of different tools, in limited depth. The Hands-On assignment requires work with a specific tool, namely MySQL workbench. You will perform a short database design exercise and turn in several of the artifacts that you create. The assignments have equal weight (10%) in your final grade. Written Assignment This assignment gives you the opportunity to analyze CASE tools and provide a justification for the use of one. This assignment specifically addresses the following course outcomes to enable you to: • Plan, build, and maintain systems that meet organizational strategic goals by applying enterprise architecture and enterprise governance principles and practices • Achieve successful systems design, development, and implementation by effectively applying the role of systems engineering and integrating with project management • Effectively communicate with stakeholders to determine, manage, and document business requirements throughout the SDLC • Perform modeling to assist with analysis and decision making • Translate business requirements into systems by applying appropriate SDLC methodologies and incorporating industry best practices Assignment Imagine you are a team leader in a large software development organization and you want to improve a software development process (of your choosing) through the use of a CASE tool. In the tight economy purchasing new tools requires a strong justification and these tools are expensive. In this project search the Internet for CASE tool information and develop a paper to persuade your manager to purchase the tool for your team. The paper should be 2-3 pages in length, plus references page (no cover sheet), responding to the bulleted items below. The use of at least three (3) external resources (other than the textbook and classroom resources) is required; your sources should be scholarly sources, not Wikipedia and the popular press. Remember to correctly cite and reference the sources you use with APA format. Use the Grading Rubric to be sure you have covered everything. Submit your paper via your Assignment Folder as a Microsoft Word document with your last name included in the filename, and your last name on the first page of the document. Create a document that includes the following: • Identification of a software development process that needs a tool o This should include a brief commentary describing the existing need (of your choosing) for a certain type of CASE tool. o Your manager does not know anything about these tools so you will need to explain what CASE tools do and how the use of a CASE tool will benefit your organization • Comparison and Contrast of 2 CASE tools that could meet your need o This should include a brief commentary describing two possible CASE tools that will fit your need. o Compare and contrast the two tools and explain which one is the better fit for your organization and why. • Persuasive justification to your boss to purchase the tool o This should include a brief commentary that persuades your boss to purchase the tool you are suggesting. o Include costs and benefits. Helpful Resources: • APA Style http://www.apastyle.org/ • Case Tools Textbook, "Systems Analysis and Design" Systems Analyst Toolkit Part 2, CASE Tools, page 632 • Agilian Necessity for Agile Modeling – Screenshots http://www.visual-paradigm.com/product/ag/provides/screenshots.jsp • Agilian Necessity for Agile Modeling – Diagram tools http://www.visual-paradigm.com/product/ag/provides/diagramtools.jsp • Index Case Tools http://case-tools.org/ • Case Tool Index http://www.unl.csi.cuny.edu/faqs/software-enginering/tools.html • iTM Web: Case Tools http://www.itmweb.com/case.htm • Persuasive Essay Thesis Builder & Online Outliner http://tommarch.com/electraguide/thesis.php • Persuasion Map http://www.readwritethink.org/files/resources/interactives/persuasion_map/ • Sample Persuasive Speech Outline http://www.roch.edu/people/lhalverson/sample_persuasive_speech_outline.htm Tools that can assist you in developing the graphics for this project: • The file “Graphics That Can be Used for Drawing Diagrams” in the Course Content section of WebTycho has symbols you may be able to copy and paste • “As-Is” and “To-Be” graphics o Microsoft Visio • Functional Decomposition Diagram (FDD) o Microsoft Visio o The file “Graphics That Can be Used for Drawing Diagrams” in the Course Content section of WebTycho has symbols you may be able to copy and paste • Systems Requirements Checklist o Microsoft Excel o Microsoft Word GRADING RUBRIC: Attribute Full Points Partial Points No points Possible Points Points Earned Process that needs a tool A software development process that needs to be improved is appropriately identified. A software development process that needs to be improved is somewhat appropriately identified. A software development process that needs to be improved has not been identified. 10 CASE tool explanation Explanation of what a CASE tool does and how it can benefit the organization is clear and accurate. Explanation of what a CASE tool does and how it can benefit the organization is somewhat clear and/or accurate. Explanation of CASE tool not provided. 20 Comparison and Contrast Two CASE tools have been identified, compared and contrasted and the explanation of the one selected as the better fit is well-supported. Two CASE tools have been identified, somewhat compared and contrasted and/or the explanation of the one selected as the better fit is somewhat well-supported. Two CASE tools have not been identified. 30 Persuasive Argument A persuasive, well-supported argument has been given for why your organization should purchase the tool including costs and benefits. The argument given for why your organization should purchase the tool is somewhat persuasive and/or well-supported; and/or costs and/or benefits have not been addressed. Argument was not given for why your organization should purchase the tool and costs and benefits have not been addressed. 30 Report Format Report reflects effective organization; correct sentence structure, grammar, and spelling; presented in a professional format; at least three appropriate references are used and are appropriately incorporated and cited using APA style. Report is not well organized, and/or contains grammar and/or spelling errors; and/or does not follow APA style for references used and citations; may use fewer than three references and/or references may not be appropriate. Report is extremely poorly written and does not convey the information. 10 Total Points 100 100 points =10% of final course grade Points Recorded (total points x .10) Hands-On with MySQL Workbench It is assumed that you have installed MySQL workbench. If you wish to install now, you may freely download from the following location: http://www.mysql.com/downloads/workbench/ Begin by skimming pages 396 – 410 in your text. You should also view the Video Learning Session: Entity-Relationship Diagrams (see page 405). Once you have done this, please do the following exercise: “Visual Database Creation with MySQL Workbench”. The exercise is here: http://net.tutsplus.com/tutorials/databases/visual-database-creation-with-mysql-workbench/ I believe this is a worthwhile and interesting exercise. Please use the following notes below to augment the exercise description. As you work the exercise, be sure to save your work as you go. • The first tables you will create are the teachers table and the students table. For the purposes of this exercise, you are only required to add the primary key teacher_id, the first_name field, and last_name field. You may add the other columns if you wish but they are not necessary. Do the same for the students table. For primary key fields check PK, NN, UQ, and AI. The primary keys are the fields with a little key next to them. • In the class_hours table you may enter VARCHAR(45) for the weekday field. When adding the table relationships: • Use 1:n for the teacher to classes table relationship. This is a 1 to many relationship: One teacher can teach many classes. Use the 1:n non-identifying icon. What happens to the classes table when you do this? • A teacher can teach many subjects. A subject can be taught by many teachers. This is a many to many relationship. Use the m:n identifying relationship icon to connect the teachers table with the subjects table. What happens when you do this? • One subject can be taught in many classes. This is a 1 to many or 1:n relationship. Using the 1:n non-identifying icon, connect the classes table (many side) to the subject table (1 side). • A student can be in many classes. A class may have many students. This is a many to many relationship. Using the m:n identifying relationship icon connect the students table with the classes table . • A class can occur at many different hours of the day. At any given hour there can be many classes. This is a many to many relationship. Using the m:n identifying relationship icon connect the classes and the class_hours tables. You are not required to do the next steps that generate a SQL script. In addition to the questions above please answer the following questions: 1) What happens when tables are connected using the m:n identifying icon ? 2) Give an example of each of the following. Do not use the tables or specifics from this exercise. Try to invent some examples of your own. a. 1:1 relationship b. 1:n relationship c. m:n relationship 3) What is the purpose of an Entity-Relationship Diagram? Refer to the CourseMate video learning session if necessary (see page3 405 of your text). In addition to your answers to the questions above, please turn in the model file (the .mwb file, for example onLineClasses.mwb) and the EER diagram. Please turn the diagram in as a pdf file. You can export the diagram as a pdf with File|Export|Export as Single Page pdf. Grading: Answer all questions thoroughly and completely 34% Submit mwb file with all tables and fields 33% Submit EER diagram as a pdf 33% In all cases partial credit will be given. For example if a table or a relationship is missing, a deduction will be applied but partial credit will always be available.