【正确答案】(1)CREATE TABLE Movie(
…
CHECK(NOT color OR year>=1939)
);
(2)CREATE TABLE Actor (
…
birthYear INT,
CHECK(name NOT IN(SELECT actorName FROM Acts)
OR birthYear<ALL(SELECT movieYear FROM Acts
WHERE actorName=name))
);
CREATE TABLE Acts(
…
CHECK(actorName NOT IN(SELECT name FROM Actor)
OR movieYear>(SELECT birthYear FROM Actor
WHERE name=actorName))
);