DAD_220_Module_Three_Major_Activity_Database_Documentation_Template.docx.pdf| Full Q&A | 2026/2027
DAD 220 Module Three Major Activity Database Documentation Template
Overview
Complete these steps as you work through the directions for this activity. Replace the bracketed text
with your screenshots and brief explanations of the work they show. Each screenshot and its
explanation should be sized to approximately one quarter of the page, with the description written
below the screenshot. Follow these rules for each of the prompts and questions below. Review the
example document for help.
Create a Database
1. In your integrated development environment (IDE), create a database schema called
QuantigrationRMA. List out the database name. Provide the SQL commands you ran to
successfully complete this in your answer, then connect to it:
Explanation: Created a database schema called QuantigrationRMA that can hold tables.
2. Using the entity relationship diagram (ERD) as a reference, create the following tables with the
appropriate attributes and keys:
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:50 GMT -06:00
https://www.cliffsnotes.com//study-notes/3690294
, DAD_220_Module_Three_Major_Activity_Database_Documentation_Template.docx.pdf| Full Q&A | 2026/2027
a. A table named customers in the QuantigrationRMA database as defined on the project
ERD. Provide the SQL commands you ran against MySQL to complete this successfully in
your answer:
Explanation: Created a table to store customer information with a primary key of Customer ID.
b. A table named orders in the QuantigrationRMA database as defined on the project ERD.
Provide the SQL commands you ran against MySQL to complete this successfully in your
answer:
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:50 GMT -06:00
https://www.cliffsnotes.com//study-notes/3690294
, DAD_220_Module_Three_Major_Activity_Database_Documentation_Template.docx.pdf| Full Q&A | 2026/2027
Explanation: Created a table to store order information with a primary key Order ID and
Foreign key Customer ID.
c. A table named rma in the QuantigrationRMA database as defined on the project ERD.
Provide the SQL commands you ran against MySQL to complete this successfully in your
answer:
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:50 GMT -06:00
https://www.cliffsnotes.com//study-notes/3690294
DAD 220 Module Three Major Activity Database Documentation Template
Overview
Complete these steps as you work through the directions for this activity. Replace the bracketed text
with your screenshots and brief explanations of the work they show. Each screenshot and its
explanation should be sized to approximately one quarter of the page, with the description written
below the screenshot. Follow these rules for each of the prompts and questions below. Review the
example document for help.
Create a Database
1. In your integrated development environment (IDE), create a database schema called
QuantigrationRMA. List out the database name. Provide the SQL commands you ran to
successfully complete this in your answer, then connect to it:
Explanation: Created a database schema called QuantigrationRMA that can hold tables.
2. Using the entity relationship diagram (ERD) as a reference, create the following tables with the
appropriate attributes and keys:
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:50 GMT -06:00
https://www.cliffsnotes.com//study-notes/3690294
, DAD_220_Module_Three_Major_Activity_Database_Documentation_Template.docx.pdf| Full Q&A | 2026/2027
a. A table named customers in the QuantigrationRMA database as defined on the project
ERD. Provide the SQL commands you ran against MySQL to complete this successfully in
your answer:
Explanation: Created a table to store customer information with a primary key of Customer ID.
b. A table named orders in the QuantigrationRMA database as defined on the project ERD.
Provide the SQL commands you ran against MySQL to complete this successfully in your
answer:
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:50 GMT -06:00
https://www.cliffsnotes.com//study-notes/3690294
, DAD_220_Module_Three_Major_Activity_Database_Documentation_Template.docx.pdf| Full Q&A | 2026/2027
Explanation: Created a table to store order information with a primary key Order ID and
Foreign key Customer ID.
c. A table named rma in the QuantigrationRMA database as defined on the project ERD.
Provide the SQL commands you ran against MySQL to complete this successfully in your
answer:
This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:50 GMT -06:00
https://www.cliffsnotes.com//study-notes/3690294
