Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create the following statements against the AdventureWorks 2 0 1 9 database in the eLumin environment. Your answers should be submitted as one file with

Create the following statements against the AdventureWorks2019 database in the eLumin environment. Your answers should be submitted as one file with the number of records affected by each statement.
A Delete statement to remove all records from the Person.Person table where the LastName starts with ja and they have a phone number in the 703 area code.
An Insert statement to add 10 more records to the Sales.Customer table.
An Update statement to change the SafeytStockLevel to 800 for records in the Production.Product table that have a size >=40 and <=52.
An Update statement to change the birth year to 2021, the SickLeaveHours to 10 for all records in the HumanResources.Employee tables where the Job Title contains Manager and the MaritalStatus is M.
Upload a file to Canvas containing scripts for all the above, be sure the filename contains your full name and has a .sql extension.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Oracle Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions

Question

Why is management of technology important?

Answered: 1 week ago

Question

Why is ordering important in a sequential filing system?

Answered: 1 week ago