Consider Ullman and Widoms movie database example:

Movies (title, year, length, genre, studioName, producerC#)

StarsIn (movieTitle, movieYear, starName)

MovieStar (name, address, gender, birthdate)

MovieExec (name, address, cert#, netWorth)

Studio (name, address, presC#)

*******************************************************

Write PSM procedures or functions to accomplish the following:

******************************************************

a. Given the name of a movie studio, return the net worth of its president.

b. Given a star name, find the earliest movie of more than 120 minutes length in which they appeared. If there is no such movie, return the year 0.

c. Given the name of a star, delete them from MovieStar and delete all their movies from StarsIn and Movies.