二、（每小题6分，共30分】 1.CREATE TABLE Book( BookID varchar(20)PRIMARY KEY, Title varchar(50), Author varchar(50), Publisher varchar(50) }； 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) }； 4.INSERT INTO Student VALUE(100200036,'王小美，计算机系)； 5.DELETE FROM Lend WHERE StdID IN (SELECT ID FROM Student WHERE Name='李小萍 ）； 三、（共12分）】 1.说明：EXEC SQL BEGIN DECLARE SECTION; char title30]; int length; 430二、(每小题 6分，共 30分) 1. CREATE TABLE Book{ BookID varchar(20) PRIMARY KEY Title varchar(50)， Author varchar(50)， Publisher varchar(50) }; 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) }; 4. INSERT INTO Student VALUE ('100200036',’王小美‘，’计算机系’); 5. DELETE FROM Lend W HERE StdID IN (SELECT ID FROM Student WHERE Name=’李小萍‘ ); 三、(共 12分) 1.说 明:EXEC SQL BEGIN DECLARE SECTION char title仁30]; int length; 430