Description Assignment 2: Dropbox Assignment Creating a CRM Database To complete this assignment, you will need both MySQL Workbench and a local installation of MySQL Server. Both are available for free download at www.mysql.com under the Downloads (GA) tab. Scenario In W2 Assignment 2, you used MySQL Workbench to create an ER diagram for ABC Manufacturing's customer relationship management (CRM) system. The sales manager was so impressed with your work that he has hired you to create the database in MySQL. Tasks Based on the scenario and the requirements from W2 Assignment 2, using both MySQL Server and MySQL Workbench, create a schema called ABC_YourLastName. In this schema, create all the necessary tables, columns, and relationships to complete your database. You can download and view an example of MySQL Schema called "MySQL Sample Database" at www.mysqltutorial.org. To submit your database to the Dropbox, you must export the schema to a file. To perform an export, complete the following steps from the MySQL Workbench Home tab: Click Manage Import/Export under the Server Administration column. Make sure Data Export is highlighted on the Task and Object Browser. Check the box next to ABC_YourLastName in the left dialog box. Under Options, select the Export to Self-Contained File radio button and note the file path. Change the name of the file from the default to SU_ITS2110_W3_A2_LastName_FirstInitial.sql. Click Start Export. When the export is complete, you will need to upload the file to the Dropbox. In addition, complete the following tasks in a 2- to 3-page Microsoft Word document: Describe your database. Explain which tables, columns, keys, and so on will be seen in the schema. Support your responses with examples. Cite any sources in APA format. Submission Details Name your database SU_ITS2110_W3_A2_LastName_FirstInitial.sql. Name your document SU_ITS2110_W3_A2_LastName_FirstInitial.doc. Submit your document and the exported file to the W3 Assignment 2 Dropbox by Week 3, Day 6. Assignment 2 Grading Criteria Maximum Points Created and exported the required schema by using MySQL Server and MySQL Workbench. 40 Included all the required tables in the database schema: Clients, Contacts, Sales Person, and Contact Summary. 40 Included appropriate columns in all the schema tables. 25 In each table, included the necessary foreign keys to create the relationships. 25 Submitted an explanation of your schema including information on tables, columns, and foreign keys. 30 Written components. 40
Description Assignment 2: Dropbox Assignment ER Diagrams In this assignment, you will develop an ER diagram for the given scenario. To complete this assignment, you will need MySQL Workbench. MySQL Workbench is part of MySQL Install which includes both MySQL Server and MySQL Workbench. They are available for free download in one package at http://dev.mysql.com/downloads/workbench/. Scenario You have been hired by the sales department of ABC Manufacturing. Mark Harris, the sales manager has requested that you develop an ER model for his customer relationship management (CRM) system that he is proposing. The requirements for the database are: The model must store mailing and contact information for all clients. The clients may have multiple contacts. Each of these contacts may have a different address. The model must store short description of each e-mail, conversation, or mailing to each client. The model must attach the client to the assigned sales person. Harris believes four entities are required to accomplish the above tasks. Tasks Using your knowledge of database models and their design, accomplish the following tasks: In MySQL Workbench, create an ER diagram that meets the above requirements. Include both Entity Classes and attributes that are necessary, given the above requirements. Save your ER model as an .mwb file. In a separate Microsoft Word document, describe the various relationships between the different entities in the ER diagram. Cite any sources in APA format. Submission Details Name your ER diagram file SU_ITS2110_W2_A2_LastName_FirstInitial.mwb. Name your document SU_ITS2110_W2_A2_LastName_FirstInitial.doc.
Description Using the scenario provided in the Milestone Three Guidelines and Rubric document, provide a web consult, summarize at least 10 of the key functionalities of a potential website, provide and justify practical suggestions to improve the quality of the website, and identify a current website that models the two suggestions. Include supporting screenshots that highlight the functionality. Additionally, provide several recommendations for information security practices for the distribution company. Provide a real-world example of an information security assurance failure to illustrate the importance of these practices. Submit both summaries in one Word document with supporting screenshots embedded in the document. To complete this assignment, review the following attached documents: After you review the rubric for this milestone, watch the (Milestone Three Walkthrough video tutorial) video below for additional guidance on how to complete the milestone.
Description Using the scenario provided in the Milestone Two Guidelines and Rubric document, create and document the necessary code changes that are requested. Prepare a brief descriptive summary of the networking configuration of the wired visual configuration from the diagram provided, and use this to create and describe a Visio diagram to represent a wireless networking configuration appropriate for the company. Describe all aspects of the network using IT terminology. To complete this assignment, review the following attached documents. After you review the rubric for this milestone, watch the Milestone Two Walkthrough video tutorial for additional guidance on how to complete the milestone. Milestone Two Walkthrough video tutorial:
Description Week 1 Assignment 3: Dropbox Hierarchy Charts In this assignment, you will learn how hierarchy charts are used to represent program design. you will create a hierarchy chart. Creating a Hierarchy Chart Using the South University Online Library or the Internet, research on hierarchy charts. Based on your research and using one of the appliances that you chose in W1 Assignment 2, complete the following tasks: Using Microsoft Word, Microsoft PowerPoint, or Microsoft Visio, create a hierarchy chart that reflects the appliance's modules and how the modules call each other. Keep in mind that a hierarchy chart is different from a flowchart or pseudocode. In about 2 paragraphs, describe what your hierarchy chart represents. Support your responses with appropriate examples. Cite any sources in APA format on a separate page. Submission Details Based on the tool you chose to create the hierarchy chart, name your deliverable as: SU_ITS2104_W1_A3_LastName_FirstInitial.doc if it is a Microsoft Word document. SU_ITS2104_W1_A3_LastName_FirstInitial.ppt if it is a Microsoft PowerPoint presentation. SU_ITS2104_W1_A3_LastName_FirstInitial.vsd if it is a Microsoft Visio document. Submit your hierarchy chart and the Alice World file to the W1 Assignment 3 Dropbox
Description Programming Project: CREATE THE FOLLOWING PROGRAMS, AND SUBMIT RESULTS USING THE PROVIDED LINK BELOW: 1. (40 points) Create a Raptor program to display the numbers 1-10. Although you could program a solution that has ten lines of code like the following, think about why this would be a bad idea when developing a programming solution: Print 1 Print 2 Print 3 Print 4 (continued to Print 10) You have done this in Java in week 6. As you know, you need to have RAPTOR installed and operational on your system to do this program in Raptor. 2. (40 points) Create a program in Raptor OR Java for Running average. While the user enters non-negative numbers, display the total number of entries and the running average. (the program will be terminated when a negative number is inserted < 0 - Less than zero). 3. (60 points for Flowchart and Pseudocode) - Design the logic (both Flowchart AND Pseudocode) for a program that outputs every number from 1 through 20. Flowchart for 30 points AND Pseudocode for 30 points AFTER COMPLETING ALL ABOVE, SUBMIT YOUR RESULTS USING THE PROVIDED LINK BELOW:
Description In this lab you will complete an application that uses the Abstract Data Type (ADT) stack. The word documents are Java files (I cannot upload .java files)
Description In this lab you will complete two applications that use the Abstract Data Type (ADT) list. The word documents are Java files (I cannot upload .java files)
Description Fixing Payment Card Industry Java Web Application Overview In this homework, you will modify an existing Java Web application that violates several Payment Card Industry guidelines and recommendations. Your task is to locate the issues, based on the readings for this course, identify what is wrong and then fix the code. You will discuss each issue in terms of why the issue may cause a security vulnerability, and how you specifically fixed the issue. Assignment Review, Run and Understand the Sample Java Web application. The current code, uses Java JSP and Servlets to allow a user to login to their account and view credit card data stored in the database. The functionality is relatively simple but several PCI compliance rules have been violated that will prevent the application from being approved by a PCI software auditor. You should first load up the application, populate the database and make sure the application is working in your environment as expected. The application uses the Java Derby relational database. The script used to populate the application is attached in your project folder as well as the Java web project itself. You should be able to open the existing project using Netbeans. However; you may need to load the Derby drivers to the libraries for the project. You can create a new database connection by clicking the services folder and then right mouse-click on Databases select new connection. You can then create a connection for the SDEV425 database. Below is a screen capture that represents my configuration.There are some tutorials on the Internet on using the Derby database within Netbeans. (e.g. https://netbeans.org/kb/docs/ide/java-db.html) The key is making sure you have the drivers in the library of your project and you run the scrips to populate the tables. To execute a command in the database from within Netbeans you right click the connection and select execute command. A window will then pop-up for that connection and you can execute any command, including all of those database scripts provided to you. Once you have the database loaded, you can try the application. (This assumes you have properly installed the Java EE when you installed Netbeans). To launch the application, just highlight the java project you loaded (SDEV425_HW4) and click the green arrow. Once launched, your glassfish server will start and your default browser will be invoked. The application will automatically launch and the home page will be displayed. You can (and definitely should) review the database script to see the current users and associated passwords. As a test, you can click the Sign in link and enter this account information.Email: james.robertson@umuc.edu Password: mypassword After successful sign-in you will see the welcome message displayed: 5 Clicking on the Your Account menu will display the credit card information. Clicking on Sign out will invalidate the current session. Be sure to demonstrate the application runs properly in your development environment. Carefully, review the code and perform analysis as needed. You should experiment with running the application as well as reviewing the code to identify possible areas of security concerns. You don’t have to be an expert in JSP/Servlets, html or css to be able to find some of the issues that you have read about in the PCI documentation. However; it is recommended you experiment with the code so you have a baseline familiarity with the model and know how the JSP and servlets communicate with each other. Focus on the PCI compliance issues found in sections 6 through 9 as you look for issues. There are multiple issues and you should work to fix and document as many as possible. Hints: a. Make sure your Java EE Netbeans is working properly. b. Work to get the Derby database populated and working with the SDEV425_HW4 Web application. c. Study and experiment with the code. For example, even if you haven’t used CSS style sheets before you should be curious about how color schemes are used and how easily they can be changed in the css file. You should also note how the database connections are made and how JSP and servlets communicate. d. Again, start on this early. This will take you longer than you think. Deliverables Provide all of your modified Java code, your modified database script and a PDF document describing how you addressed each issue. You should clearly describe the code and what PCI compliance issue were violated and how you fixed it. You should provide screen captures as needed to support your findings and improvements. Be sure your PDF document is neat, well-organized and is well-written with minimal spelling and grammar errors. I need these (7) answered, please make sure you provide me with answers with questions below. 1. Demonstrates the Java application is running properly in your development environment. 2. Identifies PCI compliance issues found within the application. 3. Fixes and documents the PCI compliance found during the analysis. 4. Provides all modified Java code, modified database script and a PDF or word document describing how each issue was addressed. 5. Provides screen shots and descriptions of the successful executing the code and the resultant output as applied to each security control. 6. Document is neat, well-organized and is well-written with minimal spelling and grammar errors. 7. All references used should be included in your document. Note: Please you all the files attached for the work, Thank you.
