NUR 6050-Standalone SQL Interpreter Discussion

ORDER NOW FOR AN ORIGINAL PAPER!!! NUR 6050-Standalone SQL Interpreter Discussion .

Then return to the “Standalone SQL interpreter” found on the http://www.sqlcourse.com/create.html

site (the link is on the left of the Web site page) to enter and submit your SQL commands.

(The SQL interpreter on the sqlcourse2.com page only supports the Select command and uses

predefined tables.)

It is recommended that you submit and execute one SQL command at a time.

For each task below:

a) Label each Task to match the instruction

b) Construct the SQL command (include the text of each command in your formal submission)

c) Paste the SQL command onto the Web site (Standalone SQL Interpreter page)

click on the Submit Query button to execute the command

d) Capture the entire response display (either the Window or the entire screen) and paste it below the

SQL command text

If you have difficultly – send the SQL command text and response capture to the instructor for

assistance

Let’s Begin the SQL Portion of the Exercise:

Task 1 – Use the SQL Create command to create a table with the below specifications

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

EmployeeID 10 numeric digits (no decimal points)

SSN up to 11 characters (SSN = social security number)

fName up to 12 characters

lName up to 12 characters

Position up to 12 characters

Salary 10 maximum numeric digits (including 2 decimal digits)

PhoneNum 12 characters.

Task 2 – Use the Insert command to insert the records / data below:

Submit one record at a time (easier to correct any mistakes)

http://www.sqlcourse.com/create.html
http://www.sqlcourse2.com/select2.html
http://www.sqlcourse.com/create.html
INFO321 WEEK 3 Assignment

Page 2 of 3

100, 111-11-0607, John, Smith, Manager, 35000.75, 800-350-0000

200, 333-22-0607, John, Jones, Associate, 25000.00, 202-999-0000

300, 444-44-0607, Sally, Smith, Manager, 46500.00, 303-999-0000 Standalone SQL Interpreter Discussion

Insert one more record – you determine the content, EXCEPT it must use your name for the first name

(fName) and last name lName), and a Salary of 36900.

Task 3

Use the Select * command to list all fields for all records in the table.

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.

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.

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.

Submit this part of the assignment in a word document. Name your document Last_Name_SQLWeb

(i.e. Smith_SQLWeb).

A description of the most common SQL problems can be found at the end of these instructions.

Contact the instructor with any questions.

Part B Access Database (30%)

Perform the same tasks using MS Access

A) Create the table (same field names and field types as in Part A) Do not worry about specifying

exact field lengths, or decimal points.

No primary key is required.

B) Enter (type) the same data as in Part A

C) Create and Save a Query created for Task 3 above with the name Query C

D) Create and Save a Query created for Task 4 above with the name Query D

E) Create and Save a Query created for Task 5 above with the name Query E

F) Create and Save a Query created for Task 6 above with the name Query F

Name the Access database Last Name_Assignment3 (i.e. Smith_ Assignment3).

Ensure you attach and submit BOTH files (a word document for Part A and an Access

database for Part b)

EmployeeID SSN fName lName Position Salary PhoneNum

100 111-11-0607 John Smith Manager 35000.75 800-350-0000

ORDER NOW FOR AN ORIGINAL PAPER!!! NUR 6050-Standalone SQL Interpreter Discussion .

200 333-22-0607 John Jones Associate 25000.00 202-999-0000

300 444-44-0607 Sally Smith Manager 46500.00 303-999-0000

INFO321 WEEK 3 Assignment

Page 3 of 3

Common SQL problems

A) Table and field names are case sensitive, and should not include spaces.

B) Another common error is “Invalid character used in command” – this means you have used an

illegal character. Character fields should be enclosed in single quote marks. Sometimes an incorrect

single quote is generated by Word (this seems to be associated with the keyboard used). You can

determine the “value” of a character in Word by selecting it and then pressing the ALT + X (the letter x)

keys. That will display the value of the character. It should have a value of 0027. If you have the wrong Standalone SQL Interpreter Discussion

value – go to the SQL Web site an copy one of the single quotes from an “Example” and use that in your

Word document

C) Declaring a field to be numeric, and using single quotes in a Select statement (for the field’s value)

seems to generate a Something Went Wrong error message, or even worse it may blank the field. I

suggest you double check whether you are using character or numeric fields – and ensure the Select