Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Execute a query to check if a corresponding record has been inserted into the [Sales].[OrderAudit] table. The AuditTimestamp in [Sales].[OrderAudit] should be the current date

Execute a query to check if a corresponding record has been inserted into the [Sales].[OrderAudit] table.

The AuditTimestamp in [Sales].[OrderAudit] should be the current date and time.

OrderDetails (Sales) orderid productid unitprice qty discount Products (Production) productid productname

OrderDetails (Sales) orderid productid unitprice qty discount Products (Production) productid productname supplierid categoryid unitprice discontinued Categories (Production) categoryid categoryname description Suppliers (Production) supplierid companyname contactname contacttitle address city region postalcode country phone fax Cu Employees (HR) empid lastname firstname title titleofcourtesy birthdate hiredatel address city region postalcode country phone mgrid 8 Orders (Sales) orderid custid empid orderdate requireddate shippeddate shipperid freight shipname shipaddress shipcity shipregion shippostalcode shipcountry Customers (Sales) custid companyname contactname contacttitle address city region postalcode country phone fax Shippers (Sales) shipperid companyname phone OrderDetails (Sales) orderid productid unitprice qty discount Products (Production) productid productname supplierid categoryid unitprice discontinued Categories (Production) categoryid categoryname description Suppliers (Production) supplierid companyname contactname contacttitle address city region postalcode country phone fax Cu Employees (HR) empid lastname firstname title titleofcourtesy birthdate hiredatel address city region postalcode country phone mgrid 8 Orders (Sales) orderid custid empid orderdate requireddate shippeddate shipperid freight shipname shipaddress shipcity shipregion shippostalcode shipcountry Customers (Sales) custid companyname contactname contacttitle address city region postalcode country phone fax Shippers (Sales) shipperid companyname phone

Step by Step Solution

3.26 Rating (149 Votes )

There are 3 Steps involved in it

Step: 1

Here are the SQL scripts for each of the tasks youve described Task 1 Create OrderAudit Table and Trigger 1 Create the SalesOrderAudit table CREATE TABLE SalesOrderAudit AuditID int IDENTITY1 1 PRIMAR... 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

Step: 3

blur-text-image

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

Systems analysis and design

Authors: kenneth e. kendall, julie e. kendall

8th Edition

135094909, 013608916X, 9780135094907, 978-0136089162

More Books

Students also viewed these Programming questions

Question

Differentiate health psychology from behavioral medicine.

Answered: 1 week ago