Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following Database of movies Movies (M_no, M_name,release_year,budget) Actor (A_no,A_name,A_city,age) The relationships are as follows: Movies-Producers - M : M Movies-Actor - M: M

image text in transcribed

Consider the following Database of movies Movies (M_no, M_name,release_year,budget) Actor (A_no,A_name,A_city,age) The relationships are as follows: Movies-Producers - M : M Movies-Actor - M: M with descriptive attribute role and charges Functions a) Write a function to display number of movies released in year 2004. b) Write a function to display release year of a given movie c) Write a function to display a city and birthdate of a given actor d) Write a function do display information of actor for given actor no Write a function to display information of producers for given city (use for loop and row type) e) Write a function to accept a actor name and movie name and display its role f) Write a function to accept producer name and display number of movies produced by him g) Write a function to accept actor name and display name of movies in which actor has worked

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

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago