DAD 220 Module One Lab Template

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

200

Subject

Mechanical Engineering

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by ConstableSalamander3199

Report
DAD 220 Module One Lab Template Overview To complete this lab, go to your Codio virtual lab environment and start a new terminal session. Once there, perform the steps below to complete this activity. Manually enter any commands you are asked to write. At the end of each step in the activity, replace the bracketed text with a screenshot, brief explanation, or both, as indicated. Size each screenshot and its explanation to fit about 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 an example of how screenshots for your assignment should look. Create a Database 1. Create a new database and update the name to your last name; then connect to it. Type the following commands after the prompt mysql>: A. CREATE DATABASE last_name_here; i. For example, if your database is going to be named Jetson, then substitute "Jetson" for "last_name_here". ii. Press Enter . B. SHOW DATABASES; i. Press Enter . ii. You should see a listing of all of the databases (or schemas) in MySQL, including the one you just created. C. USE last_name_here; i. Press Enter . ii. Substitute the name of your database (for example, "Jetson") for "last_name_here". This SQL statement connects your MySQL session to the database you just created. D. Capture a screenshot of the results of this action. [Insert screenshot here.] 2. Create a table called tb2 and list out the tables in your database with one field by typing the following commands after the prompt mysql>: A. CREATE TABLE tb2 (user_id VARCHAR( 50 )); i. Press Enter . B. SHOW TABLES; i. Press Enter . C. DESCRIBE tb2; i. Press Enter . D. Capture a screenshot of the results of this action. [Insert screenshot here.]
3. Add a second field into the table and describe it . Do this by entering the following commands after mysql>: A. ALTER TABLE tb2 ADD newfield VARCHAR(25); i. Press Enter . B. DESCRIBE tb2; i. Press Enter . C. Capture a screenshot of the results of this action. [Insert screenshot here.] 4. Organize your work to match the screenshot example and guidelines in the example document linked in the Supporting Materials section of the guidelines and rubric. Your submission should show that your work is original and the commands you have written for this lab worked correctly.
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