Question: Write SQL Statements to (1) create the BREED table, (2) insert the data in Figure3-20 into the BREED table, (3) alter the PET_3 table so

Write SQL Statements to (1) create the BREED table, (2) insert the data in Figure3-20 into the BREED table, (3) alter the PET_3 table so that PetBreed is a foreign key referencing BreedName in BREED, and (4) to display the last name, first name, and email of any owner of a pet that has an AverageLifeExpectancy value greater than 15 using a subquery.

PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail)

PET (PetID, PetName, PetType, PetBreed, PetDOB,?OwnerID)

FIGURE 3-18| PET_OWNER Data OwnerID OwnerLastName OwnerFirstName OwnerPhone OwnerEmail 1 Downs Marsha 555-537-8765 Marsha.Downs@somewhere.com 2 James Richard 555-537-7654 Richard.James@somewhere.com 3 Frier Liz 555-537-6543 Liz.Frier@somewhere.com 4 Trent Miles Miles.Trent@somewhere.com

Step by Step Solution

★★★★★

3.40 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

For Microsoft Access Access SQL does not support the m n extension of the Numeric data type See Does Not Work with Microsoft Access ANSI89 SQL on p 12... View full answer

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 Database Concepts Questions!

Write an SQL statement to display the name and breed of all pets sorted by PetName. PET_OWNER ( OwnerID , OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET ( PetID , PetName, PetType,...

Create a referential integrity constraint on OwnerID in PET. Assume that deletions should cascade PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,...

Create a referential integrity constraint on OwnerID in PET. Assume that deletions should not cascade. PET_OWNER (OwnerID, OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) PET (PetID, PetName,...

Write SQL statements to (1) create the BREED table, (2) insert the data in Figure 3-20 into the BREED table, (3) alter the PET 3 table so that PetBreed is a foreign key referencing BreedName in...

Perform all the following steps in order. ***WRITE SQL QUERIES TO: 1. Create a junction table with artist_id and rec_id as fields. Call this new table rec_artist. Create a foreign key constraint for...

Perform all the following steps in order. Write (and run) SQL queries to: 1. Create a junction table with artist_id and rec_id as fields. Call this new table rec_artist. Create a foreign key...

I need help solving a lab in mysql "Database 1" Lab Participation Due Date: Thursday, 20 April 2023 The Sample Tables Note: - Primary Key of EMP Table is EMPNO and Foreign Key is DEPTNO that...

- ---------Create the Database---------- create database Sample2312; -- -----Select thet database for use----- use Sample2312; -- ---------Create the tables------------ CREATE TABLE Branch ( branchNo...

-- ---------Create the Database---------- create database Sample2; -- -----Select thet database for use----- use Sample2; -- ---------Create the tables------------ CREATE TABLE Branch ( branchNo...

create database Sample2; -- -----Select thet database for use----- use Sample2; -- ---------Create the tables------------ CREATE TABLE Branch ( branchNo CHAR(4) NOT NULL, street VARCHAR(25) NOT NULL...

Researchers introduced prions into normal mice and mice that were genetically predisposed to develop a disease resembling Alzheimer's. Explain why the Alzheimer's-prone mice displayed symptoms of the...

Describe the advantages and disadvantages of chronological and functional resume formats. Do you think a combination resume would be an appropriate format for your new resume? Explain why or why not.

The initial outlay for a new project is an example of an opportunity cost. True False

Jackson and Ashley Turner (both 45 years old) are married and want to contribute to a Roth IRA for Ashley. In 2016, their AGI is $186,000. Jackson and Ashley each earned half of the income. a) How...

Explain how the OLAP report in Figure 12-23 differs from that in Figure 12-22.

Based on Figure 12-1, what is the relationship between 1 MB of storage and 1EB of storage?

As illustrated in Figure 12-33, what is column family database storage, and how are column family database storage systems organized? How do structured storage systems compare to RDBMS systems? Name:...

A. Set up an amortization schedule for a $30,000 loan to be repaid in equal installments at the end of each of the next 20 years at an interest rate of 10 percent. What is the annual payment? How...

I am stuck trying to solve both questions The current price of a stock is $50.02 and the annual effective risk-free rate is 2.4 percent. A call option with an exercise price of $55 and one year until...

Sonia Gomez, a 45-year-old woman, wishes to accumulate $250,000 over the next 15 years to supplement the retirement programs that are being funded by the federal government and her employer. She...