The database you are building is based on the relationship between the tables and the information that they have. These tables, the data in them, and how they relate are described below. Each of these tables represents an entity. Each entity contains attributes or fields.

Attributes have data types, and some are identified as primary or foreign keys. The ERD is the blueprint for building your relational database.

There are three separate tables. One in the bottom left corner, labeled RMA, with another directly over it in the top left-hand corner, labeled Orders. Directly to the right of the Orders table, in the upper right-hand corner, is another table labeled Customers.

The relationship between these tables is represented by a line connecting them. That line begins in the bottom left RMA table. It then goes to the Orders tables, and finally to the Customers table.

Following the path of this relationship, the tables feature the following information:

RMA

Reason	varchar(25)
RMAID	int
OrderID	int
Status	varchar(50)
Step	varchar(15)

Then, the line goes to the Orders table, which has the following information:

Orders

OrderID	int
CustomerID	int
SKU	varchar(20)
Description	varchar(50)

Finally, the line coming out of the Orders table goes to the Customers table, which has the following information:

Customers

CustomerID	int
FirstName	varchar(25)
LastName	varchar(25)
Street	varchar(50)
City	varchar(50)
State	varchar(25)
ZipCode	int
Telephone	varchar(15)

Competency

In this project, you will demonstrate your mastery of the following competency:

• Analyze the results of queries constructed to address data requirements

Scenario

The product manager of Quantigration has asked your data analytics team for a report summarizing your analysis of the return merchandise authorizations (RMAs) that have been received. These are the same data sets that you have already been working with. Your report should focus on summarizing the analysis and presenting your findings to the product manager.

Directions

RMA Report In your report on the findings of your analysis, respond to the managers requests to summarize the data you have been working with to identify key information that will be of value to the company when developing future business strategies to streamline operations. Remember, not everyone who reviews this report will have a technical background.

1. Begin by writing SQL commands to capture usable data (which you have preloaded into Codio) for your analysis. Specifically, the product manager wants you to investigate and analyze the following:
   • Analyze the frequency of returns by state for all products, and describe your findings in your report.
   • Analyze the percentage of returns for all products, and describe your findings in your report.

2. In your report, summarize your analysis of the data youve captured. Include screenshots of the results of each query. When summarizing results, you may want to consider the following questions:
   • How does the data provide the product manager with usable information?
   • What are the potential flaws in the data that has been presented?
   • Are there any limitations on your conclusions, or any angles you havent considered?

3. Clearly communicate your findings to stakeholders.
   • Make sure that all parts of your report are written in a way that very clearly explains the necessary information.