104_2 Database System Design

請同學們尊重智慧財產權，請支持正版書籍，

影印不得超過合理使用範圍

勿使用及購買非法軟體、影音等資料

引用他人著作需經授權

News:

• WAMP server :http://www.wampserver.com/en/
• XAMPP : https://www.apachefriends.org/zh_tw/index.html
  • for XP: http://120.126.17.61:5000/fbsharing/9AEBf4cJ
• APPServ：https://www.appservnetwork.com/en/

Course:

Term:

Level:

Undergraduate

Instructor:

Prof. Yi-Ping Chao

Email: yiping(at)mail.cgu.edu.tw

Phone: ext. 5469

Office: 4^th floor, the management building

Course time:

Monday / 6-8 (14:10-17:00)

Office hours:

Tuesday/ 1-4, 6-8

Thursday /1-4, 6-8

Course location

資工系電腦教室

Textbook

• 資料庫系統理論與應用 (Database System Concepts, 6e), 東華書局

Addition materials and references

TA

• 資工所碩二 黃世凱

Quiz

• 20160328 Quiz 1

Attendance

Homework solutions

Lecture slides

• Week 1: Course Overview downoload
• Week 2: Holiday
• Week 3: Introduction download
• Week 4: Relational Model-1 download
• Week 5: Relational Model-2 download
• Week 6: Quiz
• Week 7: Introduction of SQL
• Week 8: Introduction of SQL
• Week 9: SQL
• Week 10: ER Model
• Week 11: Mideterm Exam
• Week 12: PHP
• Week 13: C#
• Week 14: Midterm report
• Week 15: ER Model download
• Week 16: Normalization download
• Week 17: Storage&File Structure Index&Hashing
• Week 18: Final Project Demo