1. Suppose you wanted quick lookup capability to get a listing of all plays directed by a given director. Which table would be the basis for the INDEX table, and what would be the index key? Create the index. Provide SQL code.

2. Create a view that lists all plays in alphabetical order and names of the directors.

3. Find all directors who were born between January 1st, 1962 and December 31st, 1962. Provide SQL code and the result.

4. Delete director with number 101 from directors table. Provide SQL code and the result of select statement for both tables before deletion and after deletion.

5. Update table PLAY. Change the name of play #1006 to Starbuck in Biloxi.

6. Find all directors who directed less than two plays. Provide SQL code and the result.

Table name: DIRECTOR DIR NUM DIR UNAME DR DOB 00 Broadway 12 Jan 65 101 Hollywo 18.Nov.53 102 Goofy 21-Jun-62 Table name: PLAY PLAY CODE PLAY NAME 001 Cat on a cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 INever Promised You Coffee 1004 Sily Putty Goes To Washington 1005 See No Sound, Heer No Sight 1006 Starstruck in Blood 1007 Stranger Parrot Ice DR NUM 102 101 102 100 101 102 101