大三 sql 课后习题答案.docxVIP

大三 sql 课后习题答案 第二章 3.上机练习题 02 程序代码如下： CREATE DATABASE STUDENT1 ON 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 students on 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 test01 GO CREATE 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 test01 GO CREATE 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/2021) INSERT INTO booksales(book_id,sellnum,selldate) VALUES (m00017,3,17/11/2021 ) --利用update语句为表booksales更新数据： UPDATE booksales SET sellnum =11 WHERE book_id =m00011 --利用delete语句删除表booksales的数据： DELETE FROM booksales WHERE book_id =m00011 03 程序代码如下： USE test01 GO CREATE RULE sellnum_rule AS @sellnum =0 EX