PLEASE HELP. PLEASE SHOW ALL WORK. THANKS! Use the following tables and sample d

Question

PLEASE HELP. PLEASE SHOW ALL WORK. THANKS!

Use the following tables and sample data for your answers to the questions in this assignment. (Please note that the tables have already been normalized.) Use MS SQL Server Management Studio to write and test your SQL statements. When you are finished, put all of your SQL statements into a single.sql script file. You may use comments to mark "Question 1", etc.. PET OWNER (OwnerlD, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName, PetType, PetBreed, PetDOB, OwnerlD) FIGURE 3-1 PET OWNER Data OwnerID OwnerLastName OwnerFirstName OwnerPhone OwnerEmail 555-537-8765 Marsha Downs@somewhere.com 555-537-7654 Richard James@somewhere.com 555-537-6543 Liz Frier@somewhere.com Frier Trent Liz Miles.Trent@somewhere.com FIGURE 3-19 PET Data PetBreed Std. Poodle PetType PetDOB 27-Feb-11 01-Feb-12 17-Jul-10 05-May-11 06-Jun-09 PetID PetName OwnerID Teddy AJ Cedro Wooley Buster Std. Poodle Collie Mix Unknown Unknown Border Collie 6 11-Dec-08

Explanation / Answer

--4
SELECT * FROM PET_OWNER WHERE OwnerID=1;
SELECT * FROM PET_OWNER WHERE OwnerID=2;
SELECT * FROM PET_OWNER WHERE OwnerID=3;
SELECT * FROM PET_OWNER WHERE OwnerID=4;
--5
ALTER TABLE PET
ADD COLUMN Location VARCHAR(20);
--6
UPDATE PET SET Location='Fullerton';
--7
UPDATE PET SET Location='Brea' WHERE PetType='Cat';
--8
ALTER TABLE PET
MODIFY COLUMN PetBreed DEFAULT NULL;
DELETE FROM PET WHERE PetBreed='Unknown';
--9
DROP TABLE PET;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.