Programming Homework Help

Programming Homework Help. DAT/390 Individual: U.S. 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 re

DAT/390 Individual: U.S. 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.

Submit the ZIP file to the Assignment Files tab.

Hi, So I have already gotten this assignment from you, but I don’t know if the screenshots on the assignment is acceptable to my professor. Is there another  screenshot you could do that displays the SQL Query Results on MYSQL? Sorry in advance, I wasn’t sure how to reach you by email.

Programming Homework Help

Programming Homework Help

Programming Homework Help. Assignment Content The project sponsors of the U.S. Student Aid Data project want you to participate in the project debrief meeting. You are to provide information around the methodology and practices

Assignment Content

  1. The project sponsors of the U.S. Student Aid Data project want you to participate in the project debrief meeting. You are to provide information around the methodology and practices you used to develop the database and the reporting tools used to answer the project questions.

    Refer to the U.S. Student Aid Data assignments you completed throughout this course to prepare your debrief report. Previous assignments may need to be revised with instructor feedback.

    Document the following for the project sponsors:

    • An explanation of the schema selected to develop the database, including:
    • A summary of any schema discrepancies you found and how you resolved them
    • The process and considerations you used to select the best schema for the database
    • The strategy you used to optimize and incorporate best practices into the SQL used to develop the databases, including strengths and weaknesses of the techniques you used
    • The strategy used to transform from one schema to another
    • The challenges encountered while preparing the data for analysis
    • The strategy used to clean the data
    • The tools you selected for integrating various database elements, including the strengths and weaknesses of these tools
    • Screenshots, diagrams, and other images as needed to support your summary
    • Practices you will replicate or avoid in similar projects based on your experiences with this project

    Present your summary as either:

    • A 10- to 12-slide Microsoft® PowerPoint® presentation with detailed speaker notes
    • A 3- to 4-page Microsoft® Word document

    Submit your assignment.

Programming Homework Help

Programming Homework Help

Programming Homework Help. Assignment Content 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 databa

Assignment Content

  1. 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.

Programming Homework Help

Programming Homework Help

Programming Homework Help. Assignment Content This week you will continue your work on the project to evaluate higher education student aid data. You will evaluate your data warehouse data to ensure it can provide consistent, a

Assignment Content

  1. This week you will continue your work on the project to evaluate higher education student aid data. You will evaluate your data warehouse data to ensure it can provide consistent, accurate query data, and provide an update to the project sponsors.

    Define and execute a process to evaluate your data warehouse data for incompleteness, nulls, and the ability to provide consistent query data.

    Create a summary for your project sponsors to inform them of the quality of data they can expect from the new data warehouse.

    Include the following information in your summary:

    • Your data evaluation strategy
    • Specific data evaluation queries
    • Sample results per query
    • Summary of findings

    Document your summary as either:

    • A 10-slide Microsoft® PowerPoint® presentation with detailed speaker notes
    • A 2- to 3-page Microsoft® Word document

    Submit your assignment.

Programming Homework Help

Programming Homework Help

Programming Homework Help. Assignment Content This week you will continue your work on the project to evaluate higher education student aid data. You will transform your operational data structure and schema into a data structu

Assignment Content

  1. This week you will continue your work on the project to evaluate higher education student aid data. You will transform your operational data structure and schema into a data structure and schema for a data warehouse, which will be exclusively used for reporting.

    Develop a plan to integrate this new data warehouse with an Internet application. Include in your plan:

    • A description of the transformation process
    • A schema diagram identifying the changes needed (revise the diagram you submitted for the Week Two Individual Assignment, “U.S. Student Aid Database Schema and Query Recommendations” per your instructor’s feedback)
    • Specific integration plans

    Document your plan as either a:

    • 1- to 3-page Microsoft® Word document
    • 6- to 8-slide Microsoft® PowerPoint® presentation with detailed speaker notes

    Compress your revised diagram and your plan into a ZIP file.

Programming Homework Help

Programming Homework Help

Programming Homework Help. I need help with this C++ Program Please. #1. Instructions Define the class bankAccount to implement the basic properties of a bank account. An object of this class should store the following data: Ac

I need help with this C++ Program Please.

#1. Instructions

Define the class bankAccount to implement the basic properties of a bank account. An object of this class should store the following data: Account holder’s name (string), account number (int), account type (string, checking/saving), balance (double), and interest rate (double). (Store interest rate as a decimal number.) Add appropriate member functions to manipulate an object. Use a static member in the class to automatically assign account numbers. Also, declare an array of 10 components of type bankAccount to process up to 10 customers and write a program to illustrate how to use your class.

Example output is shown below:

1: Enter 1 to add a new customer.                                   

2: Enter 2 for an existing customer.                                

3: Enter 3 to print customers data.                                 

9: Enter 9 to exit the program.                                     

1                                                                    

Enter customer’s name: Dave Brown                                   

Enter account type (checking/savings): checking                     

Enter amount to be deposited to open account: 10000                 

Enter interest rate (as a percent): .01                             

1: Enter 1 to add a new customer.                                   

2: Enter 2 for an existing customer.                                

3: Enter 3 to print customers data.                                  

9: Enter 9 to exit the program.                                     

3                                                                   

Account Holder Name: Dave Brown                                     

Account Type: checking                                               

Account Number: 1100                                                

Balance: $10000.00                                                  

Interest Rate: 0.01%                                                

*****************************                                       

1: Enter 1 to add a new customer.                                   

2: Enter 2 for an existing customer.                                

3: Enter 3 to print customers data.                                  

9: Enter 9 to exit the program.                                     

9

Since your program handles currency, make sure to use a data type that can store decimals with a precision to 2 decimals.

Programming Homework Help

Programming Homework Help

Instructions Create a PowerPoint presentation on three different types of information security certifications. Provide a brief description for each certification and the requirements for each certific

Instructions

Create a PowerPoint presentation on three different types of information security certifications. Provide a brief description for each certification and the requirements for each certification. Also, identify what security role or position is suited for each certification.

The presentation must be in APA style and utilize a minimum of one source from the CSU Online Library. Please use the slide notes function to fully explain your ideas, graphics, and images as needed.

Your completed presentation must be a minimum of seven slides in length, not counting the title and reference slides. All sources must be cited in-text and included on the reference slide in APA style.

Programming Homework Help

I have attached the question, Please find the attachments for the question. For this individual project you will design and build a database for a company, Oopsy Cell repair. The write up for the co

I have attached the question, Please find the attachments for the question.

For this individual project you will design and build a database for a company, Oopsy Cell repair. The write up for the company is provided in the paragraph below. To complete this project, you will bring to bear all that you have learnt in this class. First, you will need to design a database by constructing an ERD. Next, you need to identify all relevant attributes and normalize to complete your database design. Next, you will construct a SQL database with relevant tables, based on your design, and populate it with data (4-5 rows data for each table will be enough). You will then come up with 5 complex query questions (defined as ones involving joins or subqueries) and the sql query code solutions. Your project submission must contain your ERD, a copy of your database diagram, and the five query questions and a snapshot of the output of the five queries. Limit your project document to no more than 4-5 pages, single spaced 12-point font. You are welcome to make reasonable assumptions, but make sure you note them in your project report. Limit your project to no more than 10-12 entities.

 Oopsy Cell Repair (OCR) is a Chicago based company with 9 locations in and around Chicago and its suburbs. Founded in 2012, OCR offers repair services to customers who are facing problems with their cell phones. Reflecting the slogan, “All will be well, with us working on your Cell”, OCR offers various services at a fixed price including screen replacement, battery replacement, data retrieval, data removal, etc. OCR can repair multiple brands of cell phones including Apple, Samsung, Nokia, Google, etc. OCR prides itself in providing upfront and transparent pricing for its services. Each of the nine locations is headed by a location manager along with 4-6 service employees. All service employees are trained to do all repairs, so there is no employee specialization or departmentalization. Further, to create a single contact point for the customer, one employee is in charge of all the repairs to a customer’s phone. OCR is seeking your help to create a database that can capture all relevant information for their business.

Programming Homework Help

Electrocomp’s management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that there should be a minimum number of air conditioners pro

Electrocomp’s management realizes that it forgot to include two critical constraints (see Problem 7-14). In particular, management decides that there should be a minimum number of air conditioners produced Discussion Questions and Problems Note: means the problem may be solved with QM for Windows; means the problem may be solved with Excel; and means the problem may be solved with QM for Windows and/or Excel. M07_REND7659_13_GE_C07.indd 296 30/03/17 1:30 pm DISCUSSION QUESTIONS AND PROBLEMS 297 in order to fulfill a contract. Also, due to an oversupply of fans in the preceding period, a limit should be placed on the total number of fans produced. (a) If Electrocomp decides that at least 20 air conditioners should be produced but no more than 80 fans should be produced, what would be the optimal solution? How much slack or surplus is there for each of the four constraints? (b) If Electrocomp decides that at least 30 air conditioners should be produced but no more than 50 fans should be produced, what would be the optimal solution? How much slack or surplus is there for each of the four constraints at the optimal solution?

Programming Homework Help

Normal 0 false false false EN-US JA AR-SA /* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-s

Normal 0 false false false EN-US JA AR-SA /* Style Definitions */ table.MsoNormalTable {mso-style-name:”Table Normal”; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:””; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:”Cambria”,serif; mso-ascii-font-family:Cambria; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Cambria; mso-hansi-theme-font:minor-latin;}

1.    Use INSTR to find the position of character ‘a’ in the doctor’s name.

2.    CONCAT the patients’ first and last name and display their DOB in the following format ‘DD, Month YYYY’. Sort the patients’ name alphabetically.

PATNAME

NEWDOB

Allen Mcginnis

3, May 1959

Anthony Rogers

7, December 2041

Becky Roach

8, September 1975

Brian Anderson

6, March 2048

Chasity Wright

23, April 1973

Debbie Saillez

9, September 1955

J.C. Jones

17, July 2002

Jason Smith

12, December 1999

Jennifer Poole

13, May 2002

Joe Sakic

16, September 1976

John Cochran

3, March 2048

John Jackson

14, October 2043

Keith Vanderchuck

8, August 1968

Lewis Crow

16, October 2049

Linda Davis

17, July 2002

Lynn Westra

12, July 1957

Paul Kowalczyk

12, November 1951

Paul James

14, March 1997

Ryan Baily

25, December 1977

Scott James

1, March 2033

Stephanie Walters

1, January 2045

Susan Porter

14, November 1967

3.    Write a query to display the doc_name and area as follows. Sort the result according to the doctors’ name.

PADDING

Borque_____Neurology

Cotner_____Neurology

Harrison__Pediatrics

James______Neurology

James_____Orthopedic

Lewis_____Pediatrics

Pronger________Rehab

Robertson_Orthopedic

Smith_____Family Pra

Stevenson___Director

Thompson_______Rehab

Vester____Pediatrics

4.    Display the patients’ new appointment date 3 months from the next appointment date.

PAT_NAME

NEXTAPPTDATE

NEW_APPT

James

01-JUL-03

01-OCT-03

Anderson

01-JUL-03

01-OCT-03

James

20-JUL-03

20-OCT-03

Smith

15-NOV-03

15-FEB-04

Porter

01-OCT-03

01-JAN-04

Saillez

01-JUL-03

01-OCT-03

Rogers

01-NOV-03

01-FEB-04

Walters

12-DEC-03

12-MAR-04

Westra

02-FEB-04

02-MAY-04

Poole

01-DEC-03

01-MAR-04

Baily

06-JUN-05

06-SEP-05

Crow

01-JUL-05

01-OCT-05

Cochran

02-DEC-05

02-MAR-06

Roach

01-DEC-05

01-MAR-06

Jackson

21-JUL-03

21-OCT-03

Kowalczyk

29-JUL-03

29-OCT-03

Davis

21-JUL-03

21-OCT-03

Jones

21-JUL-03

21-OCT-03

Wright

Vanderchuck

Mcginnis

Sakic

5.    The hospital has decided for each year the doctor has worked, he/she will be given an extra RM1000. Write a query that will calculate the bonus for each doctor according to this requirement. Note: Use Nesting Functions

DATEHIRED

SALPERMON

NOOFYR

NEW_BONUS

05-DEC-94

12000

26

38000

09-JAN-00

8100

21

29100

21-JAN-96

10000

25

35000

16-JUN-98

11500

23

34500

22-JUN-98

4550

23

27550

01-AUG-98

7950

23

30950

02-MAY-95

9800

26

35800

02-MAR-95

10500

26

36500

18-MAR-97

6500

24

30500

18-DEC-99

3500

21

24500

30-JUN-89

16500

32

48500

30-JUN-79

23500

42

65500