Instructions *** Where it state replace name with your own name, my name to use

Instructions
*** Where it state replace name with your own name, my name to use is Clarke88.***
CO3: Assess the process and methodologies for designing databases.
Download the attached instruction details.
The objective is to perform the following tasks in SQLite or MS Access (if this is a more comfortable database for you). Students will Create a table, Insert data into that table, and use Select commands to select and display data from the table.
Submit one Word document, which includes the text of the SQL commands, and screen captures of the commands executed in SQLite or MS Access (if this is a more comfortable database for you).
Hi Class –
To assist in completing the week 3 assignment, Here are the steps and commands that should be executed (one statement at a time) listed below. Where you see the tablename – Chrisjacobs711 – please replace with your own tablename.
The best approach is to cut and paste the syntax (in bold below) into a work document, edit the statement with your tablename, and paste into SQLite or executed in MS Access.
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
Chrisjacobs711
(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 “Chrisjacobs711”
(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
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 Chrisjacobs711
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 Chrisjacobs711 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 Chrisjacobs711 where Salary > 30000 and Salary < 45000; Execute the commands and capture your results.