Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. 


c1.JPG

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts Of Database Management

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

10th Edition

0357422082, 978-0357422083

More Books

Students also viewed these Databases questions

Question

Solve the relation Exz:Solve therelation ne %3D

Answered: 1 week ago