Burr_SQL

.docx

School

American Public University *

*We aren’t endorsed by this school

Course

222

Subject

Information Systems

Date

Jan 9, 2024

Type

docx

Pages

Uploaded by CaptainScorpionPerson1033

Week 3 Database Exercise Sunee Burr American Military University INFO222 Dr. Courtney Bolden November 26, 2023

 Task 1 – Use the SQL Create command to create a table with the below specifications or use MS Access . The table name should be your last name plus a unique number Use the following to name each field (column); with a matching data type create table SuneeBurr00 (EmployeeID number(10), SSN varchar(11), fName varchar(12), lName varchar(12), Position varchar(12), Salary number(8,2), PhoneNum varchar(12));

 Task 2 – Use the Insert command to insert the records / data below: Submit one record at a time (easier to correct any mistakes) insert into "SuneeBurr00" (EmployeeID, SSN, fName, lName, Position, Salary, PhoneNum) values(100, '111-11-0607', 'John', 'Smith', 'Manager', 35000.75, '800-350-0000'); Repeat the above step for each row to be inserted

insert into "SuneeBurr00" (EmployeeID, SSN, fName, lName, Position, Salary, PhoneNum) values(200, 333-44-0607, 'John', 'Jones', 'Associate', 25000.00, '202-999-0000'); insert into "SuneeBurr00" (EmployeeID, SSN, fName, lName, Position, Salary, PhoneNum) values(300, '444-44-0607', 'Sally', 'Smith', 'Manager', 46500.00, '303-999-0000'); insert into "SuneeBurr00" (EmployeeID, SSN, fName, lName, Position, Salary, PhoneNum) values(400, '123-45-6789', 'Sunee', 'Burr', 'CEO', 36900.00, '678-999-8212');

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