Question: Please Help, I ' m having trouble getting the right result, and I ' m not sure where I ' m going wrong. After creating

Please Help, I'm having trouble getting the right result, and I'm not sure where I'm going wrong.
After creating the tables, use the correct commands to describe them. You'll 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.
A. describe Employee;
B. Write the correct command to describe the Branches table
Insert the following records into the Employee table (with support). 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.
A. 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);
B. 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 (without support).
A. Gwen Johnson: Employee ID =103, DEPARTMENT_ID =4, Classification = NULL, Status = Full-Time, SALARY =40000
B. Michael Jones: Employee ID =104, DEPARTMENT_ID =4, Classification = Non-Exempt, Status = Full-Time, SALARY =90000
C. 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)
D. Type the command select* from Employee; and take a screenshot of it to validate this step.
E. 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 1 and 4.
F. 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.
A. Select First_Name, Last_Name, Employee_ID, Department_ID from Employee;
 Please Help, I'm having trouble getting the right result, and I'm

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!