Answered step by step
Verified Expert Solution
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
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
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