Networking Equipment Manufacturer

Overview
Quantigration, a rapidly growing networking equipment manufacturer, has been having problems with its equipment returns. You’ve been hired to create a database using SQL commands for processing all returns. You will be given some of the code needed to create the database and will fill in the rest using what you have learned in assignments so far in this course.

Directions
To create a database for Quantigration, you will use the company’s return merchandise authorization (RMA) entity relationship diagram (ERD). Each of the tables in the ERD represents a database entity. The ERD is the blueprint for building your relational database.

Before you begin, complete the following tasks:

Download the Module Three Major Activity Template for this assignment in the What to Submit section below. You will place your answers and screenshots of your work in this document and submit the document for grading.
Check the Template Screenshot Example in Supporting Materials below to see how assignment screenshots should look.
Review the Quantigration RMA Entity Relationship Diagram in the Supporting Materials section below for guidance on creating the database.
To complete this activity, follow the steps shown below.

Specifically, you must address the following rubric criteria:

In your online integrated development environment (Codio) create a database schema called Quantigration RMA that can hold tables.
List the database name on the screen.
Provide the SQL commands you ran to successfully complete this step.
Connect to the Quantigration RMA schema. Create the following tables with the appropriate attributes and keys in the Quantigration RMA database using the Quantigration RMA Entity Relationship Diagram (ERD) as a reference:
A table named Customers to store customer information with a primary key of Customer ID
A table named Orders to store order information with a primary key of Order ID and foreign key of Customer ID
A table named RMA to store RMA information with a primary key of RMA ID and foreign key of Order ID
Manually add 10 records into the Customers table. For now, you can make up the data. In a later assignment, you will use the CSV files provided to fill in all three tables.
You’ve been asked to establish a database view called Collaborators based on the Customers table. Create the Collaborators View from the existing Customers table by using the SQL command below to say “Collaborators”. The view should show all instances of “Customer” renamed as “Collaborator”. Execute the following statements and provide one or more supporting screenshots showing the database view:
The following command is partially complete. Fill in the missing information in the brackets to complete the command and run it correctly:
CREATE VIEW Collaborator AS
SELECT CustomerID AS CollaboratorID
[Enter in the correct column names from the Customer table that you want to change in the Collaborator table]
FROM Customers;
DESCRIBE Collaborator;
SELECT * FROM Collaborator LIMIT 5;