Question: Use the PetOwners create script to answer these questions. We will use the below area to write our test SQL . * * * *

Use the PetOwners create script to answer these questions.
We will use the below area to write our test SQL.
******************/
/*1) How would you add an age attribute (integer)
to the Pets table? */
/*2) Luma was adopted. How would we remove her record from the Owns table?*/
/*DELETE*/
/*3) How would you create a new DogBreeds table? */
/*4) How would you insert Pug to the DogBreeds table? */
/*5) How would you show the rows of the DogBreeds table to make sure you
inserted Pug successfully? */
/*6) How would you remove the DogBreeds table? */
/*7) Show which breedID has the most pets. */
/*8) Show which pet owner has the highest ID number. */
/*9) Show the Pets in alphabetical order by Name */
/*10) What are the breeds of all the pets? */
/*11) Bonus! How many pets do each owner have? */

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!