|
|
¡@
¡P Elmasri, R. & Navathe S. (2004)¡C¸ê®Æ®w¨t²Î·§½×¡]Fundamentals of Database Systems,
4th ed.¡^¡]¨H¿ø©[¼f¾\/¬_¨Î§D½sĶ¡^¡C
»O¥_¥«¡G»OÆW°ö¥Í±Ð¨|¥Xª©ªÑ¥÷¦³¤½¥q¡C (°ª¥ß¹Ï®Ñ¤½¥q¸g¾P ¡A¹q¸Ü¡G22900318)
¡P Silberschatz, A.,
Kotth, H. F., & Sudarshan,
S. (2005)¡C¸ê®Æ®w¨t²Î²z½×»PÀ³¥Î¡]Database
System Concepts, 5th ed.¡^¡]±ç¿üë¡B§õµØ´IĶ/¬_¨Î§D¡B¨H¿ø©[½sĶ¡^¡C »O¥_¥«¡G¬ü°Ó³Á®æù¡E§Æº¸°ê»ÚªÑ¥÷¦³¤½¥q¡C (°ª¥ß¹Ï®Ñ¤½¥q¸g¾P ¡A¹q¸Ü¡G22900318)
¡P Hoffer, J. A.,
Prescott, M. B., & McFadden, F. R. (2004)¡C¸ê®Æ®wºÞ²z¡]Modern
Database Management¡^¡]³¯¼z¥É¥D½s¡^¡C»O¥_¥«¡G»OÆW°ö¥Í±Ð¨| ¥Xª©ªÑ¥÷¦³¤½¥q¡C¡]ùÖ®p¸ê°TªÑ¥÷¦³¤½¥q¸g¾P¡A¹q¸Ü¡G27882408¡^
¡P Elmasri, R. & Navathe S. (2004). Fundamentals of Database Systems,
4th ed.
¡P 20% Home Works
¡P 30% Mid Term Exam.
¡P 30% Final Exam.
¡P 15% Term Project
¡P 5% In-class
Response
The naming scheme for
your homework in electronic version: DB2009HWNOID.DOC
where NO denotes the number of HW, and ID denotes your student ID. For example,
your ID is B86106055 and the work is the second HW. Therefore, the name
for your work should be DB2009HW02B86106055.DOC.
¡@
Lecture
Schedule (Tentative)
¡@ |
01. |
|
Introduction |
¡@ |
02. |
|
Data
Model |
¡@ |
03. |
|
ER
Model [HW01]
ú¥æ¤é´Á¡G |
¡@ |
04. |
|
Enhanced
ER Model I |
¡@ |
05. |
|
Enhanced
ER Model II |
¡@ |
06. |
|
Relational
Data Model I |
¡@ |
07. |
|
Relational
Data Model II [HW02]
ú¥æ¤é´Á¡G |
¡@ |
08. |
|
Transform
ER Model to Relational Data Model [HW03]
ú¥æ¤é´Á¡G |
¡@ |
09. |
|
MIDTERM
EXAM. |
¡@ |
10. |
|
Relational
Algebra I Term
Project¤À²Õ¦W³æú¥æ The
symbols for relational algebra operators: [click
here] |
¡@ |
11. |
|
Relational
Algebra II [HW04] ú¥æ¤é´Á¡G |
¡@ |
12. |
|
SQL [HW05]
ú¥æ¤é´Á¡G [Sample SQL
statements] [Running SQL via
Web (test)] |
¡@ |
13. |
|
Normalization
I |
¡@ |
14. |
|
Normalization
II [HW06]
ú¥æ¤é´Á¡G |
¡@ |
15. |
|
Transaction |
¡@ |
16. |
|
Concurrent
Control I |
¡@ |
17. |
|
Concurrent
Control II [Term
Project] ú¥æ¤é´Á¡G |
¡@ |
18. |
|
FINAL
EXAM. |
¡@
Other Information