Question

Body) AaBbCcDd AaBbCcDd A 1 Normal 1No Spac... Font Paragraph Styles Movie Database Entity Relationship Diagram (ERD) Use this ERD when accomplishing Assessments 2, 3&4 MOVIE STAR STAR STAR ID FIRSTNAME LAST NAME STAR ID - DIRECTOR MOVIE MOVIE ID TITLE GENRE MPAA FIRST NAME LAST NAME RELEASE DATE LENGTH MINUTES DIRECTOR ID pts) Regal Theaters also wants to be able to search for a movie title without tivity. For example the query "SELECT FROM MOVIE WHERE TITLE> 'JAW

Answer 1

Answer: See the answer below:

--------------------------------------------------------

Select MOVIE.TITLE, CONCAT(DIRECTOR.FIRST_NAME,DIRECTOR.LAST_NAME) AS DIRECTOR_NAME, CONCAT(STAR.FIRST_NAME,STAR.LAST_NAME) AS STAR_NAME FROM MOVIE, DIRECTOR, STAR, MOVIE_STAR WHERE MOVIE.DIRECTOR_ID = DIRECTOR.DIRECTOR_ID AND MOVIE.MOVIE_ID = MOVIE_STAR.MOVIE_ID AND MOVIE_STAR.STAR_ID = STAR.STAR_ID

------------------------------------------------------

Note: In SQL, to concatenate two columns, CONCAT() function can be used.