数据库系统概论形成性考核册第2次作业答案.docVIP

数据库系统概论作业2答案 答： CREATE TABLE Movie( Title CHAR(30), Year INT, Length INT ); CREATE TABLE Actor( Name CHAR(20), Address VARCHAR(30), Gender CHAR(1), Birthdate DATE ); CREATE Acts( MovieTitle CHAR(30), MovieYear INT, ActorName CHAR(20) ); 答： 1) SELECT AVG(Length),MIN(Length) FROM Movie WHERE Year=1999; 2) SELECT ActorName FROM Acts WHERE MovieYear=1999; 3) SELECT M1.Title,M1.Year,M2.Year FROM Movie AS M1,Movie AS M2 WHERE M1.Title=M2.Title AND M1.YearM2.Year; 4) INSERT INTO Actor(Name,Gender) VALUES(‘秀兰·邓波儿’,’F’); 5) UPDATE Movie SET Length=109 WHERE T