DAD 220 Module Three Major Activity | Database Documentation Template, Solutions & Assignment Guide 2026/2027

le
*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Three Major
Page 1Activity
of 810/16/2026,
Database Documentation
5:42:03
220 Module
AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*DAD
Three
Template
Major Activity
10/16/2026,
Database
5:42:03
Documentation
AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Template .pdf*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!
220 Module Three Major Activity Database Documentati
220 Module




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


*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
0 ModuleDADThree 220
Major
Module
Activity
ThreeDatabase
Major
220 Module
Activity
Documentation
Three
Database
Major
https://www.cliffsnotes.com//study-notes/3690294 Template
Documentation
Activity Database
10/16/2026,
Template
Documentation
5:42:03
PageAM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
1 ofTemplate
810/16/2026,
.pdf*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!
5:42:03 AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#
220

,le
*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Three Major
Page 2Activity
of 810/16/2026,
Database Documentation
5:42:03
220 Module
AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*DAD
Three
Template
Major Activity
10/16/2026,
Database
5:42:03
Documentation
AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Template .pdf*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!
220 Module Three Major Activity Database Documentati
220 Module




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


*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
0 ModuleDADThree 220
Major
Module
Activity
ThreeDatabase
Major
220 Module
Activity
Documentation
Three
Database
Major
https://www.cliffsnotes.com//study-notes/3690294 Template
Documentation
Activity Database
10/16/2026,
Template
Documentation
5:42:03
PageAM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
2 ofTemplate
810/16/2026,
.pdf*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!
5:42:03 AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#
220