Open the SQL Server Management Studio. Make the Object Explorer about 1/4^th the size of the Query window.

Close the Properties Window and the Output pane.

Display only the columns asked for in the problem.

All columns in the result set should have a name.

All JOINs should be explicit JOINs.

Do NOT limit the number of rows with the TOP clause. Manipulate the size of the results window to show at least the first ten rows and the yellow status bar with the total number of rows.

Size the Management Studio window so it is wide enough to display all the columns with no extra white space on the right.

Use +< PrintScr> or use the Snipping Tool to capture the Management Studio window only and not the full desktop. Be sure the yellow status bar is visible at the bottom showing the number of rows.

Keep the AP ERD (Entity Relationship Diagram) handy!

Paste a slide even if there are errors in the query. No partial credit for an empty or missing slide.

You will need 9 slides: 1 title slide and 8 blank slides for the screen shots of your solution query and results.

The title slide should have your full name in the title section and the following text in the subtitle section: Test 1, Spring 2019, todays date

SAVE AS LastName.Test1.pptx where LastName is YOUR last name.

1. In the Object Explorer, make the AP database and all its tables visible. Use the slider at the bottom of the Object Explorer to shift the contents toward the left, so more of the table names are visible.

2. Answer this question using the Object Explorer: which table has a composite primary key? Show the table name and the columns in the correct table.

3. Display the Vendors name and phone number only if the vendor has the toll-free area code (800). The correct solution has 21 rows. Show the full query and at least the first 10 rows.

4. Display the Vendors name, Location (City, State ZIP in one column with appropriate spaces and punctuation), Phone number, and Contact (firstname lastname) for Vendors with a telephone number listed. The correct solution has 97 rows. Show the full query and at least the first 10 rows.

Display the results in the example format below in ZIP Code order:

Vendor	Location	Phone	Contact
Florida State College at Jacksonville	Jacksonville, FL 32246	(904) 646-2385	Pamela Brauda

5. Display the Invoice ID, Vendor ID, Invoice number, and balance due for all the invoices that have a balance due greater than zero. Display in VendorID order. The correct solution has 11 rows. Show the full query and at least the first 10 rows.

6. Display the VendorName and InvoiceTotal for the Vendor with the largest InvoiceTotal. Do NOT use the MAX function in Chapter 5. The correct solution has 1 row.

7. Display the Vendor Name and ALL of the Account numbers and Account Descriptions from the General Ledger Accounts table. This is a straightforward query, but it can be a little tricky, so please pay attention. You should get 166 rows when executed correctly. Show the full query and at least the first 10 rows.

8. Display the VendorName, the InvoiceTotal, the InvoiceLineItemDescription, and the AccountDescription for all invoices that have a zero balance due, theInvoiceLineItemDescription is the same as the AccountDescription, and the InvoiceTotal is greater than 500.00. Display in InvoiceTotal order from smallest to largest. Use the alias LineItems for the InvoiceLineItems table. The correct solution has 10 rows. Show the full query and all the rows.