Kizspy | Question: 5
(Choose 1 answer)
Consider the two relations from our running movie database:
Movies (title, year, length, genre, studioName, producerC#)
MovieExec(name, address, cert#, netWorth)
The producerC# component of each Movies tuple must also appear in the cert# component of some
MovieExec tuple.
How can we express this integrity constraint in relational algebra?
A. n_(producerC#) (Movies)=n_(cert#) (MovieExec)
B. П_(producerC#) (Movies)≤n_(cert#) (MovieExec)
C. n_(cert#) (MovieExec) Sn_(producerC#) (Movies)
D. n_(producerC#) (Movies) #n_(cert#) (MovieExec)
