数据库课程设计题目大全（数据库的题目）

：暂无数据 2026-10-15 06:50:01 ：0

数据库课程设计题目大全（数据库的题目）

大家好，数据库课程设计题目大全相信很多的网友都不是很明白，包括数据库的题目也是一样，不过没有关系，接下来就来为大家分享关于数据库课程设计题目大全和数据库的题目的一些知识点，大家可以关注收藏，免得下次来找不到哦，下面我们开始吧！

本文目录

数据库的题目
关于数据库的题目
数据库的题目有谁可以给我答案
谁能帮我做下这些数据库题目谢谢

数据库的题目

if exists (select name from sysobjects where name=’mytring’ and type=’tr’)
drop trigger mytring
go
create trigger mytring
on c
for delete
as
delete from sc
where cno in(select cno from deleted)
go

1
select s.sno,s.sname from s,c,sc where s.sno=sc.sno and c.cno=sc.cno and c.cname=’MS’
2
select sno from sc where cno=’C1’ and sno in (select sno from sc where cno=’C3’)
3
select s.sno,sc.grade from s,c,sc where s.sno=sc.sno and c.cno=sc.cno and c.cname in(’数据库’,’操作系统’)
4
select sno,sname,age from s where 性别=’女’ and age between 18 and 20
5
select s.sno,s.sname,sc.grade from s,c,sc where s.sno=sc.sno and c.cno=sc.cno and c.teacher=’刘平’
6
select distinct s.sname from s,sc where s.sno=sc.sno and cno in(select cno from sc having count(distinct cno)=(select count(*) from c))
7
select distinct sname from s where sno in(select sno from sc where cno in(select cno from sc where sno=’1042’) group by sno having count(*)=(select count(*) from sc where sno=’1042’))
8
select sname,age,所在系 from s where sname like ’樊%’
9
select sname,age,所在系 from s where sno in(select sno from sc group by sno having count(*)》3)

其中4,8,9，你给的字段里分辨不出来哪些字段是性别和所在系，根据实际情况自己替换

数据库的题目有谁可以给我答案

3、写出sql语句。 1) 查询所有选sql课程的学生学号，姓名和专业。(5分) 2) 删除所有选择数学的同学的选课记录。(5分) 3) 查询有哪些课程没有被任何

谁能帮我做下这些数据库题目谢谢

###某学校数据库练习
#三个表：学生表: edu_students 班级表: edu_class 系表: edu_department
##（1）找出所有姓李的学生，并按其年龄由小到大排序
SELECT * FROM edu_students WHERE student_name LIKE ’李%’ ORDER BY age;
##（2）列出所有开设超过两个专业的系的名字
SELECT x.department_name FROM(
SELECT c.department_name,count(c.department_name) num
FROM edu_class c GROUP BY c.department_name) x
WHERE x.num 》= 2;
##（3）列出学生数人数大于等于2的系的编号和名称
SELECT x.department_id,x.department_name FROM(
SELECT d.department_id,d.department_name,count(d.department_name) num FROM edu_students s
LEFT JOIN edu_class c ON s.class_id = c.class_id
LEFT JOIN edu_department d ON d.department_name = c.department_name
GROUP BY d.department_name) x
WHERE x.num 》= 2;
##4、学校又新增加一个物理系，编号006
INSERT INTO edu_department (department_id,department_name) values (’006’,’物理’);
##5、学生张三转到化学系111班，请更新相关的表
UPDATE edu_students SET class_id = 111 WHERE student_name = ’张三’;