2-4 Lab_Updating Tables

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Business

Date

Apr 3, 2024

Type

docx

Pages

5

Uploaded by mrsjdsmith15

Report
DAD-220 Southern New Hampshire University Jessica DelValle-Smith October 30, 2023 2-4 Lab: Updating Tables 4. 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
5. 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. INSERTEmply Type the command select* from Employee; and take a screenshot of it to validate this step.
6. 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.
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