MySQL Query Computer Science Assignment Help

MySQL Query Computer Science Assignment Help. MySQL Query Computer Science Assignment Help.


(/0x4*br />

  1. After logging on to MySQL, set the default database (type USE your_user_name; command at the mysql> prompt) and engine (type SET storage_engine=InnoDB; command at the mysql> prompt).
  2. For each of the assigned problems, write a SQL query to retrieve the required information and test the query in MySQL. Once the query is successfully executed, type your first name and last name at the next mysql> prompt and take a screen shot (press ALT+PRINT SCREEN by holding down the ALT key and then pressing the PRINT SCREEN key). Paste the screen shot in the appropriate location in your MS Word file.
  3. Save the file on your disk and submit it through the Homework Assignment 8 Submission link.

QUESTION 1

Henry Books Database: Problem 14 (p.126)

QUESTION 2

Alexamara Marina Group Database: Problem 1 (p.127)

QUESTION 3

Henry Books Database: Problem 2 (p.126)

QUESTION 4

Henry Books Database: Problem 21 (p.126)

QUESTION 5

Alexamara Marina Group Database: Problem 2 (p.127)

QUESTION 6

Premiere Products Database: Problem 11 (p.125)

QUESTION 7

Henry Books Database: Problem 5 (p.126)

QUESTION 8

Alexamara Marina Group Database: Problem 5 (p.127)

QUESTION 9

Premiere Products Database: Problem 12 (p.125)

select * from Part order by Description;

QUESTION 10

Henry Books Database: Problem 18 (p.126)

QUESTION 11

Premiere Products Database: Problem 3 (p.125)

QUESTION 12

Henry Books Database: Problem 12 (p.126)

QUESTION 13

Premiere Products Database: Problem 2 (p.125)

QUESTION 14

Premiere Products Database: Problem 15 (p.125)

QUESTION 15

Henry Books Database: Problem 10 (p.126)

QUESTION 16

Premiere Products Database: Problem 20 (p.125)

QUESTION 17

Alexamara Marina Group Database: Problem 6 (p.127)

QUESTION 18

Premiere Products Database: Problem 6 (p.125)

QUESTION 19

Premiere Products Database: Problem 18 (p.125)

QUESTION 20

Premiere Products Database: Problem 14 (p.125)

Notes: Attached is the chapter 4 problems from the book that will be needed to answer the questions.

MySQL Query Computer Science Assignment Help[supanova_question]

critical analytical summary Humanities Assignment Help

Instructions: the following are countries where you will get your articles about:

Write a 1/5 to 2-page summary about a current event in one of the following places: Cameroon, Burkina-Faso, Gambia, Chile, Uruguay, Guatemala, Sri Lanka, Syria, Libya, Eritrea, Somalia, Japan, Thailand, Australia, Philippines, Vietnam, Ethiopia, India

Do not get any articles from any event in the United States.

Articles must be dated no earlier than August 1, 2018

Remember that this is a current event summary and not a book report!!You are expected to read your article thoroughly and give strong critical analysis of its content which should mainly focus on the relationship between your article (subject) and one of the various sagacious themes from Notes on World History (will be attach later)

I will add more details once you get started

[supanova_question]

Business Report Presentations With Findings And Recomendations Business Finance Assignment Help

The first of objective of this week’s deliverable is to provide Robert M. Lopez with a business report presentation of your findings.

Use the modified spreadsheet that you submitted in Module 04 for this deliverable.
Your report should visually identify:

  • Outliers
  • Sales consultants trending towards noncompliance

Using the Excel spreadsheet as input, create a visual representation of the data. Use the visual representation of the data in a 2 slide PowerPoint of your findings.

The second objective of this week’s deliverable is to provide Robert M. Lopez with an executive summary of your findings.

In a 2 page paper, APA formatted with references and citations, summarize your findings. Give proof for your analysis. Within your paper, explain the process you did to come up with the findings. Based on the findings, provide business recommendations to Mr. Lopez.

[supanova_question]

Chapter 5 MySQL Assignment Computer Science Assignment Help

Instructions for Homework Assignment 9

  1. After logging on to my MySQL, set the default database (type USE your_user_name; command at the mysql> prompt) and engine (type SET storage_engine=InnoDB; command at the mysql> prompt).
  2. If you did not run scripts creating the Premiere Products, Henry Books, and Alexamara Marina Group databases, you need to run the scripts. Follow the instructions given in the Guide to MySQL: PowerPoint Presentation for Chapter 4 available on Blackboard.
  3. For each of the assigned problems, write a SQL query to retrieve the required information and test the query in MySQL. Once the query is successfully executed, type your first name and last name at the next mysql> prompt and take a screen shot (press ALT+PRINT SCREEN by holding down the ALT key and then pressing the PRINT SCREEN key). Paste the screen shot in the appropriate location in your MS Word file. Make sure the query, the confirmation messages (if any), and the results (if any) are included in your screen shot.
  4. Save the file on your disk and submit it through the Homework Assignment 9 Submission link.

QUESTION 1

  • Henry Books Database: Problem 1 (p. 159)

QUESTION 2

  • Alexamara Marina Group Database: Problem 9 (p. 160)

QUESTION 3

  • Henry Books Database: Problem 4 (p. 159)

QUESTION 4

  • Premiere Products Database: Problem 11 (p. 158)

QUESTION 5

  • Alexamara Marina Group Database: Problem 4 (p. 160)

QUESTION 6

  • Henry Books Database: Problem 8 (p. 159)

QUESTION 7

  • Alexamara Marina Group Database: Problem 8 (p. 160)

QUESTION 8

  • Alexamara Marina Group Database: Problem 3 (p. 160)

QUESTION 9

  • Premiere Products Database: Problem 14 (p. 158)

QUESTION 10

  • Premiere Products Database: Problem 13 (p. 158)

QUESTION 11

  • Alexamara Marina Group Database: Problem 11 (p. 160)

QUESTION 12

  • Henry Books Database: Problem 6 (p. 159)

QUESTION 13

  • Premiere Products Database: Problem 16 (p. 158)

QUESTION 14

  • Henry Books Database: Problem 2 (p. 159)

QUESTION 15

  • Alexamara Marina Group Database: Problem 15 (p. 160)

QUESTION 16

  • Henry Books Database: Problem 17 (p. 159)

QUESTION 17

  • Henry Books Database: Problem 13 (p. 159)

QUESTION 18

  • Alexamara Marina Group Database: Problem 14 (p. 160)

QUESTION 19

  • Henry Books Database: Problem 14 (p. 159)

QUESTION 20

  • Premiere Products Database: Problem 17 (p. 158)

Notes: Attached is the problems for chapter 5 that is needed to answer the questions above.

[supanova_question]

Three key aspects of a team Writing Assignment Help

Part 1: The three (3) Key aspects of a Team

As a group, identify the three (3) key aspects of a team. What are their characteristics? As a group, which of the teams do you mostly identify with and why? Support your presentation with appropriate references. Use APA format throughout.

Part 2: Rewarding Team Work:

  • Develop power point presentation on how to reward team work. As a team, why is it important to reward term work?
  • Develop power points. You power points should contain a minimum of 20 slides (excluding the cover page and reference page
  • Use APA format throughout.Include appropriate references at least 1 academically reviewed journal articles per slide.

[supanova_question]

[supanova_question]

ITN 170 LInux system Administration Computer Science Assignment Help

ITN 170 Project 3

Insert a usb drive into a port readable by your copy of Linux. Using fdisk, delete any partitions on the

drive and create two new ones. Then format both of the partitions to ext4.

Next, configure your machine to boot into CLI mode (command line interface as opposed to GUI) or

simply shut the GUI interface (X-Windows) down while it’s running. Then, working from the

command line, mount the usb disk you just formatted. Verify that the disk is properly mounted by

writing to it.

Write down the steps you took, and submit them here along with a screenshot of the mounted disk

showing the file you wrote to it and a listing of the disks partitions.

ITN 170 LInux system Administration Computer Science Assignment Help[supanova_question]

Network and big data Writing Assignment Help

A 3-5 page APA original document describing the Network and your management of Big Data, which you will use in your (imaginary) Data Analytics company.

The choices you made beforehand for Cloud and Customer (Assignments 1-3) will now dictate the complications you might have establishing a network and managing vast amounts of data.

A 3-5 page APA original document describing your Information Security and DR approach. This will include your assessment of the value of your data and analytics, and will explain how your approach to security and to DR matches the value of your data.

[supanova_question]

Comparative Politics Writing Assignment Help

1. compared to states in this case (Venezuela and Colombia) and their respective approaches to a contemporary issue of governance or a political problem.

-you can compare their health system, immigration system, the government system

2. Be sure to discuss at least one current political issue that the two nations are trying to deal with. ” you can compare and talk about the situation with the Farc or guerrilla that both countries are trying to deal with.” ”

3.This paper requires a bibliography of at least five sources. They should include at least one academic source. You should cite appropriately and consistently ( MLA )

[supanova_question]

INT 700 Milestone Four: 10-2 Final Project Report: Final Global Strategic Analysis Assignment Help

INT 700 Milestone Four: 10-2 Final Project Report: Final Global Strategic Analysis (ONLY THE LAST PART OF THE RUBRIC IN YELLOW )

Submit your final report on the strategic evaluation and recommendations for the internationalization of your selected firm.

For additional details, please refer to the Final Project Guidelines and Rubric document.

My company is H&M (Hennes & Mauritz) is a Swedish is a multinational company for clothing and retail. It has a well-developed brand name for the provision of a variety of clothing for men, women, teenagers, and children (Aboulian, 2008). The company has associate companies in 52 countries with over 4500 stores and has employed more than 171,000 people. It started in 1947 as a single store that sold exceptionally women’s clothing and is now a global fashion and design group.The company has shared values across all the 171,000 employees across the world.

[supanova_question]

Project management Business Finance Assignment Help

Scope Management

All projects are about producing something—either a product or a service or a result. To produce the product, you must do work. The Project Management Institute (PMI) has defined project scope as the work that must be done to deliver the product of the project with the required features and functionality. Project scope management is about defining the work of the project and then, maintaining control of the work in the project. Project scope management includes the processes required to ensure that the project consists of only the work required to deliver the product of the project. It also includes controlling what is and what is not included in the project (PMI, 2008).

According to the fourth edition of PMBOK® Guide, project scope management consists of the following five processes:

  • Gather requirements.
  • Define scope.
  • Create a work breakdown structure (WBS).
  • Verify scope.
  • Control scope.

Since Ashley’s project is in its initial stage, you will focus on the first three processes this week and the last two processes in the later weeks.

Ashley’s project is in its nascent stage, where she has to plan meticulously to be able to hold this project in a better shape. You will now see how Ashley is progressing.

She has completed an initial, high-level communications plan for the project. She has set up meetings with important stakeholders whom she wants to interview. Ashley has also started filling out the project charter, even though she doesn’t have the complete details at this stage.

Ashley checks Jim’s schedule and realizes that she has just two weeks more before he arrives. She has too much to achieve within this time, which, she knows, will not be possible to accomplish alone.

Ashley decides to review the nine project management knowledge areas—particularly, scope management, quality management, and integration management—before her meeting with Mac. Ashley pulls out the Swedberg Project Plan to review the details of the knowledge areas.

She still has to collect requirements, but she wants to be ahead of the curve and be ready for the next steps. Although there are nine knowledge areas, the four knowledge areas of project scope management, time management, cost management and quality management are closely linked. Simply put, if you change the project scope, you must change at least one of the other three areas. If you increase the scope of the project (you want more features) and want to hold the quality constant (you want a good product), it will either take more money or more time or both to finish the project.

While this is a simple and obvious truth, it is often ignored. A project manager should review these relationships and carefully consider the impact of changing any of the parameters of a project.


Gathering Requirements

It is important to understand the relationship between requirements and scope for controlling and managing the work in the project. Requirements are the needed traits of the product, service, or result being produced by the project. These traits include:

  • Functions and features
  • Reliability
  • Ease of maintenance
  • Ease of use

Gathering requirements from stakeholders is critical since accurate requirements definition is the foundation for developing the final product scope. Product scope is the foundation for project scope—the work of the project.

Frequently, the requirements for a project’s product are not accurately identified. Sometimes, even when the requirements are identified, the project suffers because the process is incomplete or requirements change. Therefore, it is critical that the requirements are stabilized early in the lifecycle of a project. Without requirements stability, changes in scope continue (Turtle, 1994).

Poor requirements definition will result in complete misalignment of the real need for the product or service, the customer’s desire, and the project outcome.
To gather requirements, first analyze the project charter to create a list of stakeholders or a “stakeholder register.” While customers and users are the primary stakeholders, do not ignore other stakeholders such as the project sponsor.
Like Ashley, you can use interviews, meetings, focus groups, facilitated workshops, questionnaires, surveys, or other ways to meet with the stakeholders to:

  • Gain insight into stakeholder goals, needs, and problems.
  • Determine and prioritize the performance factors for the product of the project.
  • Determine current performance levels.
  • Identify gaps between current and desired levels of performance.
  • Identify the product or process features needed to fill that gap.
  • Design those features into the product scope.
  • Translate product scope into project scope.

Lastly, be sure to not only collect requirements but also get an agreement on them before defining the project scope and planning for time and cost.

Creating the project scope statement is one of the earliest and most important tasks that the project manager will facilitate. Inputs from the sponsor, customers, project team members, and other stakeholders will be of critical importance to getting the scope statement right. The project scope statement should be the sum of the products and services the project will deliver and, of equal importance, what the project will not deliver. A great many projects fail because the scope statement does not preclude added product features after the budget and schedule have been set.

Here’s an example of a scope statement:
“We will build a three mile section of highway connecting State Road 1 and State Road 8. The new section of highway will meet Federal Highway Standards. The section of the highway will not include curbing nor will there be additional landscaping beyond that specified by Federal Standards. The new highway section will not extend beyond State Road 8.”

A project scope statement like this explains what will, and will not be, accomplished by the project and gives the project manager a good grounding to control project scope throughout the project life cycle.

In order to define the scope for her project, Ashley will have to do the following:

  • Gather requirements: Ashley will have to meet the key players of the project and gain insight into their goals, needs, and problems. She will also have to convene the focus groups of users to identify gaps between the current and the desired levels of performance.
  • Prioritize the requirements: She will need to determine and prioritize the performance factors for the product of the project keeping the stakeholders’ requirements in mind. She will also have to create a requirements traceability matrix to keep track of who asked for what.

After Ashley has prioritized the requirements list, she will be able to identify the product or process features needed in the final product. She can then work those features into the product scope and carefully describe the features that will be and will not be part of the CRM system.

Once she has the scope statement ready, the next step is to create the WBS,


Work Breakdown Structure

Once the project manager has established an initial working project scope statement and collected requirements to validate and refine the scope statement, the next step is to define the work. To do this, the project manager and the project team must determine deliverables and decompose (subdivide) the work into smaller more manageable components (PMI, 2008). This process is called creating a WBS.

The characteristics of a WBS include:

  • A deliverable-oriented grouping of project elements
  • Organization and definition of the total work scope of a project
  • Each descending level represents increasing detail

The PMI Practice Standard for Work Breakdown Structures (2006) provides additional WBS characteristics:

  • Defines a hierarchy of deliverables
  • Supports definition of all work required
  • Supports integration of schedule and cost
  • Facilitates reporting and analysis
  • Provides a framework for specifying performance objectives

A WBS helps a project manager in:

  • Developing the project management plan
  • Defining activities
  • Estimating costs
  • Determining the project’s budget
  • Planning for quality
  • Planning for risks
  • Planning for procurement

Additionally, a WBS assists a project manager in reporting progress to not just the project team but also the stakeholders. More importantly, a WBS is the main input into project scheduling (time) and cost planning.

To prepare a WBS, first ensure that the scope statement has been agreed upon by the stakeholders. Then, the project manager and the team should:

  • Identify the final products of the project (use scope and requirements documents)
  • Define the project’s major deliverables that make up the final product
  • Decompose the major deliverables (to a level appropriate for management and control)
  • Review and refine the WBS until the stakeholders agree (PMI, 2006)

In a WBS, work is broken down in the following order:

  • Project
  • Task
  • Subtask
  • Activity
  • Work package

The activity level is the highest level where work can be accomplished as a complete job that yields a deliverable product.

A deliverable is a work outcome (result or item) that is measurable, tangible, and verifiable. A work package is the grouping of work that results in a deliverable at the lowest level of the WBS (PMI, 2006).

The Planning Phase

Coupled with the project charter, the Project Life Cycle (PLC) represents a roadmap for the project. Initiating, defining, and planning the project take much effort and considerable time.

Once the project charter is approved, the project manager and the project team should begin planning the project in earnest. The team should focus on:

  • Developing an initial WBS
  • Sequencing activities and building an initial schedule
  • Estimating the cost
  • Identifying risks and planning risk responses
  • Preparing a detailed communication plan
  • Organizing the project

Throughout the planning phase, the team should revise these activities so that at execution, the plan is a refined, valid document.

The PMI (2008) suggests that, in addition to the basic project plan described above, the project team should also develop a series of subsidiary management plans. These include:

  • Scope management plan: Describes the processes a project manager will use to control changes to the project scope
  • Requirements management plan: Describes the processes a project manager will use to collect, refine, and manage stakeholder requirements
  • Schedule management plan: Describes the processes a project manager will use to manage the project’s schedule
  • Cost management plan: Describes the processes a project manager will use to manage the project’s budget
  • Quality management plan: Describes the processes a project manager will use to ensure the project produces a quality product
  • Human resources plan: Describes the plan for bringing staff on to the project and removing staff if required
  • Communications management plan: Describes when, how, and to whom a project manager will communicate about the project
  • Risk response plan: Describes the predetermined responses a project manager will activate if a risk occurs
  • Procurement management plan: Describes what a project manager expects to purchase for the project (goods and services) and the expected sources
  • Issues management plan: Describes how a project manager will manage the issues that arise as the project proceeds

All these components make up a fully documented project plan. This level of detail is appropriate for a large, expensive, and strategic project. Some projects are small and do not require the level of detail presented here. For small projects, the project manager should not ignore any of the details and subsidiary plans but should, rather, review the PLC and the project charter and make a conscious decision to exclude various plans and activities, if warranted.

As you engage the lecture, open Project Charter and Project Life Cycle and cross-reference them.

The project management framework, processes, and knowledge areas that we have examined up until now are nothing without a methodology to apply them. We need something to “integrate” the framework, processes, and knowledge areas.

Consider this arrow diagram. opens in new window

Note that project integration management ties the core and facilitating knowledge areas into a coherent whole. The integration function of the main arrow in the diagram represents the primary role of a project manager. A project manager is responsible for pulling all actions and control mechanisms of a project into a cohesive unit. Integration is no small task, but its components are understandable.

The seven project integration management processes are:

  • Develop the project charter.
  • Develop the preliminary project scope statement.
  • Develop the project management plan.
  • Direct and manage project execution.
  • Monitor and control the project work.
  • Perform integrated change control.
  • Close the project or phase.

The table below shows how each of the processes under project integration management maps to one of the five process groups.

Knowledge Area

Processes

Project Management Process Group

Project Integration Management

  • Develop the project charter.
  • Develop the preliminary project scope statement.

Initiating process group

  • Develop the project management plan.

Planning process group

  • Direct and manage project execution.

Executing process group

  • Monitor and control the project work.
  • Perform integrated change control.

Monitoring and controlling process group

  • Close the project or phase.

Closing process group


[supanova_question]

MySQL Query Computer Science Assignment Help

MySQL Query Computer Science Assignment Help

× How can I help you?