ACCP7.0优化myschool数据库设计
ACCP课程体系通过结合先进的多模式教学法,使学习者在掌握理论知识与工具的同时,具备良好的自我学习能力和个人素质,成为符合21世纪企业要求的IT人才。下面是关于ACCP7.0优化myschool数据库设计,欢迎大家参考!
上机1
use MySchool
go
begin transaction
declare @errornum int
set @errornum=0
insert into Result values('23219',1,90,'2013-09-12')
set @errornum+=@@ERROR
insert into Result values('23219',1,90,'2013-09-13')
set @errornum+=@@ERROR
insert into Result values('23219',1,90,'2014-09-12')
set @errornum+=@@ERROR
insert into Result values('23219',1,90,'2013-09-11')
set @errornum+=@@ERROR
insert into Result values('23219',1,90,'2003-09-12')
set @errornum+=@@ERROR
if @errornum<>0
begin
print '操作失败,回滚事务'
rollback transaction
end
else
begin
print '操作成功,保存事务'
commit transaction
end
--上机2
go
begin transaction
declare @errornum int
set @errornum=0
select * into historyresult from Result
where StudentNo in(select StudentNo from Student
where GradeId=(select GradeId from Grade where GradeName='Y2'))
set @errornum+=@@ERROR
delete from Result
where StudentNo in(select StudentNo from Student
where GradeId=(select GradeId from Grade where GradeName='Y2'))
set @errornum+=@@ERROR
select * into historystudent from Student
where GradeId=(select GradeId from Grade where GradeName='Y2')
set @errornum+=@@ERROR
delete from Student
where GradeId=(select GradeId from Grade where GradeName='Y2')
set @errornum+=@@ERROR
if @errornum<>0
begin
print '操作失败,回滚事务'
rollback transaction
end
else
begin
print '操作成功,保存事务'
commit transaction
end
--上机3
go
CREATE VIEW vw_student_result_info
AS
SELECT 姓名=StudentName,学号=entNo,
联系电话=Phone,学期=GradeName,成绩=Total
FROM Student
LEFT OUTER JOIN (
SELECT entNo,GradeName,SUM(StudentResult) Total
FROM Result r
INNER JOIN (
SELECT StudentNo,SubjectId,MAX(ExamDate) ExamDate
FROM Result
GROUP BY StudentNo,Subjectid) tmp
ON Date=Date
AND ectid = ectid AND entNo = entNo
INNER JOIN Subject sub ON ectid = ectid
INNER JOIN Grade g ON eId = eId
GROUP By entNo,GradeName ) TmpResult2
ON entNo = entNo
GROUP BY StudentName,entNo,Phone,GradeName,Total
GO
SELECT * FROM vw_student_result_info
--上机4
go
create nonclustered index index_result
on result(studentresult)
select studentname,Subjectname,ExamDate,StudentResult from Result
with(index=index_result)
inner join Student on entNo=entNo
inner join Subject on ectId=ectId
where StudentResult between 80 and 90
-
accp3.0课程详细介绍
accp3.0是北大青鸟aptech即将推出的最新产品,是在大量的教学实践和市场调研的基础上,结合新技术发展的现状,继承和发扬了accp产品固有的特点和优势而开发出来的、具有众多特色的软件工程师职业教育体系。以下是小编整理的关于accp3.0课程详细介绍吗,欢迎大家阅读!A...
-
2017计算机软件考试知识点:广域通信网
计算机软件考试分为5个专业类别,并在各专业类别中分设了高、中、初级专业资格考试,yjbys小编下面为你整理了关于广域通信网的知识点,希望对你有所帮助。一、在电气性能方面EIA-RS232-C与CCITT的V.28建议书一致,在功能特性方面与CCITT的V.24建议书一致,RS-449则与CCI...
-
ACCP软件工程师认证考试
ACCP体系课程针对低学历人群开设的软件课程。下面是小编收集的关于ACCP软件工程师认证考试,希望大家认真阅读!ACCP(AptechCertifiedComputerProfessional)是印度最早从事IT职业教育的Aptech计算机教育公司推出的培养软件程序设计人员的课程体系,由北大青鸟集团于...
-
ACCP7.0软件工程师课程介绍
ACCP7.0软件工程师课程是北大青鸟IT教育推出的第7个版本的ACCP课程,是目前北大青鸟IT教育推出的全新软件工程师职业教育课程,由中美印软件技术专家联合研发完成。职业教育就是就业教育,ACCP7.0作为业内领先的`IT职业教育产品,其最终目标无疑是帮助非IT行业人士找到...
相关文章
- How my school life has changed英语作文
- My favorite place of school 的优秀英语作文及其译文
- 英语美文:Olympic Fund Scratchcard Launched
- 六年级英语Unit 1 Welcome back to school教学设计
- 英语作文Why Are Bicycles So Commonly Used in China
- 初中英语What time do you go to school的教案设计
- 英语教案:Welcome back to school
- my happy school life英语作文
- 《Welcome back to school》的教案设计
- 《Welcome back to school 》教学设计