SQL数据库高手帮忙解答下
- 提问者网友:冷天寄予
- 2021-02-14 09:04
- 二级知识专家网友:woshuo
- 2021-02-14 10:16
- 1楼网友:绝望伪装
- 2021-02-14 11:33
- 2楼网友:恕我颓废
- 2021-02-14 11:23
2.select sno,sname,major from student where major in(select cno from course where cname='sql') 3.没有见到有选课表 4.select cname from course where cno not in(select distinct major from student)
5.use master go create database stu --创建数据库 go use stu go create table student (sno char(10) primary key, sname nvarchar(20) not null, sex char(2) default '男', major nvarchar(20), birthday date) create table course (cno char(10) primary key, cname nvarchar(20) not null, credit nvarchar(20)) create table sc (sno char(10), cno char(10), grade decimal(3,1), constraint [pk_sc] primary key clustered ([sno] asc,[cno] asc), constraint [fk_sc_student] foreign key([sno])references [dbo].[student] ([sno]), constraint [fk_sc_course] foreign key([cno])references [dbo].[course] ([cno]) )