Question: Item # Details (unless specified below, all fields are typed to hold string or character values) 1 The SQL statement requesting all columns and all

Item #

Details

(unless specified below, all fields are typed to hold string or character values)

1

The SQL statement requesting all columns and all rows. The asterisk represents all and there is no limiting value for rows or records, so we get all rows.

2

A useful idea of the number of rows or records in the table (91)

3

CustomerID is possibly numeric but might just as easily be a character or string value. It is the unique identifier for each customer. This is called the Primary Key (PK).

4

CustomerName is the name of the business/organization.

5

ContactName is the first and last name of each customer contact person. There may be times when creating a database/table where we separate first name and last name into separate fields.

6

Address is the street address.

7

City -- you guessed it -- where the business is located (is, of course, part of the address, but is a separate field)

8

PostalCode of where the business is located (is, of course, part of the address, but is a separate field)

9

Country where the business is located (is, of course, part of the address, but is a separate field)

1. Use example item #3 above and: a. Create and copy/paste the SQL command to act the very same way but on the Employees table b. How many records (rows) total are in the Employees table? _______ c. Recreate the descriptive table and detail the column names and characteristics 2. Use example item #8 above using OrderDetails and answer: a. How many records are there with 10 or fewer items? ___________ b. Provide a copy/paste of the correct SQL command 3. Using item #8 again, provide a copy/paste of the correct SQL command that displays only the Order ID and Quantity for orders where Quantity is exactly 100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!