数据库原理复习题(2)

( )

sno char(8) primary key, sname varchar2(20) not null,

ssex varchar2(2) check(ssex in (‘男’,’女’)), sageint check(sage between 15 and 40), sdept varchar2 (20)

（2）、

INSERT into student (sno, sname,ssex, sage, sdept) values (‘0910010001’,’吴鹏’,’男’,21,’计算机系’) （3）、

UPDATE student set sname=’张萌’,ssex=’女’,sage=22,sdept=’传媒技术系’ where sno=’0910010012’ （4）、

SELECT sname From student

Where sdept=’计算机系’ and sage<20 （5）、

CREATE view v_ student As

SELECT sdept, avg(sage) 平均年龄 From student Group by sdept

Having avg(sage)>19 （6）、

GRANT select on student to admin with grant option 7、

Πname(σ

2、（1）、

sdept=’计算机系’ and sage<20(student))

CREATE table teacher

( No char(8) primary key, Name varchar(20) not null, Sex varchar(2) check(sex in ('男','女')), Age intcheck(age between 15 and 40), Prof varchar(6), Depart varchar(20) ) （2）、

INSERT into teachar(no, name, sex, prof, depart) values ('021912','王敏','女','助教','计算机系') （3）、

UPDATE teacher set name='朱湘',sex='女',prof='教授',depart='传媒技术系' where no='021923' （4）、

SELECT no,name From teacher

Where depart='计算机系' and age>30 and sex='女' （5）、

CREATE view v_teacher As

SELECT depart, avg(age) 平均年龄 From teacher Group by depart Having avg(age)>30 （6）、

GRANT select on teacher to U1 with grant option （7）、

Πname(σ