Answered You can hire a professional tutor to get the answer.
QUESTION
Refer to the Week 1 - Task: MySQL™ Version 5.6: Download Instructions. The IT Director approved your initial Fine Diamond Database Project designs. Now, you need to develop and test initial queries fo
Refer to the Week 1 - Task: MySQL™ Version 5.6: Download Instructions.
The IT Director approved your initial Fine Diamond Database Project designs. Now, you need to develop and test initial queries for the IT technical team.
As a team, complete the following tasks:
- Build the tables for at least two stores of the Fine Diamonds Company and populate them with at least ten records for each table.
- Develop and execute queries to provide the required analytics and reporting to include the following:
- A 1-page inventory list displaying all the attributes for each diamond in inventory (both in- and out-of-stock)
- The total customer sales price and store costs for all in-stock inventory items
- A 1-page list of all in-stock diamonds with a carat weight of over 1.0 carats
- A 1-page list of customers who have placed an order within the last 12 months, along with their names and order numbers
- A 1-page list of all orders placed within the past 12 months, along with the customer's name and actual items included in the order
- Compress the output of the queries, including all of the scripts, to create the database tables, establish keys and constraints, populate data within the database, and queries into a single ZIP folder.
- Prepare a summary for the IT technical team that describes the following:
- An explanation of the process used to determine the data types within each table
- An explanation of the most difficult process in designing and building the data
- How organizations can overcome the difficulties associated with the process
Use MySQL Version 5.6 for database and query development.
Choose one of the following ways to create your summary:
- A 14- to 16-slide Microsoft® PowerPoint® presentation, including the query in the speaker notes of each slide with a screenshot of a query output
- A 2-page Microsoft® Word document
Submit your summary and ZIP file of your query outputs.
