大三-sql-课后习题答案

大三 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...