DAD 220 Module Three Major Activity

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

DAD-220-X3

Subject

Chemistry

Date

Jun 4, 2024

Type

docx

Pages

7

Uploaded by MasterButterflyPerson397

DAD 220 Module Three Major Activity Federico Castellanos 5/26/2024 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.
- To perform the required task. I just ran the following commands: “CRATE DATABASE QuatigrationRMA;” “USE QuatigrationRMA;” 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 the Image above, it is clear how the customer table was created using the following command: CREATE TABLE Customers ( CustomerID INT, FirstName VARCHAR(25), LastName VARCHAR(25) ,StreetAddress VARCHAR(50), City VARCHAR(50), State VARCHAR(25), ZipCode INT, Telephone VARCHAR(15), PRIMARY KEY(CustomerID) ); SIDE NOTE: I have 2 codio tabs, so I used one for testing and the other for this assignment. b. A table named Orders to store order information with a primary key of Order ID and foreign key of Customer ID i. Provide the SQL commands you ran against MySQL to successfully complete this step.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help