The database you are building is based on this diagram. Each of these tables represents an entity. Each

entity contains attributes $($fields$).$ Attributes have data types, and some are identified as primary or

foreign keys. The ERD is the blueprint for building your relational database.In your online integrated development environment $($Codio$)$ create a database schema called Quantigration RMA that can hold tables.

A$.$ List the database name on the screen.

B$.$ 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$.$ A table named Customers to store customer information with a primary key of Customer ID

B$.$ A table named Orders to store order information with a primary key of Order ID and foreign key of Customer ID

C$.$ 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:

A$.$ 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;

B$.$ DESCRIBE Collaborator;

C$.$ SELECT$*$ FROM Collaborator LIMIT $5$;