Review the tables created (JOB, EMPLOYEE, PROJECT, ASSIGNMENT) by the SQL statement. Create an ERD Diagram for the database tables showing the relationships between the tables. Be

Execute the code contained within the “Ch07_ConstructCo_MySQL.txt” file attached.

  1. Review the tables created (JOB, EMPLOYEE, PROJECT, ASSIGNMENT) by the SQL statement. Create an ERD Diagram for the database tables showing the relationships between the tables. Be sure to identify any primary or foreign keys (40 points)
  2. Write SQL statements to return the following (All queries requesting a count, sum, or list must return unique records):
    1. Produce the first and last names of employees and number of years employed sorted by the highest number of years employed (EMP_HIREDATE) to the lowest. (10 points)
    2. Count the number of employees hired after January 1, 1996 (EMP_HIREDATE). (10 points)
    3. Return the Employee ID, First Name, Last Name, Job Description, and the sum of assignment hours (ASSIGN_HOURS) for employees that have more than 1 assignment in the assignment table. (10 points)
    4. For each project, return the project name and Job Descriptions of the employees that worked on them. (10 points)

Include SQL statements you used as well as returned results of statements. Submit your assignment as a Word or PDF document.

  • https://www.studypool.com/questions/download?id=2806338&path=uploads/questions/7365623/20230412184548data_week_5.txt&fileDownloadName=attachment_1

Do you feel that you have the resilience required to operate effectively as a change manager? And Why? If necessary, what steps can you take to maintain and to strengthen your resilience?

Week 7 discussion

Do you feel that you have the resilience required to operate effectively as a change manager? And Why? If necessary, what steps can you take to maintain and to strengthen your resilience?

How did the Cold War impact the United States and the Soviet Union? How did it affect the rest of the world?

Cold War

How did the Cold War impact the United States and the Soviet Union? How did it affect the rest of the world?

Fully describe the overall concepts of homeland security and homeland defense. Construct a response that fully provides the following related to these two broad-based initiatives.

 National Security Strategy

Fully describe the overall concepts of homeland security and homeland defense. Construct a response that fully provides the following related to these two broad-based initiatives:

Primary missions, tasks, responsibilities, operations, etc. for homeland security and defense.
Highlight those areas that are shared and common interests between the two (joint endeavors between HLS and HLD?)
Lastly, recommend your won definition for homeland security.

Adhering to the overarching theme and approach of the current National Security Strategy, provide your own recommendations regarding how the top threat you identified in this week’s discussion should be addressed moving forward. Offer specifics as to how key elements of your proposal would be approached and implemented in accordance with Ends, Ways, and Means strategy framework.

Choose a problem that lends to an implementation that uses dynamic programming. Clearly state the problem and then provide high-level pseudocode for the algorithm. Explain why this algorithm can benefit from dynamic programming.

Algorithms & Data Structures Question

Choose a problem that lends to an implementation that uses dynamic programming. Clearly state the problem and then provide high-level pseudocode for the algorithm. Explain why this algorithm can benefit from dynamic programming.

Explain 3 brand expressions you create for your company. Describe the options you will use to create your brand expressions. Include ways in which you will maintain ethical standards.

Entrepreneurship Question

Think of a new business you are contemplating creating or already own. Answer the following in 600 to 750 words:

  • List 3 names that might work for the company.
  • Explain 3 brand expressions you create for your company.
  • Describe the options you will use to create your brand expressions. Include ways in which you will maintain ethical standards.
  • Summarize 3 features and 3 benefits of the product or service that you would introduce.
  • Create a first draft of the product story you could use for the product or service you would introduce. Include the key features and benefits your product would provide that are superior to those of your competitors’ products, as well as how you would maintain ethical standards within the industry.

Write a re ection of about 1-2 paragraphs about your experience with this project. It should include, but is not limited to: What did you learn? What did you like or dislike about this project? What would you change?

Project 1 math

Purpose of Assignment

We have completed our study of basic sinusoids. We can use our knowledge to apply it to the real world around us. We should understand that any variable that is cyclical, harmonic, oscillating, or periodic in nature can be modeled by a sine or cosine wave. In this project, you will investigate any real-world phenomenon and create a presentation about it, using any reasonable presentation method. You will also write a short re ection.

This project aligns with Course Objectives D (graphs of trig functions) and E (modeling and interpreting cyclic-in-nature applications), as well as GELO 5.

You will have two opportunities to get the maximum possible grade if you submit a copy by the First-Version-Due deadline, as listed in Canvas.

Task

Complete the tasks below.

You may work either individually or with a partner (i.e. have one or two authors).

  1. Choose ONE real-world phenomenon which can be modeled by a sinusoid. These include, but are not limited to:
    • Ferris wheels and roller coasters
    • Wheels, trampolines, swings
  2. Research and collect data:
    • Collect data from a reputable external source. You may NOT directly use the textbook as a reference for this purpose.
    • The data must be paired (e.g. (x,y)).
    • You must cite the source of your data, and you should collect at least 20 data points
  3. Construct a predictive model of the form y = Asin(ωx φ) + B, using both the Quick-Fit and

Best-Fit techniques that we learnt in class

  • Give highlights in the presentation about how it is done in each case
  1. Show a graph of the predictive models on the same graph as the scatterplot of your data
    • The graph should be produced in either GeoGebra or Desmos
    • Compare the scatterplot to the models
    • Prepare to compare the models to each other
  2. Construct a presentation, such as on PowerPoint, Prezi, iMovie, etc. that includes (but is not limited to) each of the following:
    • A title slide with your name (and partner’s name if applicable).
    • At least one Intro slide which introduces the context in broad terms: no data should be present on this slide
    • Slides that address Tasks 1 through 4 (see Rubric on Canvas for more details)
    • A Conclusion slide with a comparison of the two models and a brief re ection on the comparison
    • A References slide that cites at least one source used (in AMS, APA, or MLA format; the former two preferred), excluding class notes
    • An Acknowledgments slide that mentions the names of all humans (including Dr. Weiss) consulted in the completion of this project
  1. If you consulted nobody, the Acknowledgments section is still required: you will state “I consulted with no other person on this project.”
  1. On a separate Word document, write a re ection of about 1-2 paragraphs about your experience with this project. It should include, but is not limited to:
    • What did you learn?
    • What did you like or dislike about this project?
    • What would you change?

Become familiar with Xcode software and building projects from scratch using Swift and UIKit. Learn how to navigate between different screens. Build UIs that look consistent on different screen size.

Introduction to Xcode and iOS Fundamentals (Swift)

OVERVIEW

We will begin by exploring the UIKit and how UIs are made using this framework. We’ll explore working with common elements(buttons, labels, textfields, etc.), autolayout, and navigation.

LEARNING OBJECTIVES

  • Become familiar with Xcode software and building projects from scratch using Swift and UIKit.
  • Learn how to navigate between different screens.
  • Build UIs that look consistent on different screen size.

Choose 2 positions that you hold within the social structure (ex: race/ethnicity, social class, gender, religion, etc.) and discuss how these positions influence your experiences within 2 of the social institutions we have covered in class.

Social Science Question

For this paper you will reflect on the interrelationship between your location in the social structure and your experiences with social institutions. Additionally, you will consider how these interrelationships matter for your future. Choose 2 positions that you hold within the social structure (ex: race/ethnicity, social class, gender, religion, etc.) and discuss how these positions influence your experiences within 2 of the social institutions we have covered in class. Finally, offer a thoughtful reflection on how these intersections may shape your future in regards to one or both of the following: social/economic mobility, marriage & family. Please see the rubric below for more detailed information on each of these components.

What are the issues? What are the techniques/approaches used until now to attack the problems identified in part (1)?

Machine Learning Question

Then you write your term project by focusing on:

(1) What are the issues?

(2) What are the techniques/approaches used until now to attack the problems identified in part (1)?

(3) Your critics of the current approaches (or shortcomings of the current solutions).

(4) Summary and conclusions. You need to include possible future work in this area.