Question
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.
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.
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started