大三 sql 课后习题答案(27页)Good is good, but better carries it.精益求精,善益求善。第二章3.上机练习题02 程序代码如下:CREATE DATABASE STUDENT1ON PRIMARY(NAME= STUDENT1_data,FILENAME='E:\DATA\STUDENT1.mdf',SIZE=3,MAXSIZE=unlimited,FILEGROWTH=15%)LOG ON(NAME= STUDENT1_log,FILENAME='E:\DATA\STUDENT1.ldf',SIZE=2,MAXSIZE=30,FILEGROWTH=2)03 程序代码如下:create database studentson primary(name=students1,filename='E:\DATA\students1.mdf',size=5,maxsize=75,filegrowth=10%),(name= students12,filename='E:\DATA\students2.ndf',size=10,maxsize=75,filegrowth=1)log on (name=studentslog1,filename='E:\DATA\studentslog1.ldf',size=5,maxsize=30,filegrowth=1),(name=studentslog2,filename='E:\DATA\studentslog2.ldf',size=5,maxsize=30,filegrowth=1)第三章:3 上机练习题01 程序代码如下:-- 创建表book的Transact-SQL语句:USE test01GOCREATE TABLE book(book_id nchar(6) NOT NULL,book_name nchar(30) NULL,price numeric(10, 2) NULL, CONSTRAINT PK_book PRIMARY KEY CLUSTERED ( book_id ASC ) ) ON PRIMARY-- 创建表uthor的Transact-SQL语句:CREATE TABLE dbo.author(anthor_name nchar(4) NOT NULL,book_id nchar(6) NOT NULL,address nchar(30) NOT NULL) ON [PRIMARY]-- 设置book中的book_id为主键,author表中的book_id为外键ALTER TABLE dbo.author WITH CHECK ADD CONSTRAINT FK_ book_author FOREIGN KEY(book_id)REFERENCES dbo.book (book_id)02 程序代码如下:--利用Transact-SQL语句创建表booksales的代码。USE test01GOCREATE TABLE booksales(book_id nchar(6) NOT NULL,sellnum int NOT NULL,selldate datetime NOT NULL) ON PRIMARY--利用insert语句为表booksales添加数据:INSERT INTO booksales VALUES ('m00011',7,20/12/2008)INSERT INTO booksales(book_id,sellnum,selldate) VALUES ('m00017',3,17/11/2008 ) --利用update语句为表booksales更新数据:UPDATE booksales SET sellnum =11WHERE book_id ='m00011'--利用delete语句删除表booksales的数据:DELETE FROM booksales WHERE book_id ='m00011'03 程序代码如下:USE test01GOCREATE RULE sellnum_r...