Module Three Major Activity Documentation: Create a Database

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 capture. 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 assistance.

Step One: 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:

I Utilized the CREATE DATA QuantigrationRMA command to create and name schema.

SHOW DATABASES LIKE ‘QuantigrationRMA’; finds just the name schema versus showing all

schemas in the workspace. USE QuantigrationRMA; connects us to the new database.

2. Using the ERD as a reference, create the following tables with the appropriate attributes and

keys:

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:

Powered by qwivy(www.qwivy.org)

 1 / 1