DBIS Homework 1, Fall 2001

Due Monday 13 August, in class.

To be done individually, no discussion with others.
----------------------------------------

1) Design an ER schema to store data for the IITB Movie Club. 
   The data should include basic movie information (name, director, 
   actors, language ..), show information (movie, date, time), 
   member information (id number, fac/student, program/title, 
   department, year-entered-iit), member payment information, 
   and information about which members watched which movies (although this 
   is not currently recorded, we will pretend it is).  

   Show the ER diagram with applicable constraints.

2) Convert the above ER diagram to a set of tables.  Show the tables
   along with information about tables that were redundant, and make
   sure multivalued attributes are converted properly.

3) On the above relational schema, write queries on the above schema in each of 
     (a) relational algebra (b) domain relational calculus
   to do the following
    (0)   Find all Govinda movies screened at IITB since 2000
    (i)   Find all movies watched by at least one member of CSE BTech 1999
    (ii)  Find all movies watched by all members of CSE BTech 1999
    (iii) Find all actors who acted in at least two movies shown at IIT.