Answered step by step
Verified Expert Solution
Question
1 Approved Answer
write this db code use sqlplus..don't copy from any site. Test given input. - Consider the folowing tables. Hare, FK imples Foreign Key. *+You need
write this db code use sqlplus..don't copy from any site.
Test given input.
- 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 usedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started