dad 220 mod 2 lab

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Information Systems

Date

Feb 20, 2024

Type

docx

Pages

5

Uploaded by melgal14

Report
Attempting to connect to a database. Put in mysql the pressed enter then typed in use galvan for database.
Create Branches ( Department_ID Smallint Department _Name VARCHAR(20))’
Des Employee; Des Branches;
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
1. Employee work status. 2. 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 into Employee into (Employee_ID, First_Name, Last_Name, Department_ID, Classification, Status, Salary) Values(104,’Micheal’ , ‘Jones’,4,’Non_Exmempt’, ‘Full-Time’ 90000);

Related Documents

Assignment 8 BB.docx
manage network security.pdf
CCJS 421 .pdf
CCJS 421 -Discussion.pdf
CCJS 421 - Discussion 6.pdf
CCJS 421 - Discussion 1.pdf
Project One Project Plan Project Management (1).docx
Notable Security Incident week 7 assign 1.docx
M3P Portfolio Project Ethical Scenario 1.docx
Vincent Cooper CYB 260 Project One Milestone.docx
Vincent_Cooper CYB 250 Stepping Stone One.docx
3.3.docx