Module Three Major Activity Template

DAD 220 Module Three Major Activity Template Overview Complete these steps as you work through the directions for this activity. Replace the bracketed text with a screenshot and brief explanation where indicated. Each screenshot and its explanation should be sized to approximately onequarter of the page with the description written below the screenshot. Review the Template Screenshot Example linked in the guidelines and rubric for this assignment to see how screenshots for your assignment should look. Create a Database 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. [Insert screenshot and brief explanation here.] Connect to the Quantigration RMA schema. C reate the following tables with the appropriate attributes and keys in the Quantigration RMA database using the Quantigration RMA E ntity R elationship D iagram (ERD) as a reference : A table named C ustomers to store customer information with a primary key of Customer ID Provide the SQL commands you ran against MySQL to complete this successfully in your answer: A table named O rders to store order information with a primary key of Order ID and foreign key of Customer ID Provide the SQL commands you ran against MySQL to successfully complete this step. A table named RMA to store RMA information with a primary key of RMA ID and foreign key of Order ID Provide the SQL commands you ran against MySQL to successfully complete this step. Manually add 10 records into the Customers table . For now , you can make up data . In a later assignment , you wi ll 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 V iew 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 then command and run it correctly: DESCRIBE Collaborator; SELECT * FROM Collaborator LIMIT 5;