page3

5. ¤ÇÒÁÊÑÁ¾Ñ¹¸ì¢Í§µÒÃÒ§¢éÍÁÙÅ

¡ÒÃÍÍ¡áºº°Ò¹¢éÍÁÙÅ¹Ñé¹¨ÐµéÍ§ÍÍ¡áºº°Ò¹¢éÍÁÙÅãËéÁÕ¤ÇÒÁÊÑÁ¾Ñ¹¸ì¡Ñ¹â´ÂáÂ¡¢éÍÁÙÅ·ÕèÁÕâÍ¡ÒÊ«éÓ«éÍ¹¡Ñ¹
ÍÍ¡ä»äÇéÍÕ¡µÒÃÒ§Ë¹Öè§ àÃÕÂ¡¡ÒÃÍÍ¡áºº°Ò¹¢éÍÁÙÅáºº¹ÕéÇèÒ °Ò¹¢éÍÁÙÅáººÊÑÁ¾Ñ¹¸ì (Relational) °Ò¹¢éÍÁÙÅ·ÕèàÃÒÍÍ¡áººäÇé¨Ö§ÁÕ¤ÇÒÁÊÑÁ¾Ñ¹¸ì¡Ñ¹´Ñ§µèÍä»¹Õé

¨Ò¡ÃÙ»¨ÐáÊ´§ãËéàËç¹¶Ö§¤ÇÒÁÊÑÁ¾Ñ¹¸ì¢Í§µÒÃÒ§¢éÍÁÙÅ «Öè§Í¸ÔºÒÂä´é´Ñ§¹Õé

1. µÒÃÒ§ Student ¨Ðà»ç¹µÒÃÒ§¢éÍÁÙÅÃÒÂÅÐàÍÕÂ´¢Í§¹Ñ¡àÃÕÂ¹¨Ðà»ç¹ µÒÃÒ§ËÅÑ¡«Öè§ÁÕ Stud_id (ÃËÑÊ¹Ñ¡àÃÕÂ¹)à»ç¹¤ÕÂìËÅÑ¡·Õèãªéã¹ ¡ÒÃ¤é¹ËÒ¢éÍÁÙÅ¹Ñ¡àÃÕÂ¹¢Öé¹ÁÒáÊ´§ áÅÐ¤ÕÂìËÅÑ¡¹Õé¨Ðä» àª×èÍÁâÂ§¡ÑºµÒÃÒ§ prawat «Öè§à¡çº¢éÍÁÙÅ¤ÇÒÁ»ÃÐ¾ÄµÔ ¢Í§¹Ñ¡àÃÕÂ¹áµèÅÐ¤¹ÍÂÙè ã¹µÒÃÒ§¹ÕéÂÑ§ÁÕ class à»ç¹¤ÕÂìàª×èÍÁâÂ§«Öè§¨Ðä»àª×èÍÁ¡ÑºµÒÃÒ§ class à¾×èÍ¹Ó¢éÍÁÙÅªÑé¹áÅÐËéÍ§¢Öé¹ÁÒáÊ´§
2. µÒÃÒ§ prawat à»ç¹µÒÃÒ§à¡çº¤ÇÒÁ»ÃÐ¾ÄµÔ¢Í§¹Ñ¡àÃÕÂ¹«Öè§ÁÕÃËÑÊ¹Ñ¡àÃÕÂ¹ à»ç¹¤ÕÂìàª×èÍÁâÂ§¡ÑºµÒÃÒ§ Student
3. µÒÃÒ§ class à »ç¹µÒÃÒ§à¡çº¢éÍÁÙÅ¢Í§ËéÍ§àÃÕÂ¹ÇèÒËéÍ§¹ÕéÁÕÍÒ¨ÒÃÂì¤¹ äË¹à»ç¹ÍÒ¨ÒÃÂì»ÃÐ¨ÓªÑé¹ «Öè§¨ÐÁÕ¤ÕÂì teach_id à»ç¹¤ÕÂìàª×èÍÁâÂ§¡ÑºµÒÃÒ§ Teacher «Öè§¨Ðä»âÂ§àÍÒ ÃÒÂÅÐàÍÕÂ´¢Í§ÍÒ¨ÒÃÂì»ÃÐ¨ÓªÑé¹¢Öé¹ÁÒáÊ´§ÍÕ¡·Í´Ë¹Öè§
4. µÒÃÒ§ Teacher à»ç¹µÒÃÒ§à¡çº¢éÍÁÙÅ¢Í§ÍÒ¨ÒÃÂì«Öè§ÁÕ teach_id à»ç¹¤ÕÂìËÅÑ¡áÅÐ¤ÕÂìàª×èÍÁâÂ§¡ÑºµÒÃÒ§ class áÅÐÁÕ depart_id à»ç¹¤ÕÂìàª×èÍÁâÂ§¡ÑºµÒÃÒ§ department à¾×èÍÃÐºØÇèÒÍÒ¨ÒÃÂìÊÑ§¡Ñ´ÍÂÙèã¹ÀÒ¤ÇÔªÒã´
5. µÒÃÒ§ department à»ç¹µÒÃÒ§à¡çºÃÒÂÅÐàÍÕÂ´¢Í§ÀÒ¤ÇÔªÒ·ÕèÍÒ¨ÒÃÂì ÊÑ§¡Ñ´ÍÂÙè¨ÐÁÕ depart_id à»ç¹¤ÕÂìËÅÑ¡áÅÐ¤ÕÂìàª×èÍÁâÂ§