Crystal_Hicks_Assign3
docx
keyboard_arrow_up
School
American Military University *
*We aren’t endorsed by this school
Course
222
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
3
Uploaded by CaptainKoala4253
Crystal Hicks
Info222 March 24, 2024
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
CrystalHicks711
(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 "CrystalHicks711"
(EmployeeID, SSN, fName, lName, Position, Salary, PhoneNum)
values(300, '444-44-0607', 'Sally', 'Smith', 'Manager', 46500.00, '303-999-0000');
Repeat the above step for each row to be inserted
Task 3
Use the Select * command to list all fields for all records in the table.
select * from Chrisjacobs711;
Task 4
Use a Select command to list the EmployeeID, fName, lName, Position, and Salary fields for all
employees with a last name of Smith.
select EmployeeID, fName, lName, Position, Salary from CrystalHicks711
where lName = 'Smith';
Task 5
Use a Select command to list the EmployeeID, fName, lName, Position, Salary and PhoneNum fields for all employees with a salary greater than 20000.
select EmployeeID, fName, lName, Position, Salary,
PhoneNum from CrystalHicks711
where Salary > 20000;
Task 6
Use a Select command to list the EmployeeID, fName, lName, Position and Salary fields for all Employees with a Salary greater than 30000 and less than 45000.
select EmployeeID, fName, lName, Position, Salary from CrystalHicks711
where Salary > 30000 and Salary < 45000;
Execute the commands and capture your results.
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