Answered step by step
Verified Expert Solution
Link Copied!

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.
******************/
/*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

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

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions