DAD 220 Southern New Hampshire University SQL Commands for Processing All Returns Project

Overview

Quantigration, a rapidly expanding networking equipment manufacturer, wants to document all of its equipment returns. It has identified this as a problematic area. You have been hired to create a database using SQL commands for processing all returns.

Prompt

You will use the return merchandise authorization (RMA) entity relationship diagram (ERD) to build a database. Each of these tables represents a database entity. The ERD is the blueprint for building your relational database.

• Before you begin, do the following:
  • Make sure to download the Module Three Major Activity Database Documentation Template Word Document for this assignment. You will need to place your answers and screenshots in this document and then submit it for grading.
  • Check the Database Documentation Template Example PDF for clarity on expectations of what yours should look like.
  • Make sure to review the example RMA entity relationship diagram (ERD) PDF that you should be using as a guide before you begin. A text version is also available: Quantigration RMA ERD Text Version Word Document.
  • Review the resources on how to capture screenshots, if necessary.

1. Go to your online integrated development environment (Codio), log in, start a new terminal session, and then create a database schema called QuantigrationRMA and list it out on the screen. Then, connect to the QuantigrationRMA schema.
2. Using the ERD as a reference, create the following tables with the appropriate attributes and keys:
   • A table to store customer information with a primary key of customer ID
   • A table to store order information with a primary key of Order ID
   • A table to store RMA information with a primary key of RMA ID
3. Manually add 10 records into the Customers table. The data can be made up for now, as you will populate all three tables later from the provided .csv files
4. Due to a new company branding initiative, you’ve been asked to establish a database view called “Collaborators” that is based on the “Customers” table. Create a view from the existing Customers table by using the SQL command provided 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 verifying establishment of the database view: 
   • The following command is partially complete. Fill in the missing information in the brackets to complete it and run the commands correctly.
   • CREATE VIEW Collaborator AS
     SELECT CustomerID AS CollaboratorID, [Enter in the correct column names from that customer table that you want to change in the collaborator table]
     FROM Customers;
   • DESCRIBE Collaborators;
   • SELECT * FROM Collaborators LIMIT 5;