Here is the link to my complete ddl escapades:
http://sqlfiddle.com/#!9/d7319
In case the link doesn't work, here's a screenshot of my update and delete statements:
https://gyazo.com/8cc40eb41d987e916203596ab36c14f7
Here's the specific ddl I used for my UPDATE/DELETE requirement (just a segment of full ddl):
UPDATE ProductsSET ItemLocation='04-25-00-00', NumberInStock='96'
WHERE ItemNumber='QWER1234';
UPDATE OrdersSET ItemsOrdered='QWER1234, TYUI4321', TotalCost='32.42'
WHERE OrderNumber='123456789';
UPDATE CustomersSET PhoneNumber='789-456-1230'
WHERE CustomerID='CuSto1234';
DELETE FROM Customers
WHERE CustomerID='CuSto1234' AND LastName='Stove';
DELETE FROM Products
WHERE ItemNumber='TYUI4321' AND ItemLocation='02-34-10-08';
DELETE FROM Orders
WHERE OrderNumber='798465123' AND TimePrinted='2016-05-04 11:01:22';
http://sqlfiddle.com/#!9/d7319
In case the link doesn't work, here's a screenshot of my update and delete statements:
https://gyazo.com/8cc40eb41d987e916203596ab36c14f7
Here's the specific ddl I used for my UPDATE/DELETE requirement (just a segment of full ddl):
UPDATE ProductsSET ItemLocation='04-25-00-00', NumberInStock='96'
WHERE ItemNumber='QWER1234';
UPDATE OrdersSET ItemsOrdered='QWER1234, TYUI4321', TotalCost='32.42'
WHERE OrderNumber='123456789';
UPDATE CustomersSET PhoneNumber='789-456-1230'
WHERE CustomerID='CuSto1234';
DELETE FROM Customers
WHERE CustomerID='CuSto1234' AND LastName='Stove';
DELETE FROM Products
WHERE ItemNumber='TYUI4321' AND ItemLocation='02-34-10-08';
DELETE FROM Orders
WHERE OrderNumber='798465123' AND TimePrinted='2016-05-04 11:01:22';