Wrote APIs to perform CRUD operations on the tables movie, director containing the following columns,
Movie Table-
Columns Type movie_id INTEGER director_id INTEGER movie_name TEXT lead_actor TEXT
Director Table-
Columns Type director_id INTEGER director_name TEXT
API-1 Path: /movies/ Method: GET Description: Returns a list of all movie names in the movie table
API-2 Path: /movies/ Method: POST Description: Creates a new movie in the movie table. movie_id is auto-incremented
API-3 Path: /movies/:movieId/ Method: GET Description: Returns a movie based on the movie ID
API-4 Path: /movies/:movieId/ Method: PUT Description: Updates the details of a movie in the movie table based on the movie ID
API-5 Path: /movies/:movieId/ Method: DELETE Description: Deletes a movie from the movie table based on the movie ID
API 6 Path: /directors/ Method: GET Description: Returns a list of all directors in the director table
API-7 API 7 Path: /directors/:directorId/movies/ Method: GET Description: Returns a list of all movie names directed by a specific director