ShoStep One: Directions

Create a Database

The data architect on your DevOps team has come to you with a logical database diagram referred to as an entity relationship diagram $($ERD$).$ This ERD is documentation of the tables, their relationships to each other, their attributes, and any primary or foreign keys on those attributes. These elements are required to create the new database.

Before you begin, complete the following steps:

Review the example ERD in the Quantigration RMA Entity Relationship Diagram in the Supporting Materials section below.

Download the Project One Template from the What to Submit section below. You will use this template to record your work for this assignment.

Complete the steps below to create three tables named Customers, Orders, and RMA, in the QuantigrationUpdates database. Specifically, you must address the following rubric criteria:

In your online IDE $($Codio$),$ create a database schema called QuantigrationUpdates that will hold tables by using SQL commands.

List out the database name on the screen.

Provide the SQL commands you ran against MySQL to complete this step.

Connect to the QuantigrationUpdates schema. Using the ERD as a reference, write SQL commands to create the following tables with the appropriate attributes and keys to demonstrate relationships based on the ERD:

A table named Customers to store customer information with a primary key of Customer ID

A table named Orders to store order information with a primary key of Order ID and a foreign key of Customer ID

A table named RMA to store RMA information with a primary key of RMA ID and a foreign key of Order ID

Stop: Save your work before moving on to Step Two of this process. You$$ll continue to work in Codio and use the documentation you started in Step One.w me the steps to solve