Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

write this Database code using Plsql - Consider the folowing tables. Hare, FK imples Foreign Key. *+You need to create the tables and insert data

image text in transcribedwrite this Database code using Plsql

- 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

Students also viewed these Databases questions

Question

Discuss what theyre doing to be family friendly.

Answered: 1 week ago