Assessment Description
The purpose of this assignment is to practice building a reporting project.
For this assignment, you will use the SQL Server Data Tools (SSDT) referenced in the topic Resources and Microsoft Visual Studio, which is part of the SQL Server Developer Edition. Start the VM for this assignment and inside the VM, click Start, type SSDT (to open Visual Studio 2017 [SSDT]).
The purchasing manager has requested you create a report that provides a quick list of active preferred vendors and their credit ratings.
Please note that when SQL queries are run, results are generated in the form of data.
To complete this assignment, create a single document containing the SQL query code used to explore the database tables to create the reports, as well as answers to and screenshots of the reports designated in the prompts below.
1. Create a report with proper formatting that displays the vendor and credit information requested using the “Purchasing.Vendor” table in the AdventureWorks2017 database. Include the “Name,” “Credit Rating,” “Preferred,” and “Active” fields. Capture a screenshot of the report and of the code that created it.
2. Further refine the report you created in step 1 by vendors that currently have no orders. Use the “Purchasing.ProductVendor” table. Include “Min Order Qty,” “Max Order Qty,” and “On Order Qty.” Capture a screenshot of the report and the code that created it.
3. In a minimum of 250 words, explain which components of SQL Server exist to deliver reports.
4. In a minimum of 250 words, explain how teamwork supports the design and development of a corporate information system, and how the corporate information system supports the organization.
Submit the following in a single document compatible with the digital classroom (e.g., Microsoft Word). Include a one-line description above each screenshot.
· A screenshot of the SQL query code that produced the first report
· A screenshot of your first report
· A screenshot of the SQL query code that produced the refined report
· A screenshot of your second report
· Your paragraph explaining the report components
· Your paragraph explaining teamwork’s influence
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
Rubric Criteria
Expand All Rubric CriteriaExpand All
Report and Its Code, Provides Screenshots with One-Line Descriptions
19.5 points
Refined Report and Its Code, Provides Screenshots with One-Line Descriptions
19.5 points
Components of SQL Server That Exist to Deliver Reports
9.75 points
Teamwork in Design, Development, and the Organization
9.75 points
Mechanics of Writing
3.9 points
Format/Documentation
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
