Expert Answers

Description OPTION #1: PHASE 2: MAMMA MIA PURCHASING – DATA FLOW ANALYSIS Please refer to the full description of the Mamma Mia Purchasing project in Week 8. This week’s paper should include well-detailed diagrams prepared with MS Visio or any other drawing program – no hand-drawn diagrams are allowed. The paper will document the complete data flows through DFD diagrams (not the current, “old” manual data flows, but the new system’s data flows.) There is no word count requirement for this paper -- the specific subsection headers to include are as follows: Note that for Module 4’s Portfolio Milestone, you completed parts 1-4. For this Milestone, you will complete part #5. 5. DFD Diagrams: Context/Level 0 Level 1, first diagram [Name of diagram] Level 1, second diagram [Name of diagram] Level 2, as many additional diagrams as needed. Include a title page and reference page. Make sure your paper follows APA style according to the CSU-Global Guide to Writing and APA (Links to an external site.)Links to an external site.. As support for your analysis, use at least two CSU-Global Library resources and/or outside, credible academic sources other than the textbook, course materials, or other information provided as part of the course materials. (You may not use Wikipedia for any CSU-Global assignment.) For this assignment, a credible source is defined as: Scholarly or peer-reviewed journal articles Newspaper articles Trade or industry journal articles, publications, or websites, including those from trade organizations. Consider CIO Magazine, the Harvard Business Review, Fortune, and similar solid sources. Please be sure NOT to use direct quotations from sources and, instead, use paraphrasing or summarizing when needed.

Description The data needed for project 3 is in the project 2 attachment.

Description THIS IS NOT A HARD OR LONG TASK, SO DONT BID IF YOURE GOING TO BID HIGH...there are just a lot of little instructions!!! This can be done in a few hours because it’s simple Developing applications requires much forethought and planning. This project will guide you through the various steps of designing a program that meets a set of requirements. When requirements are understood, software development techniques and tools can be applied to design the objects needed by the program. Once the design has been determined, program logic can be defined. Finally, writing source code can begin. For this assignment, you will need to refer to a set of requirements, design the program, and then create the code. Application Requirements You have been requested to develop a Java application for a large company that provides members and the general public an online product catalog for ordering items like books, DVDs, clothes, household products, and so forth. There are several levels of users, including public (user has not registered), level 1 member, level 2 member, and level 3 member. The level 1 member pays a small monthly subscription fee. Level 2 members are associated with a small business who pays an annual fee covering less than 100 members. Level 3 members are employees of large corporations (more than 100 members) who subscribe annually. As the level increases, so does the discount. The following list highlights these requirements. The requirements for the application are as follows: The application will act as an online ordering system. The company accepts orders online and ships those items to the customer address. Customers must create a line of credit prior to placing an order. Customers view products from the catalog of items. Customers place orders. The administrator updates account information on behalf of members. Administrators add, delete, and modify items in the catalog. The application is able to run under most operating systems, including UNIX and Windows, and has a modern graphical user interface. The application is designed for future growth. Part 1 (55 points) Review the requirements and, using Visio, develop your design by creating use case diagrams, a class diagram, and a sequence diagram. Templates can be found in Visio by accessing the UML System template. There is a use case shape to help you create your use case diagrams. There is a UML sequence shape. Under "More Shapes," you will find an entity relationship shape for your class diagram. Click here to refer to a Visio tutorial to learn Visio basics. Use case diagrams are used to summarize the relationships between use cases, actors, and systems. Use Case 1: Create Account Use Case 2: Place Order Use Case 3: Add Product to Catalog Use Case 4: Update Account Information Sequence diagram that illustrates the various object interactions in their proper sequential order. Class diagrams depict the objects and information structures used by the application. The definition of a class is independent of the application itself. Classes describe the objects managed by the application but are independently defined. Be sure to show relationships between class objects, attributes, data types, and methods in your diagram. Class 1: Account Class 2: Account Level Class 3: Address Class 4: Products Class 5: Order Class 6: Line Item Once you have completed your diagrams, copy them into a Word document that will serve as your application design document. Include explanations for each diagram in your design document. Part 2 (25 points) Create pseudocode that describes the necessary flow of your program with respect to both creating a user account and placing an order. This information should be included in your application design document. This information should be included in your application design document. Part 3 (45 points) Explain your steps regarding taking the business requirements and developing your application design. Provide details as to the importance of following these important steps prior to coding the application. Describe the advantages and disadvantages to this process. Discuss how this process relates to the software development life cycle. Parts 1, 2, & 3 are all included in the application design document.

Description Requirements are on attached document, I would like the python code written in a working manner, so when checked and ran within the program, it actually works.

Description In this program you will replace the linked list from Program 1 with a binary search tree as the basis for your address book. You will also save your address book in a text file.

Description Part 1 You are tasked with writing a new program for your company that keeps track of the customer’s information and his or her current bill. The company wants the name, address, phone number, and balance to be stored for each customer. This program will demonstrate the following: How to use a class to organize data How to use methods to access the data of a class How to create objects from a class Solving the Problem Step 1 The first step in designing a class to organize data is to determine what data you want to store in the class and what methods you want to use to modify the data. You have been given the required data items, but what methods do you want to include? It is common to create accessor methods for each data item in the class. Step 2 The next step is to create the accessor methods of the class. These methods can be used to simply set the values of the data items or even mold how the data look. In the phone number’s accessor method, a specific layout of the number is required to be set, and the balance accessor does not allow a negative balance to be entered. Step 3 The next step is to create a list of customers in the program. A loop is used to add 5 customers. If bad input is entered into the phone or balance, then the program will continue to ask for those data. Step 4 You can now write code to find the customer information for all of the customers or individual customers in the list. Documentation Guidelines: Use good programming style (e.g., indentation for readability) and document each of your program parts with the following items (the items shown between the '<' and '>' angle brackets are only placeholders.  You should replace the placeholders and the comments between them with your specific information).  Your cover sheet should have some of the same information, but what follows should be at the top of each program's sheet of source code.  Some lines of code should have an explanation of what is to be accomplished, this will allow someone supporting your code years later to comprehend your purpose.  Be brief and to the point.  Start your design by writing comment lines of pseudocode.  Once that is complete, begin adding executable lines.  Finally run and test your program. Deliverable(s): Your deliverable should be a Word document with screenshots showing the source code and running results, and discuss the issues that you had for this project related to AWS and/or Python IDE and how you solved them for all of the programs listed above as well as the inputs and outputs from running them. Submit a cover sheet with the hardcopy of your work. Part 2 You work for a dealership that deals in all kinds of vehicles. Cars, Trucks, Boats, and so forth need to be inventoried in the system. The inventory must be detailed so that it could be searched based on number of doors, engine type, color, and so on. This program will demonstrate the following: How to create a base class How to extend a based class to create new classes How to use derived classes Solving the Problem Step 1 The first thing you have to do is decide what attributes and aspects of all vehicle types will be shared. Once this decision is made, a base class can be created to be shared by the child classes later in the program. In this case, the color, horsepower, engine type, and price will be attributes shared by all vehicles. Included is a method that will be shared by all children to set the attributes that are common to them all. Step 2 Given the base class, there are some aspects that need to be included for each vehicle type. Some have doors, and some do not. Some have length that matters, while most do not care. Some might have more or fewer wheels than others. These more specific classes take advantage of the common attributes while adding their own. Step 3 After defining the classes, it is necessary to create objects of each type to add data to them. Although an object of type vehicle can be created, it is so generic that you really could not say what type of vehicle it was. The more specific objects will have the attributes that make them different from the other child classes. Documentation Guidelines: Use good programming style (e.g., indentation for readability) and document each of your program parts with the following items (the items shown between the '<' and '>' angle brackets are only placeholders.  You should replace the placeholders and the comments between them with your specific information).  Your cover sheet should have some of the same information, but what follows should be at the top of each program's sheet of source code.  Some lines of code should have an explanation of what is to be accomplished, this will allow someone supporting your code years later to comprehend your purpose.  Be brief and to the point.  Start your design by writing comment lines of pseudocode.  Once that is complete, begin adding executable lines.  Finally run and test your program. Deliverable(s): Your deliverable should be a Word document with screenshots showing the source code and running results, and discuss the issues that you had for this project related to AWS and/or Python IDE and how you solved them for all of the programs listed above as well as the inputs and outputs from running them. Submit a cover sheet with the hardcopy of your work. part 3 Problem You are writing software for a company’s human resources department. As part of the requirements, it would like to have a function that calculates the salary of an individual based on the position he or she holds, years of service, and hours worked. This program will demonstrate the following: How to create an abstract class, How to overload a method, How to use polymorphism to call functions on similar objects. Solving the Problem Step 1 The first thing that you must determine is what attributes are common to all employees and what methods they can share. Can salary be easily calculated by the same method without some additional input from the user? By using polymorphism, you can make one method that calculates salaries for different groups. First, determine the base class and what method needs to be implemented by the child classes. By making the calcSalary() method abstract, it will be a required method of the child classes. Step 2 You can then define the child classes that inherit the shared attributes from the base Employee class but also inherit the requirement that they implement from the calcSalary() method. Each employee type will have a different set of attributes and a different method of calculating the salary, but the same method call will be used to calculate it. Step 3 You can now create a list to hold all employee types and populate it. Step 4 Because you used polymorphism in the classes, you can now use one loop to calculate and output the salaries of the employees. Documentation Guidelines: Use good programming style (e.g., indentation for readability) and document each of your program parts with the following items (the items shown between the '<' and '>' angle brackets are only placeholders.  You should replace the placeholders and the comments between them with your specific information).  Your cover sheet should have some of the same information, but what follows should be at the top of each program's sheet of source code.  Some lines of code should have an explanation of what is to be accomplished, this will allow someone supporting your code years later to comprehend your purpose.  Be brief and to the point.  Start your design by writing comment lines of pseudocode.  Once that is complete, begin adding executable lines.  Finally run and test your program. Deliverable(s): Your deliverable should be a Word document with screenshots showing the source code and running results, and discuss the issues that you had for this project related to AWS and/or Python IDE and how you solved them for all of the programs listed above as well as the inputs and outputs from running them. Submit a cover sheet with the hardcopy of your work.

Description For guidance on completing the decision matrix, refer to these learning resources: ? Decision Matrix: What It Is and How to Use It: This article defines the decision matrix and discusses how leaders evaluate and prioritize all of their options when considering solutions to a difficult task. ? Decision Matrix Analysis: This article explains how to use a decision matrix analysis, a useful technique for making a choice when many factors must be balanced. Captioned version of this resource can be found here. ? Decision Matrix Example: Use this resource to view an example of a completed decision matrix. Prompt: Remember that you have immersed yourself in the role of an IT professional. Imagine that you work for the small brick-and-mortar business described in the final project case scenario. The owner of your business wants to focus on generating new revenue through e-commerce, but she knows that this change in operations requires the company to integrate new technology. To gain an understanding of what the business might need for technology, she has asked you to create a business systems analysis. In this part of your drafted analysis, you will focus on solutions and recommendations based on your research for your first milestone. Specifically, the following critical elements must be addressed: IV. Technology Solutions: In this section, you will discuss how each of the two technologies meets the technology requirements that you identified in section II. Use your decision matrix to guide your responses. A. Technology One: Explain how well this technology meets the technology requirements of your business. Be sure to address which technology requirements the technology meets, and where there are gaps. B. Technology Two: Explain how well this technology meets the technology requirements of your business. Be sure to address which technology requirements the technology meets, and where there are gaps. V. Recommendations: In this section, you will recommend the technology solution that you believe is most appropriate for your business based on how well each technology meets your business’s technology requirements. A. Recommend a technology solution for your business, and defend why that solution is appropriate. You could recommend only one technology, or you could recommend any combination of the two that you investigated. B. Explain the overall benefit of your recommended technology solution to your business. Consider the following: i. How will it enhance efficiency? ii. How will it position your business for future growth as you move online? Lastly, submit the decision matrix that you used for your research.

Description We have been working on this assignment for the last 3 weeks and I have complete and will provide all the assignments and data sets you will need to complete this assignments. This assignment also has a example report of what it should look like. It should be about 10 pages with citations APA format is required. Assignment 1 was the business problem statement Assignment 2 was my analytics problem statement Assignment 3 is data needs identification and acquisition Week 4 data cleansing is an example report of what the report should look like. Main Assignment... Now that you have identified the business problem, translated it into an analytics problem, identified the data needs, and acquired the data, you will use data that you have found or with the company's permission you can use its data for analysis to resolve the analytics problem. Using one or more of the following software applications (IBM SPSS Modeler, SPSS Statistics, Excel, Tableau, or R), analyze the data so that the findings can be used to address the established business problem in your company. Write a 750-1,000 word paper that includes the following information for your data (ensure that specific screenshots of graphs, tables, etc., are provided): Conduct an exploratory data analysis: What information is contained in the data set? Describe key features of the data and any significant relationships you find. How did you verify that the data was reliable before proceeding? What problems did you find and how did you address them? What relationships did you find in the data? Any missing data? Analyze trends with respect to any appropriate characteristics that you may have discovered. Supplement your description with appropriate charts/figures. Data can be (but are not necessarily limited to) the following: Line graphs Pie charts Bar charts Scatter plots Indicate the steps you have taken to investigate the quality of the data and indicate any variables you have transformed or discarded as a result. Provide a summary that provides a detailed overview of the trends identified based upon the analysis. Segment the data accordingly, if needed, to help describe the data behavior. How are you going to summarize data samples? Provide a detailed statistical summary of all information provided. Provide the raw software files that you used for this assignment. If R was used, provide a *.txt file of all the commands used. Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are required to submit this assignment to LopesWrite. Please refer to the directions in the Student Success Center.

Description A classification technique is a systematic approach to building classification models. Examples include, but are not limited to, decision trees, neural networks, and naïve Bayes and Bayesian approaches. Examine some data in your workplace, or an organization you are familiar with, that is a candidate for classification. Describe the data under consideration. Which classification technique did you select and why? How can your organization benefit from using this classification model?

Description You have to use amazon workspace. I will give you access to it once someone is assigned. For each part Your deliverable should be a Word document with screenshots showing the sample database and table you have created, and discuss the issues that you had for this project related to SQL Server and how you solved them. . It should contain all of these elements: ? a Title page, ? an introductory paragraph that describes the purpose in objective of the assignment, ? brief narrative writing in the body of the paper that describes your processes for creating the database and the table (how did you create these? Code? Management Studio Interface? See “. ? neatly formatted and labeled screenshots that are described in the paper, and references (in-text citations in the body of the paper and the full reference in the reference list. Part 1 You are tasked with creating the database to store information for a university of your choosing. After initial design meetings with your client, the following business rules have been determined (click here for a video instruction to create a database with tables): A student has a name, a birth date, and gender. You must track the date the student started at the university and his or her current GPA, as well as be able to inactivate him or her without deleting information. For advising purposes, store the student's background/bio information. This is like a little story. An advisor has a name and an e-mail address. Students are assigned to one advisor, but one advisor may service multiple students. A class has a class code, name, and description. You need to indicate the specific classes a student is taking/has taken at the university. Track the date the student started a specific class and the grade earned in that class. Each class that a student takes has 4 assignments. Each assignment is worth 100 points. The following entity tables have been composed: Students StudentID int FirstName string LastName string BirthDate date Gender string StartDate date GPA number IsActive boolean Bio string AdvisorID int Advisors AdvisorID int FirstName string LastName string EmailAddr string Classes ClassID int ClassCode string ClassName string Description string Students_Classes StudentClassID int StudentID int ClassID int StartDate date Assignment1 number Assignment2 number Assignment3 number Assignment4 number ClassGPA number Create a database in an SQL server, and translate this design into SQL server tables with appropriate fields. The data types above are general types. An int is an integer whole number. A number is a real number with a decimal point and fractional digits to the right of the decimal point. A string could be a single character, a few characters or even multiple paragraphs of text. Each DBMS may have several specific data types for each general type. The specific data type that you select will depend on the size and range of the values that will be stored in the field. The datatype bit can be used for Boolean fields. In the Students_Classes table, the assignment fields are used to record a grade for each of the 4 assignments in the class. Values range from 0–100. The GPA fields will store values from 0.00–4.00. In the Students table, the gender field will record an M or F. All primary keys should be specified as “identity” or “auto-increment” fields, which means that the database management system will create a unique value for the field, each time a new row is added to the table. By default, the value starts at 1 for the first row added and increments by 1 for each new row inserted. Part2. When inserting the advisors records, separate first and lastname as they are separate fields in the table schema. 1. Insert the following classes' records: Code Name Description ACCT306 Accounting 1 This course introduces accounting concepts and explores the accounting environment. It covers the basic structure of accounting, how to maintain accounts, use account balances to prepare financial statements, and complete the accounting cycle. It also introduces the concept of internal control and how to account for assets. CS362 Structured Query Language for Data Management This course gives complete coverage of SQL, with an emphasis on storage, retrieval, and manipulation of data. ENG115 English Composition In this course, students focus on developing writing skills through practice and revision. Students will examine expository, critical, and persuasive essay techniques. FIN322 Investments This course focuses on investments and investment strategies. Various investment vehicles such as stocks, bonds, and commodities are examined. Students will explore the principles of security analysis and valuation. 2. Insert the following advisors' records: Name Email Fred Stone fred@college.edu Bob Gordon bob@college.edu Jack Simpson jack@college.edu 3. Insert the following students' records: Name Birthdate Gender StartDate GPA IsActive Bio AdvisorID Craig Franklin 1970-03-15 Male 2010-05-30 3.10 Yes 3 Harriet Smith 1982-04-15 Female 2010-05-30 3.22 Yes 1 George David 1984-11-05 Male 2010-10-01 0.00 Yes 3 Ben Jefferson 1976-09-25 Male 2009-02-21 1.80 No The student has gone on temporary leave to pursue other opportunities but plans on returning in 1 year. 3 4. Delete the course named Investments from the system. 5. Change Harriet Smith’s birthdate to April 25, 1982 and her GPA to 3.25. Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Provide an introduction explaining the important of these commands in relation to your overall Key Assignment. Part 3 Provide select statements to satisfy the following data requests: List all active male students assigned to Advisors 1 or 3 (Fred Stone or Jack Simpson). Provide a list of all students without a biography. What classes are in the English department? Create a list of all students and their advisors. Sort by the advisor’s name and then the student’s name. Include the student’s birth date, gender, and GPA. How many students were born in the 1980s? Write a query to show the average GPA by gender. Provide a list of all advisors and the number of active students assigned to each. Filter out any advisors with more than 1 student. Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Part 4 Using the database completed so far, extend the design to accommodate degree programs. The new design should incorporate the following functionalities: A degree has a name and description. What degree is the student working towards? A student can only work on one degree at a time. What classes are necessary to obtain a specific degree? Provide the DDL script to add the tables for the new design changes. Include an updated diagram that shows all the tables in the system. Write the DML script to insert 3 test records in each of the tables in the system. This data will be necessary to write the queries in the next assignment. Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Upload your document to the Submitted Tasks section.