User Account

All Pages

Write an sql statement to change the petweight column

Assignment Help PL-SQL Programming
Reference no: EM13856386

Write an SQL statement to display the OwnerLastName, OwnerFirstName, and OwnerEmail of any owners of cats. Use a subquery with PET_OWNER and PET_3.

The following table schema is for the BREED table.

BREED(BreedName, MinWeight, MaxWeight, AverageLifeExpectancy)

*MinWeight and MaxWeight should store 1 decimal place.

PetBreed in PET_3 will be a foreign key to the BreedName in BREED.

PET_3(PetID, PetName, PetBreed, PetType, PetDOB, PetWeight, OwnerID)

Write an SQL statement to create the BREED table. Don't forget the foreign key constraint; updates should cascade but deletes should not.

Write an SQL statement to display the OwnerLastName, OwnerFirstName, and OwnerEmail of any owner of a pet that has an AverageLifeExpectancy value greater than 15 using a subquery. The PET_OWNER, PET_3, and BREED tables are below.

Write an SQL statement to display the OwnerLastName, OwnerFirstName, and OwnerEmail of any owners of cats. Use a JOIN. The PET_OWNER and PET_3 tables are below. Do not show duplicates.

Write an SQL statement to display the OwnerLastName, OwnerFirstName, and OwnerEmail of any owner of a pet that has an AverageLifeExpectancy value greater than 15 using a JOIN. The PET_OWNER, PET_3, and BREED tables are below. Do not show duplicates.

Write an SQL statement to display the OwnerLastName, OwnerFirstName, PetName, PetType, PetBreed, and AverageLifeExpectancy for pets with a known PetBreed. Use PET_3. The PET_OWNER, PET_3, and BREED tables are below.

Write SQL statements to add these 3 new rows to the PET_OWNER table. Assume that OwnerID is a surrogate key and the DBMS will provide a value for it.

OwnerID

OwnerLastName

OwnerFirstName

OwnerPhone

OwnerEmail

5

Rogers

Jim

555-232-3456

[email protected]

6

Keenan

Mary

555-232-4567

[email protected]

7

Melnik

Nigel

555-232-5678

[email protected]

Write SQL statements to add these 3 new rose to the PET_OWNER table. Assume that OwnerID is a surrogate key and the DBMS will provide a value for it. However, you do not have a value for OwnerEmail.

Write an SQL statement to change the value of Std. Poodle in BreedName of BREED to Poodle, Std. Assume cascading updates in the PET_3 table. (Try it first without a WHERE clause.)

Write an SQL statement to delete all rows of pets of PetType Cat in the PET_3 table. NOTE, do not use Anteater, as in the book. (Try it first without a WHERE clause.)

Write an SQL statement to add a PetWeight column to the PET table, given that this column allows NULLs. Assume a type of Numeric(4,1)

Write SQL statements to insert the following data into the PetWeight column of the PET table.

PetID

PetName

PetType

PetBreed

PetDOB

PetWeight

OwnerID

1

King

Dog

Std. Poodle

2009-02-27

25.5

1

2

Teddy

Cat

Cashmere

2010-02-01

10.5

2

3

Fido

Dog

Std. Poodle

2008-07-17

28.5

1

4

AJ

Dog

Collie Mix

2009-05-05

20.0

3

5

Cedro

Cat

Unknown

2007-06-06

9.5

2

6

Wooley

Cat

Unknown

NULL

9.5

2

7

Buster

Dog

Border Collie

2006-12-11

25.0

4

Write an SQL statement to change the PetWeight column of the PET table so it does not allow NULLs. Assume the column exists, and that it currently allows NULLs

Write an SQL statement to drop the PetWeight column in the PET table.

Reference no: EM13856386

Questions Cloud

Analyze the recidivism rates for sex crimes : Analyze the recidivism rates for sex crimes
Explain and clarify items shown on the financial statements : The purpose of footnotes is to explain and clarify items shown on the financial statements. Please list the number and name of each of the footnotes, as well as the page the footnote appears.
Analyze techniques for requirements determination : The specific course learning outcomes associated with this assignment are. Analyze techniques for requirements determination, collection, and organization
Discuss how it may be applied to child rearing : Choose one of these conditioning/learning styles and discuss how it may be applied to child rearing. In essay format, create a plan to help get a young child to clean his/her room.
Write an sql statement to change the petweight column : Write an SQL statement to change the PetWeight column of the PET table so it does not allow NULLs. Assume the column exists, and that it currently allows NULLs
Prepare a detailed scope statement that defines the scope : Prepare a detailed scope statement that defines the scope of the SCID4 project. Each project manager shall use the scope statement template in Appendix A.
Write a memo answering this question : Which, if any, of the above expenses are allowable as non-taxable? Please write a memo answering this question, citing appropriate authority. An IRAC-style essay is appropriate for this assignment
Using data collection techniques and tools to amass war : Businesses across the globe are using data collection techniques and tools to amass war chests of information to leverage to create/maintain advantage. But, is this activity being deployed by companies like Google, Amazon, and thousands of others tru..
What are the two basic categories of torts : What are the two basic categories of torts? What makes them different? Please give examples of each? What are the elements of negligence? Be sure to discuss the reasonable person standard and the two kinds of causation.

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Sql give syntax of how to create table in sql and also give

give syntax of how to create table in sql and also give small demo to how to create table in sql.

  Create a plsql block to achieve the following using the hr

create a plsql block to achieve the following using the hr schemaselect the name salary and department of the employee

  Write a pl/sql block and declare a variable v_sal

Write a PL/SQL block and declare a variable  v_sal  of the type NUMBER. Include the following statement in the Execution section:

  What types of users would typically use a dml statement

You must begin by understanding the different types of SQL statements. Adhere to the following deliverables for this Discussion Board.

  Create a view named customer addresses

Create a view named CustomerAddresses that shows the shipping and billing

  Write a select statement that returns two columns

Write a SELECT statement that returns these two columns - CategoryName The CategoryName column from the Categories table

  Display account number and balance for all customers

This assessment item is designed to test your understanding of arrays/arraylists, objects, classes, methods, sorting and searching.

  Write a select statement that joins the customers table

Write a SELECT statement that joins the Customers table to the Addresses table and returns these columns: FirstName, LastName, Line1, City, State, ZipCode.

  Oracle general sql exercise

Oracle General SQL Exercise

  Create the sql queries

Create the queries listed below: (Just write the SQL command for each query), RIDER - POINT TOTALS BY RACE LEVEL LISTING, List the Rider's Name, RaceLevel as Race_Level and the total number of all points based on their placement. Make sure that you..

  How primary and foreign-key relationships are applied

At this point, you will add data to your database and validate that they loaded properly. In tabular format, include 3 rows for each table, making sure that the primary-key and foreign-key relationships are properly applied.

  Write command to list all the employees in year

Write the command to list all the employees hired in 2003 and 2004. Sort the rows by the hire_date column in descending order.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd