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

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

- In the image above, I was able to create this “Orders” table using the following: CREATE TABLE Orders ( -> OrderID INT, -> CustomerID INT, -> SKU VARCHAR (20), -> Description VARCHAR(50), -> PRIMARY KEY(OrderID) -> ); 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.

- In order to create the “RMA” table, the following was imputed: CREATE TABLE RMA ( -> RMAID INT, -> OrderID INT, -> Stop VARCHAR(50), -> Status VARCHAR(15), -> Reason VARCHAR(15), -> PRIMARY KEY(RMAID) -> ); - Additionally, I also showed how each table would show on screen:

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. - With the commands that were chosen in the “Customers’ table, the values were inserted as intended as seen in the image above. 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.

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

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; - As seen above, I have highlighted the correct input to get the intended results. I had some issues with going back and forth whenever I forget a comma, so it had to be done this way. As for the values inputted, nothing much in this regard, instructions were pretty clear fortunately. It can be shown in the picture that everything came off as intended thanks to the little guide at the from the Activity and Rubric. Always appreciated.