Lecture Note:Introduction to Database System and Applications
in place January 25, 2002, last modified March 22, 2002

---

¸ñÇ¥: Database¸¦ ÀÌÇØÇÏ°í À̸¦ ÀÌ¿ëÇÏ¿© Web ±â¹Ý ÀÀ¿ë ½Ã½ºÅÛÀ» ¼³°è ±¸ÇöÇÒ ¼ö ÀÖ´Â ´É·Â

1. Database ±¸Á¶ ¹× ±â´É¿¡ ´ëÇÑ ÀÌÇØ
2. Database ¼³°è ¹× Data ¿î¿ë ¹æ¹ý ½Àµæ - SQL
3. Web ÀÀ¿ë ½Ã½ºÅÛ È¯°æ ÀÌÇØ - HTTP, HTML, Web Server, CGI , etc.
4. Web ÀÀ¿ë System ¿¡ Database »ç¿ë ¹æ¹ý ½Àµæ

Contents Edition 1.0

ID	Title	Note
Class #01:	ÀÚ·á°ü¸® °³¿ä Introduction to Information Management	Ice Break
Class #02:	µ¥ÀÌŸº£À̽º °ü¸® ½Ã½ºÅÛ °³¿ä Introduction to Database Management System	-
Class #03:	µ¥ÀÌŸ ¸ðµ¨¸µ(1) Data Modeling	-
Class #04:	µ¥ÀÌŸ ¸ðµ¨¸µ(2) Data Modeling	Homework #01
Class #05:	°ü°èÇü µ¥ÀÌŸº£À̽º ÀÌ·Ð Relational Database (1)	-
Class #06:	°ü°èÇü µ¥ÀÌŸº£À̽º ÀÌ·Ð Relational Database (2)	-
Class #07:	°ü°èÇü µ¥ÀÌŸº£À̽º ¼³°è Relational Database Design (1)	-
Class #08:	Mid. Term	Exam
Class #09:	°ü°èÇü µ¥ÀÌŸº£À̽º ¼³°è Relational Database Design (2)
Class #10:	Ŭ¶óÀ̾ðÆ® ¼­¹ö µ¥ÀÌŸº£À̽º °³¹ß (1)	-
Class #11:	Ŭ¶óÀ̾ðÆ® ¼­¹ö µ¥ÀÌŸº£À̽º °³¹ß (2)	Homework #02
Class #12	WWW, Web Server, HTML, CGI	-
Class #13:	Web µ¥ÀÌŸº£À̽º ÀÀ¿ë ½Ã½ºÅÛ °³¹ß(1)
Class #14:	±â¾÷¿ë Database ¼Ò°³ - MRP (Material Resouce Planning½Ã½ºÅÛ ¼Ò°³)
Class #15:	Web µ¥ÀÌŸº£À̽º ÀÀ¿ë ½Ã½ºÅÛ °³¹ß(2)	presentation
Class #16:	Final Exam.	Exam

• Homework #01 : Entity Relation Model - ºÎÇ°°ú Á¶¸³Ç°À¸·Î ±¸¼ºµÈ Á¦Ç°±¸Á¶¸¦ Ç¥ÇöÇÏ´Â ERD¸¦ ±×¸®½Ã¿À.
  ´Ü ÀÌ ¸ðµ¨Àº Á¦Ç°Á¦ÀÛ¿¡ ÇÊ¿äÇÑ Lead time°ú qty¸¦ °è»êÇÒ ¼ö ÀÖ¾î¾ß ÇÔ(¾Ë°í¸®µë ¼­¼ú ÷ºÎ¿ä)
• Homework #02 : Schema Design - ¼÷Á¦ 2ÀÇ °á°úÀÎ ERD¸¦ ¹ÙÅÁÀ¸·Î Database Schema¸¦ ÀÛ¼ºÇϽÿÀ.
  Schema´Â Ç¥ÁØ SQL ÀÇ DDL(Data Definition Language)¸¦ ÀÌ¿ëÇÏ¿© Ç¥ÇöÇϽÿÀ.

  >> ¼÷Á¦ Á¦Ãâ Page

Á¡¼ö¹èºÐ: Áß°£°í»ç(30%) + Çб⸻°í»ç(40%) + ¼÷Á¦(20%) + Ãâ¼® ¹× ŵµ(10%)

---

Knowledge & Engineering Databases (c) copyright Namchul Do, 2002