SQL Triggers: Start the VM for assignment six. Inside the VM, click Start, type SSMS (to open SQL Server Management Studio), Select Database Engine as the server type, and then click connect. Select Databases, then right click on the most current version of AdventureWorks database to create a new query for this assignment.
Part 1:
Automating business procedures and automatically maintaining data integrity and consistency are critical in modern business environment. One of the most critical business procedures is proper inventory management. For example, you want to make sure that your current inventory has enough product availability that can support your product sales. Another example is to ensure that your product order is written to the supplier whenever the products inventory count drops below a certain number.
Run the attached script “Products.txt” in your AdventureWorks database then create a Trigger that address the following business logic:
Automatically evaluate the Products Quality On Hand value. If the value of the Products Quality On Hand is below the minimum quantity of that product, then update the Product Reorder value to 1 which means Yes to order more from the supplier.
Submit a Word document (with screenshots) that captures the following:
1. The successful creation of the Products table
2. Data from the Products table. Hint: Run a SELECT statement
3. The successful creation and testing of the trigger
Part 2:
Create an Audit log Trigger. Triggers can be used to capture and log data changes in tables. Your manager wants to be notified each time a price changes for product(s). the report/table should show the old and new price the product(s), the date of the change, and the product ID. Hint: Create a new table named it audi_log, and create a trigger to insert the required data into this table.
Submit a Word document with screen shots that captures the successful creation and testing of this trigger.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
You are not required to submit this assignment to LopesWrite.
Benchmark Information
This benchmark assignment assesses the following programmatic competencies:
Bachelor of Science in Business Information Systems
Bachelor of Science in Applied Business Information Systems
1.3 Demonstrate foundational database management, programming skills, and system administration skills to build business information systems.
5.2 Demonstrate foundational database management, programming skills, and system administration skills to build business information systems.
Topic 6 Template that you follow (1)
Answer Preview: Benchmark – SQL Triggers – SYM 400
