DAD 220 Module Three Major Activity Template

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Mechanical Engineering

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by MagistrateCaterpillarMaster1120

DAD 220 Module Three Major Activity Template 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. CREATE SCHEMA Quantigration_RMA SHOW SCHEMAS; 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:

CREATE TABLE Customers CustomerID INT PRIMARY KEY 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. CREATE TABLE Orders OrderID INT PRIMARY KEY FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)

c. A table named RMA to store RMA information with a primary key of RMA ID and foreign key of Order ID i. Provide the SQL commands you ran against MySQL to successfully complete this step. CREATE TABLE RMA RMAID INT PRIMARY KEY FOREIGN KEY (OrderID) REFERENCES Orders(OrderID) 3. Manually add 10 records into the Customers table . For now, you can make up data. In a later assignment, you will use the CSV files provided to fill in all three tables.

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

4. You’ve been asked to establish a database view called Collaborators based on the Customers table. Create the Collaborators View from the existing Customers table by using the SQL command below to say "Collaborators". The view should show all instances of "Customer" renamed as "Collaborator". Execute the following statements and provide one or more supporting screenshots showing the database view. a. The following command is partially complete. Fill in the missing information in the brackets to complete then command and run it correctly: CREATE VIEW Collaborator AS SELECT CustomerID AS CollaboratorID [Enter in the correct column names from the Customer table that you want to change in the Collaborator table] FROM Customers; b. DESCRIBE Collaborator; c. SELECT * FROM Collaborator LIMIT 5;