Question: Create a Word document that includes the SQL query code used to execute the steps below in the AdventureWorksDW2016CTP3 database. Write a SELECT statement to

Create a Word document that includes the SQL query code used to execute the steps below in the "AdventureWorksDW2016CTP3" database.

Write a SELECT statement to access the Employee, Job Title, Vacation Hours, and Sick Hours information.

Schedule a job to run on the first day of each month and title it "PTO/SICK Report."

Take a screenshot of the report setup screen to illustrate how you designed the report. Paste the screenshot into a Word document as record of the report.

Create a SQL transaction that manages the scheduling of PTO/SICK Report as well as a periodic database backup.

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!

Create a Word document that includes the SQL query code used to execute the steps below in the "AdventureWorksDW2016CTP3" database. Write a SELECT statement to access the Employee, Job Title,...

Create a Word document that includes the SQL query code used to execute the steps below in the " AdventureWorksDW2016CTP3 " database. --Write a SELECT statement to access the Employee, Job Title,...

From the AdventureWorks SQL Server test relational database: The sales manager frequently receives customer feedback in the form of sales representative compliments from customers. However, customers...

Its using the database Adventureworks CTP3 if you can be as detailed as you can with what database I can provide to make this easier. In this assignment, students will use the AdventureWorks CTP3...

Hello everyone Im having some difficulty with this question and have very little of the code written before I ran into some problems , using adventureworks 2014 database with SQL Create a Word...

Due to warehousing limitations, inventory over 800 units needs to be sent to an external storage site and tracked separately. You have been asked to monitor when an update will exceed this boundary...

Using AdventureWorks2016CTP3 Due to warehousing limitations, inventory over 800 units needs to be sent to an external storage site and tracked separately. You have been asked to monitor when an...

The purpose of this assignment is to examine the use of aggregate functions, analyze queries that contain NULL values, and use CASE logic to resolve the data and arrive at a solution. For this...

Goals Explore triggers and stored procedures within a database, see how they work and how they are engaged. Create your own and see what happens. Instructions Use the same database as Lab 2 (see Lab...

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

In the late 1990s, the city of Santa Monica, California, made it illegal for banks to charge people ATM fees. As you probably know, its almost always free to use your own banks ATMs, but theres...

A flat, triangular piece of metal with rounded corners has a net positive charge on it. Sketch the charge distribution on the surface and the electric field lines near the surface of the metal...

The income an investor receives in some period divided by the value of the security at the beginning of that period is known as _ _ _ _ _ yield. capital - gains expected current realized

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. What measures in addition to turnover and employee complaints could be used to evaluate the effectiveness of G4Ss training initiatives?

4. Create a briefing for division managers showing the advantages and disadvantages of using MOOCs. Use websites, including www.td.org, www.coursera.org, and www.mooc-list.com.

LO3 Identify three types of analyses used to determine training needs.