文件名称:Attandance_Trigger
- 所属分类:
- SQL Server数据库
- 资源属性:
- [SQL] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 1kb
- 下载次数:
- 0次
- 提 供 者:
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following:
a. Whenever the attendance is updated, check if the attendance is less than 85 if so, notify the Head of the Department concerned.
b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40 if so, notify the Head of the Department concerned.-Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following:
a. Whenever the attendance is updated, check if the attendance is less than 85 if so, notify the Head of the Department concerned.
b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40 if so, notify the Head of the Department concerned.
a. Whenever the attendance is updated, check if the attendance is less than 85 if so, notify the Head of the Department concerned.
b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40 if so, notify the Head of the Department concerned.-Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following:
a. Whenever the attendance is updated, check if the attendance is less than 85 if so, notify the Head of the Department concerned.
b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40 if so, notify the Head of the Department concerned.
(系统自动生成,下载前可以参看下载内容)
下载文件列表
Attandance_Trigger.sql