2)CREATE TABLE Student( ID CHAR(10)PRIMARY KEY, Name varchar (20), Dept varchar (20) }； 3)CREATE TABLE Lend( StdID CHAR(6), BookID varchar(20), LDate datetime, PRIMARY KEY (StdID,BookID), FOREIGN KEY (StdID)REFERENCES Student (ID), FOREIGN KEY (BookID)REFERENCES Book (BookID) ； 三、（每小题7分，共14分） 1)INSERT INTO Student VALUES(‘100200036’,‘张京京’，‘化学系)； 2)DELETE FROM Lend WHERE StdID IN (SELECT ID FROM Student WHERE Name=‘苏明' )； 四、（共8分） 答案一.SELECT Name,lD FROM Student WHERE ID IN (SELECT StdID FROM Lend 4442) CREATE TABLE Student丈 ID CHAR(10) PRIMARY KEY Name varchar (20) Dept varchar (20) 3) CREATE TABLE Lend{ StdID CHAR(6) BookID varchar(20) LDate datetime PRIMARY KEY (StdID,BookID) FOREIGN KEY (StdID) REFERENCES Student (ID)， FOREIGN KEY (BookID) REFERENCES Book (BookID) }; 三、(每小题 7分，共 14分) 1) INSERT INTO Student VALUES ( `100200036' ,‘张京京 ’，‘化学系’); 2) DELETE FROM Lend W HERE StdID IN (SELECT ID FROM Student WHERE Name=‘苏明 ); 四、(共 8分) 答案一 SELECT Name, ID FROM Student W HERE ID IN (SELECT StdID FROM Lend 444