简单的SQL语言题,有没有学霸能解答一下

简单的SQL语言题,有没有学霸能帮忙解答一下,我想对一下,然后再自己思考思考。

img


(2)(3)求解


--2
create table R(
 NO int primary key,
 NAME varchar(20) not null,
 SEX  varchar(20) ,
 AGE int  ,
 CLASS varchar(20) 
);

insert into R values (985766,"欧阳锋","男",18,"92036");

update R set age=age+1 where sex = "女生";

delete from R where no = 989988;

第四题
1nf有部分函数依赖
2nf有传递函数依赖
范式定义可以求得
谢谢采纳

insert into R values (985766,"欧阳锋","男",18,"92036")
update R set age=age+1 where sex = "女"
delete from R where no = 989988