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. False

b. May be

c. True

d. True

e. false

f. False

g. false

h. maybe

i. false

j. may be

l. may be

m. may be

Exercise 2

1) select * from Owner

select * from Property

select * from Employee

select * from Service

2)

select Name,Cellphone from Employee where experiencelevel='Master'

3)

select Name,Cellphone from Employee where name like 'J%'

4) select name from employee where initials in (select initials from Service where propertyid in (select propertyid from Property where city='newyork'))

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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