本區搜索:
Yahoo!字典
打印

[ICT] 求救 急 SQL

[隱藏]

求救 急 SQL

我知呢幅ER diagram有好多錯處
但可唔可以幫我轉番SQL
有錯請指正 麻煩曬


Reports/ Queries and its functions / operations
SQL :  DQL(select…from…where…group by…having…orderby…union) /

DML(update, delete, insert)


2
Findthe number of sick leaves / casual leaves / absent from school for eachstudent.
2
Findthe number of late for each student.
2
Findthe number of late for each class.
2
Listthe students who have late submission of homework for 5 times.
2
Listthe students who have non-submission of homework.
2
Findthe number of late submission of homework for each student.
2
Findall complaints which are given by a specific prefect.
2
Findall punishments which are given by a specific teacher.
2
Listthe students who got a parent’s notice.


Formsand its functions
2
Allow prefects to enter a new complaint.
2
Allow teacher to give demerit to students.
2
Add an new pubishment event.
附件: 您所在的用戶組無法下載或查看附件
   

TOP

重要聲明:小卒資訊論壇 是一個公開的學術交流及分享平台。 論壇內所有檔案及內容 都只可作學術交流之用,絕不能用商業用途。 所有會員均須對自己所發表的言論而引起的法律責任負責(包括上傳檔案或連結), 本壇並不擔保該等資料之準確性及可靠性,且概不會就因有關資料之任何不確或遺漏而引致之任何損失或 損害承擔任何責任(不論是否與侵權行為、訂立契約或其他方面有關 ) 。