Write sql to correction create the beach table

Assignment Help PL-SQL Programming

Reference no: EM13756103

1. Write SQL to correction create the OCEAN table as specified below.

2. Write SQL to inset the data into the OCEAN table as give below

OCEAN:

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

Ocean is the primary key

3. Write SQL to correction create the BEACH table as specified below.

4. Write SQL to inset 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

5. Use an alter table statement to add a constraint that PercentOfSurface must be between 0 and 100.

6. Update the Ocean Column to say "Gulf of Mexico" instead of "Gulf"

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

8. Write an SQL Statement to add the column "TravelChannelRating" to the table BEACH.

9. Write the SQL statement to insert the value 1 for Manele Bay, the Value 2 for Myrtle Beach, the Value 5 for Clearmater Beach, and the Value 7 for Coronado (for the column you just created).

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

Reference no: EM13756103

Questions Cloud

Some of the important customer and organizational documents : What are some of the important customer and organizational documents that a PM should be concerned with during the closeout phase of a project?

Discuss a residual risk of this project : Refer to a project from your work, education, or personal life. Identify and assess risks, using Figure 1.3 of the textbook as a model. Discuss a residual risk of this project and how it could have been managed.

Compute the direct materials price and quantity variances : compute the Direct Materials price and quantity variances for metal and wood. compute the Direct labor rate and efficiency variances for the Molding and trimming/ finishing departments

Impact of the capital budgeting decision : What's the significance of recognizing the time value of money in the long term impact of the capital budgeting decision?

Write sql to correction create the beach table : Write SQL to correction create the BEACH table, Write SQL to inset the data into the BEACH table

Average investor understand the difference : Why is it important to report discontinued operations or extraordinary items separately from income from continuing operations? Does the average investor understand the difference?

Basic financial statements : What three specific ratios (not types) would you list as the most important? Why? Beyond the basic financial statements what other information would you want in order to fully analyze a company's performance? Why?

Differences between vertical and horizontal analysis : What are the differences between vertical and horizontal analysis? Which method would external users most likely use? How about internal users? Discuss the uses of the two analysis methods and how you would use each to analyze a company's perfo..

Write a history essay about which is better aztec or inca : Write a history essay about which is better aztec or inca. and prepare a short essay in which you take a position and respond to the question: Which civilization was more impressive, Aztec or Inca?

User Account

All Pages