简单的SQL语言题,有没有学霸能帮忙解答一下,我想对一下,然后再自己思考思考。
--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