Directions You’ll use the return merchandise authorization (RMA) entity relationship diagram (ERD) to build a database. Each of the tables in the ERD represents a database entity. The ERD is the...

Directions

You’ll use the return merchandise authorization (RMA) entity relationship diagram (ERD) to build a database. Each of the tables in the ERD 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 Templatefor this assignment. You’ll need to place your answers and screenshots in this document and then submit it for grading.
  
  
  • Check theDatabase Documentation Template Exampleto see expectations of what your assignment should look like.
  
  
  • Make sure to review the exampleRMA entity relationship diagram (ERD)that you should be using as a guide before you begin.
  
  
  • Review the module 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 thencreate a database schemacalled QuantigrationRMA that can hold tables. 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:
   
   
   1. A table to store customer information with a primary key of Customer ID
   
   
   2. A table to store order information with a primary key of Order ID
   
   
   3. A table to store RMA information with a primary key of RMA ID
   
   
   
   


3. Manuallyadd10recordsinto theCustomers table. The data can be made up for now, as you’ll populate all three tables later from the provided CSV files.


4. You’ve been asked to establish a database view called "Collaborators" that is based on the "Customers" table.Updatethe existingCustomers tableby using the SQL command provided belowto 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:
   
   
   
   
   1. The following command is partially complete. Fill in the missing information in the brackets to complete it and run the commands correctly:
      
      
      1. 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;
      
      
      
      
   
   
   2. DESCRIBE Collaborators;
   
   
   3. SELECT * FROM Collaborators LIMIT 5;
   
   
   4. At a later date you’ll update all instances of this name change. Now, you areonly
      updating the table name itself.
   
   
   
   

What to Submit

Submit your responses in theModule Three Major Activity Database Documentation Template. All of your answers should go in their respective locations in that document and then be submitted for grading and feedback. Each screenshot and its explanation should be sized to approximately one quarter of the page, with its description written below. This activity and the feedback from it will directly connect to the first step in Project One.