CareerCup

What exactly are you asking?

Database Schemas:
Movie: movie_id,movie_name
Actor: actor_id,movie_id,actor_name
Director: director_id,movie_id
Review: review_id,movie_id,review
Reviewer: reviewer_id,review_id,reviewer_name

Here is the template of classes:

class Movie{

//execute below SQL queries

void updateMovie(string movie_name){
sqlString = "insert into movie(movie_name) values (movie_name)";
}
void updateActor(string actor_name,string movie_name){
long long movie_id = (select movie_id from movie where movie_name = "movie_name")
insert into actor(movie_id,actor_name) values (movie_id,actor_name)
}

}

class Reviewer{

updateReviewTable(String review, string reviewer_name, string movie_name){

//Exceute below SQL queries
long long movie_id = (select movie_id from movie where movie_name = "movie_name")
insert into review(movie_id,review) values (movie_id,review)
select review_id from review where movie_id = "movie_id"
insert into reviewer(review_id,reviewer_name)
}

}