Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
How would you add an age attribute integer
to the Pets table?
Luma was adopted. How would we remove her record from the Owns table?
DELETE
How would you create a new DogBreeds table?
How would you insert Pug to the DogBreeds table?
How would you show the rows of the DogBreeds table to make sure you
inserted Pug successfully?
How would you remove the DogBreeds table?
Show which breedID has the most pets.
Show which pet owner has the highest ID number.
Show the Pets in alphabetical order by Name
What are the breeds of all the pets?
Bonus! How many pets do each owner have?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started