Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

write the sqlplus code and test this input.. Note:Don't copy or give any wrong answer. - Consider the folowing tables. Hare, FK imples Foreign Key.

image text in transcribedwrite the sqlplus code and test this input..

Note:Don't copy or give any wrong answer.

- Consider the folowing tables. Hare, FK imples Foreign Key. *+You need to create the tables and insert data as shown in the given tablest*t - Take abum ID \{abumid as user input. n. If the abbumiD is vid: - Show the dates on ahich the indididal tracks of that album ware released. Also show the number of tracks in each of the album released by the same artist. b. If the abbundD is invid, print "Album does not exist". - You must use cursor to search aNbumiD \& find relense dates and tracks, searching implementation will be inside a procedure, track finding (of the same artist) will be inside a function. Package, exception and trigger must also be used

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

More Books

Students also viewed these Databases questions

Question

General Purpose of Your Speech Analyzing Your Audience

Answered: 1 week ago

Question

Ethical Speaking: Taking Responsibility for Your Speech?

Answered: 1 week ago