Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

AWS Certified Database Study Guide Specialty DBS-C01 Exam

Authors: Matheus Arrais, Rene Martinez Bravet, Leonardo Ciccone, Angie Nobre Cocharero, Erika Kurauchi, Hugo Rozestraten

1st Edition

1119778956, 978-1119778950

More Books

Students also viewed these Databases questions

Question

What is the Ricardian equivalence problem?

Answered: 1 week ago

Question

Methods of Delivery Guidelines for

Answered: 1 week ago