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

*!#&()#_)#!*&$!*#)(!*DAD
&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Page 1 of 610/16/2026,
220 Module
5:42:03
Three
AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*DAD
Major Activity ,10/16/2026,
2205:42:03
ModuleAM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Three Major Activity ,.pdf*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!
220 Module Three Major Activity ,10/16/2026,
2205:42:03
ModuleA




Alexander Freeders

DAD 220 Module Three Major Activity

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.




This screenshot shows the creation of
the Quantigration RMA database and
selection of said database with the
USE command.




This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:58 GMT -06:00


&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
^&*#*((*!#&()#_)#!*&$!*#)(!*DAD
DAD 220 Module Three 220
MajorModule
Activity
Three
,Page
Major
1 of Activity
https://www.cliffsnotes.com//study-notes/16772391 610/16/2026,
,10/16/2026,
2205:42:03
Module5:42:03
AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*DAD
ThreeAM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Major Activity ,.pdf*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!
220 Module 220
Thre

,*!#&()#_)#!*&$!*#)(!*DAD
&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Page 2 of 610/16/2026,
220 Module
5:42:03
Three
AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*DAD
Major Activity ,10/16/2026,
2205:42:03
ModuleAM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Three Major Activity ,.pdf*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!
220 Module Three Major Activity ,10/16/2026,
2205:42:03
ModuleA




Alexander Freeders

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:

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:




In this screenshot I am creating the Customers table with the fields as defined in the RMA ERD. The
primary key is identified at the end of the CREATE command.




This study source was downloaded by 1827175 from cliffsnotes.com on 01-08-2026 20:33:58 GMT -06:00


&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
^&*#*((*!#&()#_)#!*&$!*#)(!*DAD
DAD 220 Module Three 220
MajorModule
Activity
Three
,Page
Major
2 of Activity
https://www.cliffsnotes.com//study-notes/16772391 610/16/2026,
,10/16/2026,
2205:42:03
Module5:42:03
AM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*DAD
ThreeAM*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!*&$!*#)(!*##(*0DAD
Major Activity ,.pdf*&!#%#&&!%%#^#^&^!#&*^&^*#!(FG*T!^&*#*((*!#&()#_)#!
220 Module 220
Thre