//.stuvia.////doc///2026//2027.100%A+.
DAD 220 Module Three Major Activity
Thomas Nguyen
3/22/24
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 one-quarter 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
1. 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.
c.
New database Quantigration RMA created and connected.
2. 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:
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:53 GMT -06:00
1 https://www.cliffsnotes.com//study-notes/6780892
, //.stuvia.////doc///2026//2027.100%A+.
a. A table named Customers to store customer information with a primary key of
Customer ID
i. Provide the SQL commands you ran against MySQL to complete this successfully
in your answer:
Created Customers Table
CREATE TABLE Customer (Customer_ID INT PRIMARY KEY, First_Name VARCHAR(25), Last_Name
VARCHAR(25), Street VARCHAR(50), City VARCHAR(50), State VARCHAR(25), Zip_Code VARCHAR(10),
Telephone VARCHAR(15));
Corrected Customer table name to Customers using; RENAME TABLE Customer TO Customers;
b. A table named Orders to store order information with a primary key of Order ID and
foreign key of Customer ID
i. Provide the SQL commands you ran against MySQL to successfully complete this
step.
ii.
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:53 GMT -06:00
2 https://www.cliffsnotes.com//study-notes/6780892
DAD 220 Module Three Major Activity
Thomas Nguyen
3/22/24
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 one-quarter 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
1. 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.
c.
New database Quantigration RMA created and connected.
2. 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:
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:53 GMT -06:00
1 https://www.cliffsnotes.com//study-notes/6780892
, //.stuvia.////doc///2026//2027.100%A+.
a. A table named Customers to store customer information with a primary key of
Customer ID
i. Provide the SQL commands you ran against MySQL to complete this successfully
in your answer:
Created Customers Table
CREATE TABLE Customer (Customer_ID INT PRIMARY KEY, First_Name VARCHAR(25), Last_Name
VARCHAR(25), Street VARCHAR(50), City VARCHAR(50), State VARCHAR(25), Zip_Code VARCHAR(10),
Telephone VARCHAR(15));
Corrected Customer table name to Customers using; RENAME TABLE Customer TO Customers;
b. A table named Orders to store order information with a primary key of Order ID and
foreign key of Customer ID
i. Provide the SQL commands you ran against MySQL to successfully complete this
step.
ii.
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:53 GMT -06:00
2 https://www.cliffsnotes.com//study-notes/6780892
