Learning Goal: I’m working on a mysql discussion question and need an explanatio

Learning Goal: I’m working on a mysql discussion question and need an explanation and answer to help me learn.This is an individual assignment. In this assignment you are expected to implement the data model produced for Merrill Hand Tools Ltd. Your database should be suitable to keep an inventory of the tools the company manufactures and sells. It should support relevant business processes in the organisation, including manufacturing and sales and fulfilment of orders. Therefore, the database should record suitable and enough data regarding raw materials used in the company, and the levels required to manufacture each tool; customers and suppliers; production lines and their scheduling; deliveries of raw materials received from suppliers; orders placed by customers; test conducted on tools, and faults reported by purchasers, among others. You are expected to determine the tables to be implemented. Create the tables, and correctly set primary keys, foreign keys, data types, and other constraints, and help make the constraints manageable. Create sample records, and create and run several queries that address the information needs of Merrill Hand Tools Ltd.
Requirements: 000

Learning Goal: I’m working on a mysql discussion question and need an explanatio

Learning Goal: I’m working on a mysql discussion question and need an explanation and answer to help me learn.This is an individual assignment. In this assignment you are expected to implement the data model produced for Merrill Hand Tools Ltd. Your database should be suitable to keep an inventory of the tools the company manufactures and sells. It should support relevant business processes in the organisation, including manufacturing and sales and fulfilment of orders. Therefore, the database should record suitable and enough data regarding raw materials used in the company, and the levels required to manufacture each tool; customers and suppliers; production lines and their scheduling; deliveries of raw materials received from suppliers; orders placed by customers; test conducted on tools, and faults reported by purchasers, among others. You are expected to determine the tables to be implemented. Create the tables, and correctly set primary keys, foreign keys, data types, and other constraints, and help make the constraints manageable. Create sample records, and create and run several queries that address the information needs of Merrill Hand Tools Ltd.
Requirements: 3000

Learning Goal: I’m working on a mysql question and need an explanation and answe

Learning Goal: I’m working on a mysql question and need an explanation and answer to help me learn.This is an individual assignment. In this assignment you are expected to implement the data model produced for Merrill Hand Tools Ltd. Your database should be suitable to keep an inventory of the tools the company manufactures and sells. It should support relevant business processes in the organisation, including manufacturing and sales and fulfilment of orders. Therefore, the database should record suitable and enough data regarding raw materials used in the company, and the levels required to manufacture each tool; customers and suppliers; production lines and their scheduling; deliveries of raw materials received from suppliers; orders placed by customers; test conducted on tools, and faults reported by purchasers, among others. You are expected to determine the tables to be implemented. Create the tables, and correctly set primary keys, foreign keys, data types, and other constraints, and help make the constraints manageable. Create sample records, and create and run several queries that address the information needs of Merrill Hand Tools Ltd.
Requirements: 3000

Learning Goal: I’m working on a mysql test / quiz prep and need support to help

Learning Goal: I’m working on a mysql test / quiz prep and need support to help me learn.Realistic Exam Questions90% of people certified for professional development benefits and beginning a successful career such as promotion, Job Retention, and Professional Credibility.Web-Based Self Assessment Practice Test
Desktop Practice Test Software
PDF Study Material
70,000+ people are already got success with GetCertifyHere
Quick and safe approach to your success
Click Link for more information:https://www.getcertifyhere.com/microsoft/az-140.ht…
Requirements: 70

Learning Goal: I’m working on a mysql project and need support to help me learn.

Learning Goal: I’m working on a mysql project and need support to help me learn.IntroductionIn this project, you will query the Chinook Database. The Chinook Database holds information about a music store. For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. To assist you in the queries ahead, the schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows.All of the below instructions are discussed in detail as we work through this lesson on your way to completing this project. The below serves as a quick reference of what you will be doing as you progress through the completion of this project.InstructionsYou will need to follow the instructions on the next three concepts to get the Chinook database up and running on your own machine, and check that it is set up correctly. There will be two parts to this project.The first part is a series of questions that will assure you have mastered the main concepts taught throughout the SQL lessons. Though these questions will not be “graded” by a reviewer, they will help you self assess.
The second part is a presentation. Similar to the first project, there isn’t a ‘right answer’ for the second portion of the project. You have the ability to be creative in the questions you ask. You will then write a SQL query to pull the data needed to successfully answer your question. Use the pulled data to build a visual (bar chart, histogram, or another plot) that answers your question. The essentials of your project submission are discussed in the next sections. In order to review your presentation, you will need to save your slides as a PDF.
Project WalkthroughThis video shows one of our instructors giving some great hints and tips for how to get started with your project: Walkthrough VideoCommon Questions and Answers:To find answers to common questions regarding this project, head to our knowledge base. Once you are there, in the drop-down, choose Any for the program and search for music and choose Music SQL Database in the project. Then take a look at the questions that have already been posed and answered to help you if you get stuck.Project submissionPresentationsYou are now on the portion of the project you will need to submit to a reviewer. To pass this project follow the below instructions to create a presentation.Your presentation should include:Four slides
One visualization per slide
A 1-2 sentence explanation of each slide
The SQL query used to create the data used in the visualization.
Note: you may choose to use queries that were motivated by the questions on the previous concepts, or you may choose four entirely new questions. However, if you use any of the previous queries, they must be those that had a JOIN as stated in the Rubric.The submission template is a Google Slides file. Make a copy of the submission template to complete your project. We suggest you use the layout provided, though it is not a requirement.QueriesPlease include a text file that includes each of the queries used to create the visualizations. You should format your queries for readability, use this tool to help http://www.sql-format.com/. In a plain text file (use notepad, notepad++, or atom).VisualizationsWe suggest you use a spreadsheet application, such as Excel or Google Sheets to create your visualizations. However, you’re welcome to use whatever tool you’d like. Your visualizations could be any that you learned about in the previous lesson. Below is one example, and a link has been provided to an example slide.You should have four slides that are similar to the below submission, but the questions you ask are up to you, and all four of your final submitted queries should contain a JOIN and AGGREGATION. Look at the Rubric to verify you have met all of necessities for this submission.Additional GuidelinesThere shouldn’t be any additional data prep (sorting, filtering, renaming, etc.) between the query output and the visualization.
All your four queries must include at least one join and an aggregation.
Review your project against the project Rubric. Reviewers will use this to evaluate your work.
The first part of this project is aimed at helping you understand the database, so you can ask interesting questions in the second part. Feel free to use and expand upon the queries you wrote in the first part.
Once you’ve finished your project, submit the presentation as a PDF and the queries as a .txt file.
Don’t be afraid to challenge yourself! Try to combine the SQL concepts you know!
In order to review your presentation, you will need to save your slides as a PDF. You can do this from within Google Slides by selecting File > Download as > PDF Document.PROJECT SPECIFICATIONMusic SQL DatabaseSQL QueriesCRITERIAMEETS SPECIFICATIONSThe student can write error-free SQL queries.All SQL queries run without errors and produce the intended results.The student can use joins correctly in SQL queries.Each SQL query needs to include one or more explicit join. The JOIN or JOINs should be necessary to the query. If a question does not require a JOIN please change the question to be one that does.Example:SELECT *FROM AlbumJOIN Track on Track.AlbumID = Album.AlbumIDThe student can use aggregations correctly in SQL queries.Each SQL query needs to include one or more aggregation. This could be a COUNT, AVG, SUM, or other aggregation.Student can answer multiple questions by using SQLThe student has used at least 4 unique SQL queries in their submission.PresentationCRITERIAMEETS SPECIFICATIONSThe student’s slides are organized well and are easy to read and understand.Each slide should have an appropriate title and the visualization descriptions should be free of significant factual, spelling and grammar mistakes.The student can create data visualizations that provide useful information.All visualizations should make logical sense and provide accurate information about the indicated area.The student can format data visualizations clearly and make good use of labeling.All visualizations include a title and axis labels, have a legend where applicable, and are easily understood.Every visualization should havechart title
x axis title
x axis labels
y axis title
y axis labels
Submission PhaseCRITERIAMEETS SPECIFICATIONSThe student has uploaded all files necessary for review.A PDF report has been uploaded and a .txt file with the queries has been uploaded in a single zipped folder fileSuggestions to Make Your Project Stand Out!To make you project standout, consider the following:Look for interesting patterns and insights in the data rather than simply providing summary statistics.
Use other advanced SQL functions, such as the case function.
Make good use of color, size, and shape in your visualizations.
Use the slide title and/or chart description on each slide to state the key insight of the visualization.
To submit your project, please do the following:Review your project against the project Rubric. Reviewers will use this to evaluate your work.
Create your slides with whatever presentation software you’d like (e.g. Google Slides, PowerPoint, Keynote, etc.).
In order to review your presentation, you will need to save your slides as a PDF. You can do this from within Google Slides by selecting File > Download as > PDF Document.Create a separate text file with each of the SQL queries used to create the visualizations.
Save the presentation as a PDF and the SQL queries in a text file(.txt) in the same folder.
Requirements: 4 Queries with its slides results

Learning Goal: I’m working on a mysql project and need support to help me learn.

Learning Goal: I’m working on a mysql project and need support to help me learn.IntroductionIn this project, you will query the Chinook Database. The Chinook Database holds information about a music store. For this project, you will be assisting the Chinook team with understanding the media in their store, their customers and employees, and their invoice information. To assist you in the queries ahead, the schema for the Chinook Database is provided below. You can see the columns that link tables together via the arrows.All of the below instructions are discussed in detail as we work through this lesson on your way to completing this project. The below serves as a quick reference of what you will be doing as you progress through the completion of this project.InstructionsYou will need to follow the instructions on the next three concepts to get the Chinook database up and running on your own machine, and check that it is set up correctly. There will be two parts to this project.The first part is a series of questions that will assure you have mastered the main concepts taught throughout the SQL lessons. Though these questions will not be “graded” by a reviewer, they will help you self assess.
The second part is a presentation. Similar to the first project, there isn’t a ‘right answer’ for the second portion of the project. You have the ability to be creative in the questions you ask. You will then write a SQL query to pull the data needed to successfully answer your question. Use the pulled data to build a visual (bar chart, histogram, or another plot) that answers your question. The essentials of your project submission are discussed in the next sections. In order to review your presentation, you will need to save your slides as a PDF.
Project WalkthroughThis video shows one of our instructors giving some great hints and tips for how to get started with your project: Walkthrough VideoCommon Questions and Answers:To find answers to common questions regarding this project, head to our knowledge base. Once you are there, in the drop-down, choose Any for the program and search for music and choose Music SQL Database in the project. Then take a look at the questions that have already been posed and answered to help you if you get stuck.PROJECT SPECIFICATIONMusic SQL DatabaseSQL QueriesCRITERIAMEETS SPECIFICATIONSThe student can write error-free SQL queries.All SQL queries run without errors and produce the intended results.The student can use joins correctly in SQL queries.Each SQL query needs to include one or more explicit join. The JOIN or JOINs should be necessary to the query. If a question does not require a JOIN please change the question to be one that does.Example:SELECT *FROM AlbumJOIN Track on Track.AlbumID = Album.AlbumIDThe student can use aggregations correctly in SQL queries.Each SQL query needs to include one or more aggregation. This could be a COUNT, AVG, SUM, or other aggregation.Student can answer multiple questions by using SQLThe student has used at least 4 unique SQL queries in their submission.PresentationCRITERIAMEETS SPECIFICATIONSThe student’s slides are organized well and are easy to read and understand.Each slide should have an appropriate title and the visualization descriptions should be free of significant factual, spelling and grammar mistakes.The student can create data visualizations that provide useful information.All visualizations should make logical sense and provide accurate information about the indicated area.The student can format data visualizations clearly and make good use of labeling.All visualizations include a title and axis labels, have a legend where applicable, and are easily understood.Every visualization should havechart title
x axis title
x axis labels
y axis title
y axis labels
Submission PhaseCRITERIAMEETS SPECIFICATIONSThe student has uploaded all files necessary for review.A PDF report has been uploaded and a .txt file with the queries has been uploaded in a single zipped folder fileSuggestions to Make Your Project Stand Out!To make you project standout, consider the following:Look for interesting patterns and insights in the data rather than simply providing summary statistics.
Use other advanced SQL functions, such as the case function.
Make good use of color, size, and shape in your visualizations.
Use the slide title and/or chart description on each slide to state the key insight of the visualization.
To submit your project, please do the following:Review your project against the project Rubric. Reviewers will use this to evaluate your work.
Create your slides with whatever presentation software you’d like (e.g. Google Slides, PowerPoint, Keynote, etc.).
In order to review your presentation, you will need to save your slides as a PDF. You can do this from within Google Slides by selecting File > Download as > PDF Document.Create a separate text file with each of the SQL queries used to create the visualizations.
Save the presentation as a PDF and the SQL queries in a text file(.txt) in the same folder.
Requirements: 4 Queries with its slides results

Learning Goal: I’m working on a mysql exercise and need an explanation and answe

Learning Goal: I’m working on a mysql exercise and need an explanation and answer to help me learn.You will use the iSchool database to answer the questions in this assignment. Please be sure that you have a pristine copy of the database on your server. If you have changed any values in any of the database tables, download and re-execute this creation script: create_iSchool.sqlFor Q1 you will complete a trigger, starting with this partially-created script: INST 327 – Assignment 7 – Trigger Partial Code.sql For Q2 you will complete a function, starting with this partially-created script: INST 327 – Assignment 7 – Function Partial Code.sqThe questions, instructions, and the files needed are included in this folder: https://drive.google.com/drive/folders/1w64gc25q_m…

Learning Goal: I’m working on a mysql question and need an explanation and answe

Learning Goal: I’m working on a mysql question and need an explanation and answer to help me learn.Assignment For this assignment, you will be using FTK Imager and SQLitebrowser to analyze the Ignatius-iPhone.ad1 file. Answer the below questions while analyzing the image. 1. Go to filesystem > private > var > Wireless > Library > Call History. Explain how you would extract the call_history.db database to evaluate in SQLite Browser? Provide a snapshot of opening the file in SQLite browser. (5pts) i. first searches the system folder and subfolders and find databases that are readable this will provide you with database paths that you can easily read. ii. search the schema to know the values iii. now extract the call tables and store the retrieved values in an array of dictionaries NOTE: other conditions can be added to check the flag and determine whether the call is incoming or outgoing. 2. In SQLite browser, how many records do you see in the call table? Explain how you would view this in FTK Imager? (9pts) 3. In FTK, go to filesystem > private > var > mobile > Media > Photo Data. Do you see any pictures listed in the folders? If so, provide at least two snapshots of the photos that you have found within the image. (9pts) 4. Parse through and analyze the image. Come up with five items that could be of interest. Explain why each item is of interest (in 3-5 sentences). Provide snapshots for each item of interest. (9pts) Dropbox link to supporting files. https://www.dropbox.com/t/0Bl1F8HbE6LQV5At

Learning Goal: I’m working on a mysql question and need an explanation and answe

Learning Goal: I’m working on a mysql question and need an explanation and answer to help me learn.For this assignment, create a stored procedure using Oracle that will update the salary of an employee in a sample “emp” table. This table probably exists in your database already but if it does not, there is code to create it in the directory. Make sure you use proper transaction control and error checking. I need to see the code for the procedure and see the execution of the procedure with the results. 1. Open an Oracle SQL*Plus (or any other Oracle tool of your choice) session as shown below. Log in using your Oracle account. Examine the data in the emp table. It should look similar to the screen below (it does not have to be exactly the same) Below is a sample to get you started. Create or Replace Procedure update_emp (emp_id int, new_sal number) IS –USED FOR ERROR CHECKING v_ErrorCode number; v_ErrorMsg Varchar2(200); v_CurrentUser Varchar2(100); BEGIN . . . Exception When OTHERS THEN END update_emp; / Once your procedure is completed, compile it and test it by updating an employee with a new salary. Please send the code and an example of the procedure running.

Learning Goal: I’m working on a mysql exercise and need an explanation and answe

Learning Goal: I’m working on a mysql exercise and need an explanation and answer to help me learn.Open the pdf file, all the instructions are there. You will need an oracle apex account to run the sql commands. If you can’t get it done within the 5 hours, then don’t bid.