Week2-US Student Aid Database Schema And Query Recommendations

 

This week you will continue your work on the project to evaluate higher education student aid data. You will test your recommended U.S. Student Aid database schema, build the database, and develop the business intelligence queries that will enable you to answer the following project questions:

  • Which schools generate the highest amount of debt for the average student who attends?
  • What is the employment rate for the students who graduate from this school?

Revise the schema you submitted in the Week One Individual Assignment, “U.S. Student Aid Initial Database Schema” per your instructor’s feedback.

Test your schema by completing the following tasks:

  • Define the database tables you will need and group the tables by function. Document your tables in an annotated Microsoft® Visio® diagram.
  • Develop the SQL queries needed and populate the tables from the data downloaded during the Week One Individual Assignment, “U.S. Student Aid Database Initial Database Schema.”
  • Define an appropriate strategy to optimize and incorporate best practices in to the SQL that you created.
  • Document your SQL and metadata in Microsoft® Visio® or Microsoft® Excel®.
  • Capture screenshots of each query result.

Document your results as a 4- to 5- slide Microsoft® PowerPoint® presentation or a 1-page Microsoft®Word document that:

  • Describes your SQL, populated tables, and the best practices you used to develop your SQL queries
  • Includes the SQL statements and corresponding screenshots of each query result

Note: The final Week Five Individual Assignment, “U.S. Student Data Debrief” requires a project summary and debrief that builds on this and subsequent Individual Assignments. Therefore, it is recommended that you select the delivery method of a Microsoft® PowerPoint® presentation or a Microsoft® Word document you will want to use consistently throughout these assignments.

Compress your revised diagram(s), testing results documentation and SQL files into a ZIP file.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

2 Discussions, 1 Case Study

Please go through and follow the instructions document before providing answers.

2 discussion questions with 2 responses each(i.e. 4 responses in total). and 1 case study.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Java

Please note I only need the driver.java class ScenarioGlobal Rain logo

You work for Global Rain, a software engineering company that specializes in custom software design and development. As a junior software developer, you are part of a software development team at Global Rain that collaborates to create software solutions for entrepreneurs, businesses, and government agencies around the world.

You have been newly assigned to a development team at Global Rain that is currently working on a project for an innovative international rescue animal training company, Grazioso Salvare. Grazioso Salvare is seeking a software application that will help track rescue animals, sometimes referred to as search and rescue animals, which are obtained and trained by the company to rescue humans or other animals from difficult (or even life-threatening) situations.

A portion of this work has already taken place on this project. Your team lead has assigned you to create one new class and modify the existing classes in the software application. You will deliver these class files to the team lead, who will consolidate them with the work from other team members and present the application to your client.

Directions

Grazioso Salvare has provided you with a specification document detailing its software needs. Other members of the Global Rain development team have started creating the RescueAnimal.java, Dog.java, and Driver.java class files. Your team lead has asked you to modify the existing classes and create a Monkey.java class as your contribution to the team.

Three individuals gathered around a computer

  1. To gain a clear understanding of the client’s software requirements, review the Grazioso Salvare specification document in the Supporting Materials section. As you read, pay close attention to the attributes and methods that you will need to implement into the program.
  2. Open the Virtual Lab by clicking on the link in the Virtual Lab Access module. Then open your IDE. Follow the IDE tutorial in the Supporting Materials section to upload Grazioso.zip into your IDE. This zipped folder contains three class files. Once you upload the files, compile the code. Although the program is not complete, it will compile without error.
  3. Read through the code for each class. This will help you understand what code has been created and what code must be modified or created to meet the software requirements.
  4. Before you begin modifying and creating classes, your team lead reminds you to demonstrate industry standard best practices in all your code to ensure clarity, consistency, and efficiency among all software developers working on the program. This includes ensuring the following:
    • In-line comments denote your changes and briefly describe the functionality of each method or element of the class
    • Appropriate variable and method naming conventions are used throughout your code
  5. Once you have completed your pre-work, you are ready to begin your assigned tasks. To start, modify the RescueAnimal.java class file by adding accessor and mutator methods for each instance variable.
  6. Create the Monkey class, using the specification document as a guide. The Monkey class must do the following:
    • Inherit from the RescueAnimal class
    • Implement all attributes with appropriate data structures
    • Include accessors and mutators for all implemented attributes
  7. Select a method from the Software Requirements section of Grazioso Salvare’s specification document. Using the selected method, modify the Driver.java class file to do the following:
    • Implement the method you have chosen
    • Add attributes, as needed, to support the required functionality

What to Submit

To complete this project, you must submit the following:

RescueAnimal.java Class File
Modify the RescueAnimal.java class file in accordance with the requirements of the specification document. Be sure to include in-line comments that explicitly identify the changes you made as well as describe the functionality of the code.

Monkey.java Class File
Create a Monkey.java class file that meets the requirements laid out in the specification document. Be sure to include in-line comments that explicitly identify the changes you made as well as describe the functionality of the code.

Driver.java Class File
Modify the Driver.java class file in accordance with the requirements of the specification document. Be sure to include in-line comments that explicitly identify the changes you made as well as describe the functionality of the code.

Dog.java Class File
Submit the Dog.java class file, even though you were not required to make changes to it for this project.

Supporting Materials

The following resource(s) may help support your work on the project:

Grazioso Salvare Specification Document
Review the specification document provided by the Grazioso Salvare client to learn about its software requirements and perform your development work.

Grazioso.zip (Eclipse Project File)
This zipped folder contains the RescueAnimal.java, Dog.java, and Driver.java class files. The RescueAnimal.java class contains the instance variables and a default constructor. In-line comments are provided to indicate where the accessor and mutator methods should be implemented. The Dog.java class contains an instance variable, a constructor, an accessor method, and a mutator method. You will use this class as part of the application. No changes are required in the Dog.java class. The Driver class will be used to run the application. It contains an empty main() method with in-line comments indicating where new functionality should be implemented.

Uploading Files to Eclipse Tutorial
You will write, test, and run each class file in an IDE. Review this tutorial to learn how to upload the Eclipse Project file (.jar), which contains all your class files, into your IDE.

Downloading Files From Eclipse Tutorial
You will write, test, and run your class files using an integrated development environment (IDE). Review this tutorial to learn how to save and export files from your IDE. Important: Do not change the names of any class files.The following rubric will be used to assess Project Two. Familiarize yourself with this document as you work on the project, and return to this rubric before you submit Project Two to make sure you’ve included everything you need to be successful.     

The following rubric will be used to assess Project Two. Familiarize yourself with this document as you work on the project, and return to this rubric before you submit Project Two to make sure you’ve included everything you need to be successful.  

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

DA Case Study 1

 Have to answer the questions using the excel data file.

I’m attaching excel data file(Data – Case – Week – 1 – PelicanStores).

have to answer all questions below.

========Question:

Pelican Stores, a division of National Clothing, is a chain of women’s apparel stores operating throughout the country. The chain recently ran a promotion in which discount coupons were sent to customers of other National Clothing stores.

Data collected for a sample of 100 in-store credit card transactions at Pelican Stores for one day while the promotion was running are contained in the file PelicanStores.

Table shows a portion of the data set (USE DATA AS POSTED). The Proprietary Card method of payment refers to charges made using a National Clothing charge card.

Customers who made a purchase using a discount coupon are referred to as promotional customers, and customers who made a purchase but did not use a discount coupon are referred to as regular customers.

Because the promotional coupons were not sent to regular Pelican Stores customers, management considers the sales made to people presenting the promotional coupons as sales it would not otherwise make.

Of course, Pelican also hopes that the promotional customers will continue to shop at its stores.

Most of the variables shown in data attached are self-explanatory, but two of the variables require some clarification.

Items          The total number of items purchased

Net Sales    The total amount ($) charged to the credit card

Pelican’s management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.

Write – Managerial Report – APA style

Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. At a minimum, your report should include the following:

1. Percent frequency distribution for key variables.

2. A bar chart or pie chart showing the number of customer purchases attributable to the method of payment.

3. A crosstabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities or differences present.

4. A scatter diagram to explore the relationship between net sales and customer age.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Cloud Computing Reflective Paper

 Quetion No 1:

Reflective Paper :

Provide a reflection of at least 500 words (2 pages double spaced excluding Title and Reference pages) that summarizes what you feel are the most important or interesting concepts you have learned so far in this Cloud Computing course.  Would be good to include an insight as to whether the learning was new to you or reinforced knowledge that you already had.

Requirements:  Provide a 500-word (2 or more pages double spaced not counting the title and reference pages) paper.  The paper should include a title page, body pages, and reference page.  An abstract and introduction is not required for this assignment.  Correct use of APA guidelines for sources and citations is required. If supporting evidence from outside resources is used those must be properly cited.

Question 2: 

 

 Practical Connection Paper :

Develop a paper describing how the knowledge, skills, or theories of this course have been applied or could be applied, in a practical manner to your current work environment. If you are not currently working, share how you could leverage the knowledge gained working as an IT consultant working for an organization of your choice.

Requirements:  Provide a 500-word (2 or more pages double spaced not counting the title and reference pages) paper.  The paper should include a title page, body pages, and reference page.  An abstract and introduction is not required for this assignment.  Correct use of APA guidelines for sources and citations is required. If supporting evidence from outside resources is used those must be properly cited.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Software Engineering

Hi, I have a 5 questions homework to be answered. Any help please?

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Wk 5 – Apply: Webstore Implementation and Maintenance Plan

Pine Valley Furniture’s board of directors is ready to review how to implement and maintain the new webstore system.

Write a 6- to 8-page implementation and maintenance plan for the new webstore. Include the following:

Recommend an installation strategy for PVF’s student furniture webstore. Justify your recommendation by stating the advantages and disadvantages as compared to the other three installation strategies.

Outline the documentation that you would suggest being created to document the system, train, and support users.

Outline the testing plan for the system. Include brief descriptions of the activities for each element of your testing plan.

Summarize the maintenance needs of the PVF webstore, including alternative organizational structures, quality measurement, processes for handling change requests, and configuration management.

Cite any references according to APA guidelines.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Discussion on Improving Database.

Introduction— 

Question- Search Engines are monster sized databases. They are not normalized by any means or are they? Explain how you believe a company such as Google or Microsoft can improve their search technology by starting with improving their database.  

References. Minimum 2 or more. 

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

700words discussion: If you have you been involved with a company doing a redesign of business processes, discuss what went right during the redesign and what went wrong from your perspective.

700words discussion: If you have you been involved with a company doing a redesign of business processes, discuss what went right during the redesign and what went wrong from your perspective. Additionally, provide a discussion on what could have been done better to minimize the risk of failure. If you have not yet been involved with a business process redesign, research a company that has recently completed one and discuss what went wrong, what went right, and how the company could have done a better job minimizing the risk of failure.

1.Googel-scholor references

2.In-Text citation

3. APA format

4. Conclusion at the end of discussion

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Explain the advantages of using Layers of Protection Analysis (LOPA).

Explain the advantages of using Layers of Protection Analysis (LOPA). What are the potential disadvantages? What would you say to a co-worker or supervisor who complains that LOPA is unnecessary because different organizations/industries already have risk management analysis methods?

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now