The following is Relational Database System for a movie production company in Hollywood called Syzygy, in which the authorized owner of the database is Syzygy. Examine the following tables. 

a) The Database Administrator (DBA) noticed the Movies Database gave slow response times when selecting star data via the star's name. The DBA decided to create  a index to speed up the response time. Specify the SQL statement required. (1 mark)

b) Describe TWO (2) other responsibility of the DBA with equivalent SQL statement that the DBA can use in carrying out those responsibilities. (2 marks) 

c) Write the SQL statement for creation of the MOVIE table that would enforce the integrity constraints.

 

Transcribed Image Text:

DNUM 1 2 3 DIRECTOR DNAME Allen, Woody Hitchcock, Alfred De Mille, Cecil B 4 Kramer, Stanley 5 Kubrick, Stanley STAR (A blank field represents a NULL value.) SNUM SNAME SBORN SDIED 1 Allen, Woody 1935 2003 2 Keaton, Dianne 1946 3 Sellers, Peter 1925 1980 4 Scott, George C 1927 1999 5 McDowell, Malcolm 1943 6 Grant, Cary 1904 1986 8 Stewart, James 1908 1997 MOVIE MNUM MTITLE DNUM DFEE 1 Annie Hall 1 300000 2 Dr. Strangelove 5 270000 3 Clockwork Orange S 600000 4 North By Northwest 2 450000 5 Rope 2 500000 6 Manhattan 1 750000 MOVIESTAR MNUM SNUM SFEE 1 1 200000 1 2 150000 2 3 35000 2 4 500000 3 1 1130000 4 6 210000 4 8 260000 5 8 650000 6 1 520000 6 2 600000 DNUM 1 2 3 DIRECTOR DNAME Allen, Woody Hitchcock, Alfred De Mille, Cecil B 4 Kramer, Stanley 5 Kubrick, Stanley STAR (A blank field represents a NULL value.) SNUM SNAME SBORN SDIED 1 Allen, Woody 1935 2003 2 Keaton, Dianne 1946 3 Sellers, Peter 1925 1980 4 Scott, George C 1927 1999 5 McDowell, Malcolm 1943 6 Grant, Cary 1904 1986 8 Stewart, James 1908 1997 MOVIE MNUM MTITLE DNUM DFEE 1 Annie Hall 1 300000 2 Dr. Strangelove 5 270000 3 Clockwork Orange S 600000 4 North By Northwest 2 450000 5 Rope 2 500000 6 Manhattan 1 750000 MOVIESTAR MNUM SNUM SFEE 1 1 200000 1 2 150000 2 3 35000 2 4 500000 3 1 1130000 4 6 210000 4 8 260000 5 8 650000 6 1 520000 6 2 600000