数据库课后习题答案

st01.dbo.book(Р book_id nchar(6) NOT NULL,Р book_name nchar(30) NULL,Р price numeric(10,2) NULL,Р PRIMARY KEY (book_id) Р)РON [PRIMARY]РCREATE TABLE test01.dbo.author(Р author_name nchar(4) NULL,Р book_id nchar(6) NULL,Р address nchar(30) NULLР)Р ALTER TABLE dbo.author WITH CHECKР ADD CONSTRAINT PKT54_db FOREIGN KEY (book_id)Р REFERENCES test01.dbo.book (book_id)РGOР(2)在 test01 数据库中利用 Transact-SQL 语句创建一个图书销售表 booksales (book_id nchar(6),sellnum int, selldate datetime)。分别利用 insert 、delete、update 语句添加、删除和更新数据。РCREATE DATABASE test01РGoРUSE test01РGOРCREATE TABLE booksales(Рbook_id nchar(6) NOT NULL,Рsellnum int NOT NULL,Рselldate datetime NOT NULLР)РINSERT INTO booksales VALUES ('A909',987,'4/01/27');РGOРUPDATE booksales SET book_id='888';РGOРDELETE FROM booksales where selldate='4/01/27'РGo