subject

Overview To complete this assignment, you will work in the Codio virtual lab environment to create tables similar to the ones that you saw in the previous activity.
Prompt
To begin, go to your Codio virtual lab environment and start a new terminal session. Once there, perform the steps below to complete this activity. The commands you see, or are asked to write, must all be entered manually. To validate that the commands you have written work, capture screenshots of the results and place them in a document for submission. Each screenshot should be around one quarter of a page.
Connect to the database you created and named in Module One (for example, Jetson). Type after the prompt mysql>
use (table you named);
Example: mysql> use Jetson;
Create the Employee table using the SQL statement shown here. Press Return after each line.
CREATE TABLE Employee (
Employee_ID SMALLINT,
First_Name VARCHAR(40),
Last_Name VARCHAR(60),
Department_ID SMALLINT,
Classification VARCHAR(10),
STATUS VARCHAR(10),
Salary DECIMAL(7,2));
Create the Branches table. Fill in the missing characters or punctuation in the incomplete statement shown below to complete this action.
CREATE Branches (
Department_ID SMALLINT,
Department_Name )
After creating the tables, use the correct commands to describe them. You will only be given commands to describe one of the tables and must complete the same action for the second one on your own. Validate your work with a screenshot.
describe Employee;
Write the correct command to describe the Branches table
Insert the following records into the Employee table. Each line going from left to right is a record. Each line going from top to bottom is a column. Validate your work with a screenshot.
INSERT INTO Employee VALUES (100, 'John', 'Smith', 1, 'Exempt', 'Full-Time', 90000), (101,'Mary','Jones',2,'Non-Exempt', 'Part-Time',35000), (102,'Mary','Williams',3,'Exempt',' Full-Time',80000);
Type the command select* from Employee; and take a screenshot of it to validate this step.
Insert the following records into the Employee table for Gwen Johnson and Michael Jones by writing the correct SQL commands on your own.
Gwen Johnson: Employee ID = 103, DEPARTMENT_ID = 4, Classification = NULL, Status = Full-Time, SALARY = 40000
Michael Jones: Employee ID = 104, DEPARTMENT_ID = 4, Classification = Non-Exempt, Status = Full-Time, SALARY = 90000
Insert your name into the table to verify and prove your work. (Your First and Last Name, or a nickname): Employee ID = 105, DEPARTMENT_ID = 1, Classification = Non-Exempt, Statues = Full-time, SALARY = (Choose a value between 50000 and 99000)
Type the command select* from Employee; and take a screenshot of it to validate this step.
Insert records for a musician, athlete, or other famous character of your choice. Make sure to enter information for all of the fields listed in this table. The Department_ID must be a number between one and four.
Write the correct command to prove that you’ve successfully completed this step, and validate it with a screenshot.
Select the fields of last name, first name, and department id from the table. Validate your work with a screenshot.
Select First_Name, Last_Name, Employee_ID, Department_ID from Employee;

ansver
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 19:30, 710jonathan
The following is an excerpt from a slide presentation. today we will inverse operations solving equations using inverse operations solving inequalities using inverse operations from which part of the presentation does the slide most likely come from? a. introduction b. outline c. body d. conclusion
Answers: 1
image
Computers and Technology, 23.06.2019 11:00, shawn20034
This chapter lists many ways in which becoming computer literate is beneficial. think about what your life will be like once you’re started in your career. what areas of computing will be most important for you to understand? how would an understanding of computer hardware and software you in working from home, working with groups in other countries and contributing your talents.
Answers: 1
image
Computers and Technology, 24.06.2019 01:30, quintinlarrieu
How would you cite different books by the same author on the works cited page? moore, jack h. folk songs and ballads. salem: poetry press, 1999. print. moore, jack h. ballads in poetry – a critical review. dallas: garden books, 1962. print. moore, jack h. folk songs and ballads. salem: poetry press, 1999. print. –––. ballads in poetry – a critical review. dallas: garden books, 1962. print. moore, jack h. ballads in poetry – a critical review. dallas: garden books, 1962. print. moore, jack h. folk songs and ballads. salem: poetry press, 1999. print. moore, jack h. ballads in poetry – a critical review. dallas: garden books, 1962. print. –––. folk songs and ballads. salem: poetry press, 1999. print.
Answers: 2
image
Computers and Technology, 24.06.2019 04:30, littledudefromacross
Write and test a python program to find and print the largest number in a set of real (floating point) numbers. the program should first read a single positive integer number from the user, which will be how many numbers to read and search through. after reading in all of the numbers, the largest of the numbers input (not considering the count input) should be printed.
Answers: 1
You know the right answer?
Overview To complete this assignment, you will work in the Codio virtual lab environment to create...

Questions in other subjects: