Answer all questions on test. Use back if necessary. No scrap paper will be grad

Question

Answer all questions on test. Use back if necessary. No scrap paper will be graded. Return you cheat sheet with test if using Exercise 1: Consider the ER schema for the MOVIE database described by the figure below: PERFORMS IN MOVIE ACTOR LEAD ROLE ALSO A ACTOR DIRECTOR PRODUCER DIRECTOR DIRECTS PRODUCER M PRODUCES Assume that MovIE is a populated database. ACTOR is used as a generic term and includes actresses as well. Given the constraints shown in the ER schema, answer the following statements with True, False or Maybe. Justify each answer. a. There are no actors in this database that have no movies b. There are some actors who have acted in more than ten movies c. Some actors have done a lead role in multiple movies d. A movie can have only a maximum of 2 lead actors e. Every director has been an actor in some movie f No producer has ever been an actor g. a producer cannot be an actor in some other movie

Explanation / Answer

Exercise 1 :

a) true (double indicates full participation)

b) may be (because there are M actors and N movies)

c) may be

d) true (only 2 lead actors for any of the N movies)

e) true

f) false ( every actor is a producer)

g) false ( he should be , as you can see 1-1 relationship)

h) maybe ,because values of M and N are not mentioned

i) may be (there is no direct relationship between producer and director)

j) may be (no numbers mentioned correctly)

k) true , can be seen in relationships

l) false , an actor can be a director at same time

m) true , as movie-director is N-1 and movie-roducer is N-M relationship

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.