Conclusion

    To conclude, overall most of the function can be operated normally. All possible typing problems during each inputting process can be found out and deleted.

    Before enrollment

       The grade of the students are generated by a SQL. However, this need to be done every year and the SQL to update the grade of the student need to be modified every year , so program-data redundency occured. To solve this, the

    Online enrollment

       The

l       Result Reporting

--------------------SQL---------------------- 

        Creat view [event_name] as

      SELECT a1.Name, a1.Sales, COUNT(a2.sales) Sales_Rank
FROM Total_Sales a1, Total_Sales a2
WHERE a1.Sales <= a2.Sales or (a1.Sales=a2.Sales and a1.Name = a2.Name)
GROUP BY a1.Name, a1.Sales
ORDER BY a1.Sales DESC, a1.Name DESC; 

http://www.1keydata.com/tw/sql/sql-rank.html

考完會考差唔多成個禮拜了∼∼∼非常無聊∼∼失去既野太多了．．單單上個禮拜已經．．．
仲未好接受到現實．．．．或者真係好似其他人咁講．．．等時間＜衝＞淡．．．
ｅ個禮拜完全冇野做．．．真係好想搵ｄ野做下．．．．
唔通．．．真係要以何中amaths第一人之名．．去搵補習做下＝　＝．．．．
p.s.我諗都冇人會睇嫁啦∼ｅ個qooza就黎變做我既發洩地方．．．．

足足成個月冇打過野添∼∼
ｅ排都係咁啦．．．日日唔係溫書就打機∼唔係打機就食飯∼唔係食飯就係訓覺∼日日如是（ｐ．ｓ打機為主）
人考ｃｅ∼我考ｃｅ∼點解我會咁ｈｅａ＝０＝．．．
就黎踏入第三個月∼∼希望會一路落去∼/\/\．．．雖然有時都有ｄ辛苦．．但都係值得既∼
搵錢大計仲未ｐｌａｎ好．．．點知突然有彈出一個升學大計＝０＝．．要轉校原來都幾難．．仲要出沙田區添><
可能因為少打野既關係∼∼冇密人入黎＝　＝．．．．．睇遲ｅ邊就黎要ｃｌｏｓｅ∼
今次可能係ｃｅ之前最後一次打．．．大家再見了∼∼

subject:phy
頭一次完完整整咁完成LQ∼諗住都冇咁易嫁啦∼
結果．．．係MC．．．完完整整咁．．．失敗左－０－
不過還是算了∼最後決戰．．係ｃｅ．．ｍｏｃｋ只係一個ｇａｍｅ  XD
放學∼如常∼∼已經習慣了XD
找ｊｅｆｆ佢地食飯∼緊住去社區中心溫書∼
其實都冇密溫過．．．不過諗左好多野∼
要開始plan下先得∼
唉∼之前仲諗住搵下補習．．．但睇黎搵唔到人會肯比我補嫁啦＝　＝想搵返小小錢都唔得．．．．．
明天大戰中文∼要努力= =