Write an sql statement to delete the nantucket record

Assignment Help PL-SQL Programming

Reference no: EM131275209

Assignment:

Turn in the SQL to answer the following questions (I do not need the tables, just the SQL).

1. Write SQL to correctlycreate the OCEAN table as specified below and to insert the data into the OCEAN table as given below

OCEAN:

Ocean	AverageDepth	PercentOfSurface
Pacific	13740	48
Atlantic	12254	28
Gulf	5299	1

Ocean is the primary key

2. Write SQL to correctly create the BEACH table as specified below (including the foreign key constraint) and write SQL to insert the data into the BEACH table as give below

BEACH:

Beach	State	Ocean
Manele Bay	Hawaii	Pacific
Myrtle Beach	South Carolina	Atlantic
Nantucket	Massachusetts	Atlantic
Clearwater Beach	Florida	Gulf
Coronado	Californa	Pacific

Beach is the primary key, ocean is a foreign key, set up a cascade on insert and cascade on delete for the foreign key referential integrity constraint

3. Using an update statement, update the Ocean Column to say "Gulf of Mexico" instead of "Gulf"

4. Write an SQL statement to delete the Nantucket record.

5. Write the SQL necessary to drop the Ocean table.

6. Write the SQL necessary to recreate the ocean table in the same way it was create for question 1 but add the constraint that PercentOfSurface must be Between 0 and 100. (insert the data into the table as well).

7. Write the SQL necessary to create a view that contains all of the beach data and ocean data (recompose the tables in a view).

Reference no: EM131275209

Questions Cloud

Write program which accepts a space-delimited set of symbols : Write a program which accepts a space-delimited set of symbols representing an infix arithmetic expression as described below. The user should be prompted for the input (to be entered via keyboard)

Define quantitative research and qualitative research : Define quantitative research. Define qualitative research. List the differences between these two research methods. What is pluralistic research?

Describe two formats of online focus groups : Indicate why covert observation would be appropriate for a study on how parents discipline their children when dining out. - Describe a traditional focus group.

Should the members of a focus group be similar or dissimilar : How are focus group participants recruited, and what is a common problem associated with this recruitment?- Should the members of a focus group be similar or dissimilar? Why?

Write an sql statement to delete the nantucket record : Write an SQL statement to delete the Nantucket record. Write the SQL necessary to recreate the ocean table in the same way it was create for question 1 but add the constraint that PercentOfSurface must be Between 0 and 100.

Advantages and disadvantages of client interaction in design : What should be included in a report that summarizes the findings of a focus group?- Indicate the advantages and disadvantages of client interaction in the design and execution of a focus group study.

How do you lift someone out of poverty : Watch the video below. Is our foreign aid charity misplaced and hurting more than helping? Are we keeping the poor in poverty? How do you lift someone out of poverty?

Develop your argument such that they are logical : Develop your argument such that they are logical and convincing to the reader - All agrument needed to be developed more fully application of the theories concincingly. Also, all aspects related to the theories needed to be considersed in their app..

Find the probable identity of the metal : If the cooling curve was obtained at the center of the casting sketched in the figure, determine the mold constant,

User Account

All Pages