我知呢幅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.