数据库设计和管理课后作业答案.docVIP

第四章 4.1 CREATE DATABASE Sales ON primary ( NAME=Saldat01, FILENAME=c:\db\saldat01.mdf), ( NAME=Saldat02, FILENAME=c:\db\saldat02.ndf), filegroup filegrp1 ( NAME=Saldat11, FILENAME=d:\db\saldat11.ndf), ( NAME=Saldat12, FILENAME=d:db\saldat12.ndf), ( NAME=Saldat13, FILENAME=d:\dbsaldat13.ndf) 4.2 alter database sales add log file (name=sallog2, filename=c:\db\sallog2.ldf) 4.3 alter database sales add file (name=saldat03, filename=c:\db\sallog03.ndf, size=5mb, filegrowth=20%) to filegroup [primary] 4.4 alter database sales set single_user 4.5 alter database sales modify name=oldsales 4.6 drop database oldsales 5.4.1 create table sales.dbo.sell_order (order_id1 int identity(1,2) not null, goods_id char(6) not null, employee_id char(4) not null, customer_id char(4) not null, transporter_id char(10) not null, order_num float not null, discount float not null, order_date datetime not null, sent_date datetime not null, arrival_date datetime not null, cost money not null) 2 exec sp_rename sell_order.sent_date,发货日期,column 或 Alter table sell_order Drop column sent_date Go Alter table sell_order Add 发货日期 datetime 3 insert sales.dbo.sell_order (order_date,customer_id,goods_id,order_num,employee_id,discount) values(2006-2-26,99,135,30,16,0.95) 4. insert sales.dbo.sell_order (order_date,customer_id,goods_id,order_num,employee_id,discount,发货日期,transporter_id,arrival_date,cost) values(2005-10-10,6,26,200,02,0.8,2005-12-1,10,2005-12-12,200000) 5. update sell_order set employee_id=15 where employee_id=29 and cost is null 6. update sell_order set discount=discount*0.9 where customer_id=100 and cost is null 7. delete sell_order where order_date=2006-1-1 6.6 create table student (s_no char(4), s_name char(8), s_sex char(2), birthday datetime, polity text) create table sco (s_no char(4), c_no char(4), score int) select * from student order by s_no select s_no,S_name,s_sex,birthday,polity from student where s_sex=女 compute count(s_sex) (3