Author varchar(50), Publisher varchar(50) (2)CREATE TABLE Student{ StdID CHAR(10)PRIMARY KEY, Name varchar (20), Dept varchar (20) }； (3)CREATE TABLE Lend{ StdID CHAR(10), BookID varchar(20), LDate datetime, PRIMARY KEY(StdID,BookID), FOREIGN KEY(StdID)REFERENCES Student(StdID), FOREIGN KEY(BookID)REFERENCES Book(BookID) ): 三、（每小题6分，共18分）】 答： (1)INSERT INTO Student VALUES('100200036','张京京'，'物理系')； (2)DELETE FROM Lend WHERE StdID IN (SELECT StdID FROM Student WHERE Name='刘玉飞' )； (3)答案一：SELECT Name,StdID FROM Student 439Author varchar(50)， Publisher varchar(50) }; (2)CREATE TABLE Student{ StdID CHAR(10) PRIMARY KEY Name varchar (20) Dept varchar (20) }; M)CREATE TABLE Lend f StdID CHAR(10)， BookID varchar(20)， LDate datetime, PRIMARY KEY(StdID,BookID)， FOREIGN KEY(StdID) REFERENCES Student(StdID) FOREIGN KEY(BookID) REFERENCES Book(BookID) }; 三、(每小题 6分，共 18分 ) 答 ; (1)INSERT INTO Student VALUES(' 100200036' ,’张京京‘，‘物理系‘); (2)DELETE FROM Lend W HERE StdID IN (SELECT StdID FROM Student WHERE Name=‘刘玉飞‘ ); (3)答案一:SELECT Name, StdID FROM Student 439