Database used: MySQL
MySQL Database Name: movie_db
Table name: "movies" with attributes- id, movie_name, lead_actor, lead_actress, year_of_release, director_name
The following tasks are performed-
- Database is created and then values are inserted in Movies table.
- All the rows in the table are fetched.
- All the movies of a lead actor (here: "Shahid Kapoor") are fetched.