KTUGFaq

KTUG FAQ

·Î±×ÀÎ:
ºñ¹Ð¹øÈ£:
°¡ÀÔ
You will step on the soil of many countries.
FrontPage › MakingExam
µµÀºÀ̾ƹö´ÔÀÇ hexam.cls¸¦ ÀÌ¿ëÇÑ mySQL°ú phpµîÀ» ÀÌ¿ëÇؼ­ DB¿Í TeXÀÇ ¿¬µ¿À» ½ÇÇèÇØ º¼·Á°í ÇÕ´Ï´Ù. À̹øÀº DB pool¸¦ ÀÌ¿ëÇؼ­ ¹«ÀÛÀ§ÀûÀ¸·Î ¹®Á¦¸¦ ÃâÁ¦ ÇÒ ¼ö ÀÖ°Ô ÇÒ·Á°í ÇÕ´Ï´Ù. ¾ó¸¶³ª µµ¿òÀÌ µÉ·ÃÁö´Â ¸ð¸£°ÚÁö¸¸¿ä. ¶ÇÇÑ KLDP¿¡¼­ vi like editor on WEBÀÇ Åä·Ð°ú ÇÔ²² ÀÖ´Â editor¿¡ ´ëÇÑ °ÍÀ» ¸¹ÀÌ ÂüÁ¶ ÇÏ·Á°í ÇÕ´Ï´Ù.

¸ñÂ÷

1 °³¿ä
1.1 DB ¼³°è¿¡ ´ëÇÑ °³¿ä
1.2 WebEditor ¸¸µé±â¿¡ ´ëÇÑ °³¿ä
1.3 MainÈ­¸éÀÇ ¼³°è¿¡ ´ëÇÑ °³¿ä
1.4 DB ÀúÀå½Ã html¹®¼­·Î ÀúÀåÇϱâ

1 °³¿ä

1.1 DB ¼³°è¿¡ ´ëÇÑ °³¿ä

HExamMain table¼³°è
  • idOfMain : int(10) unsigned not null auto_increment,
  • CategoryOfAnswer : char(20) not null,¹®Á¦´Â ¾î¶² Ç׸ñ¿¡ ¼ÓÇϴ°¡? ¾î´À chapter¿¡ ¼ÓÇϴ°¡?
  • TypeOfQuestion : char(2) not null,¹®Á¦ÀÇ À¯ÇüÀÔ´Ï´Ù. °´°ü½Ä(SC),multiplechoice(MC), ´Ü´ä½Ä(SS), ¾à¼ú½Ä(MS), ¹®Á¦ ¼­¼úÇÏ°í ³­ÈÄ¿¡ ¿©·¯ ¹®Ç×(LA)
  • AbstractOfQuestion : char(200) not null, ¹®Á¦¿¡ ´ëÇÑ °³¿äÀÌ´Ù.
  • LANumberOfQuestion : smallint null,LAÇüÀ϶§ ¹®Á¦ÀÇ ¼öÀÔ´Ï´Ù.
  • QustionOrList : text not null, ¹®Á¦ÀÔ´Ï´Ù.
  • Choice : char(500) null, ¹®Á¦Áß Ç׸ñÀÔ´Ï´Ù.
  • AnswerChoice : smallint null,°´°ü½Ä ´äÀÔ´Ï´Ù.
  • AnswerString : text null,ÁÖ°ü½Ä ´äÀÔ´Ï´Ù.
  • PointofQuestion : smallint not null,¹®Á¦´Â ¸îÁ¡Àΰ¡¿ä?
  • DateOfAnswer : datetime not null,¹®Á¦¸¦ ¾ðÁ¦ ³Â´Â°¡¿¡ ´ëÇÑ °ÍÀÔ´Ï´Ù. PoolÁßÀÇ ¹®Á¦´Â ¸î %, »õ·Î ÀÛ¼ºÇÑ ¹®Á¦´Â ¸î %¶ó°í ÇÒ ¶§ »ç¿ëÇÏ·Á°í ÇÕ´Ï´Ù.
  • GradeOfQuestion : smallint not null, ¹®Á¦ÀÇ ³­À̵µ¿¡ ´ëÇÑ °ÍÀÔ´Ï´Ù.

create table HExamMain (
idOfMain int unsigned not null auto_increment primary key, CategoryOfAnswer char(20) not null, TypeOfQuestion char(2) not null, AbstractOfQuestion varchar(200) not null LANumberOfQuestion smallint null, QuestionOrList varchar(500) not null, Choice varchar(500) null, AnswerChoice smallint null, AnswerString varchar(500) null, PointOfQuestion smallint not null, DateOfAnswer datetime not null, GradeOfQuestion smallint not null) ENGINE=INNODB;

LAHExam table
  • LAid : int(10) unsigned not null auto_increment, primary key
  • idOfMain : int(10) unsigned not null , idOfMainÂüÁ¶°ª
  • CategoryOfAnswer : char(20) not null,¹®Á¦´Â ¾î¶² Ç׸ñ¿¡ ¼ÓÇϴ°¡? ¾î´À chapter¿¡ ¼ÓÇϴ°¡?
  • TypeOfQuestion : char(2) not null,¹®Á¦ÀÇ À¯ÇüÀÔ´Ï´Ù. °´°ü½Ä(SC),multiplechoice(MC), ´Ü´ä½Ä(SS), ¾à¼ú½Ä(MS), ¹®Á¦ ¼­¼úÇÏ°í ³­ÈÄ¿¡ ¿©·¯ ¹®Ç×(LA)
  • QustionOrList : text not null, ¹®Á¦ÀÔ´Ï´Ù.
  • Choice : char(500) null, ¹®Á¦Áß Ç׸ñÀÔ´Ï´Ù.
  • AnswerChoice : smallint null,°´°ü½Ä ´äÀÔ´Ï´Ù.
  • AnswerString : text null,ÁÖ°ü½Ä ´äÀÔ´Ï´Ù.
  • PointofQuestion : smallint not null,¹®Á¦´Â ¸îÁ¡Àΰ¡¿ä?
  • DateOfAnswer : datetime not null,¹®Á¦¸¦ ¾ðÁ¦ ³Â´Â°¡¿¡ ´ëÇÑ °ÍÀÔ´Ï´Ù. PoolÁßÀÇ ¹®Á¦´Â ¸î %, »õ·Î ÀÛ¼ºÇÑ ¹®Á¦´Â ¸î %¶ó°í ÇÒ ¶§ »ç¿ëÇÏ·Á°í ÇÕ´Ï´Ù.
  • GradeOfQuestion : smallint not null, ¹®Á¦ÀÇ ³­À̵µ¿¡ ´ëÇÑ °ÍÀÔ´Ï´Ù.

create table LAHExam (
LAid int unsigned not null auto_increment primary key, CategoryOfAnswer char(20) not null, TypeOfQuestion char(2) not null, AbstractOfQuestion varchar(200) not null, QuestionOrList varchar(500) not null, Choice varchar(500) null, AnswerChoice smallint null, AnswerString varchar(500) null, PointOfQuestion smallint not null, DateOfAnswer datetime not null, GradeOfQuestion smallint not null, Pa_IdOfMain int, INDEX ParIdOfMain(Pa_IdOfMain) FOREIGN KEY (Pa_IdOfMain) REFERENCE HExamMain(IdOfMain) ON DELETE CASCADE
) ENGINE=INNODB;

FigureOfQuestion table
  • idOfFigure : int(10) unsigned not null auto_increment, primary key
  • idOfMain int(10) unsigned null, HExamMain tableÂüÁ¶
  • LAid int(10) unsigned null, LAHExam tableÂüÁ¶
  • file_path
  • file_name
  • file_name2
  • file_size

¿©±â¿¡ ÇÑ°¡Áö ´õ ÇÑ´Ù°í ÇϸéÀº ¾Æ¸¶µµ ÀÎÁõ½Ã¿¡ ÇÊ¿äÇÑ tableÁ¤µµÀÏ °Í °°´Ù.

1.2 WebEditor ¸¸µé±â¿¡ ´ëÇÑ °³¿ä

ÀÌ¿Ü·Î phpschool.com¿¡ °¬´õ´Ï ¸¹Àº ÀÚ·á°¡ ÀÖ´Ù. ÀÌÀü¿¡ WebTeX¸¸µé±â¿¡¼­ »ç¿ëÇÑ ¹æ¹ýÀº ¾îµð¼­ º¸Áöµµ µèÁöµµ ¸øÇÑ ¹æ¹ýÀÌ´Ù. ¿ª½Ã ã´Â ¸¸Å­ º¸ÀÌ´Â °¡ º¸´Ù.

1.3 MainÈ­¸éÀÇ ¼³°è¿¡ ´ëÇÑ °³¿ä

  • ÀÔ·Â ºÎºÐ: WebEditor¸¦ ÀÌ¿ëÇÏ°í ´Ù¸¥ ºÎºÐµéÀ» ÀûÀýÈ÷ ÀÌ¿ëÇؼ­ ¾à 4°³Á¤µµÀÇ ÀÔ·ÂâÀ» ¸¸µé·Á°í ÇÑ´Ù. ±×¾ß ¸»·Î mainâ ¹®Á¦À¯Çü¹× category¿Í ¹®Á¦¿¡ discriptionÀÌ ´ã°ÜÁ® ÀÖ´Â ºÎºÐ --> ¿©±â¼­ ¹®Á¦ À¯ÇüÀÌ ³ª¿À¸é °´°ü½Ä, ÁÖ°ü½Ä, ¼­¼úÈÄ¿¡ °´°ü½Ä ÁÖ°ü½ÄÀÌ ³ª¿À´Â ÇüÅÂÀÌ´Ù.
    • Á» ´õ ½Ã°£ÀÌ ³ª¸é ±âÁ¸ÀÇ ¹®¼­¸¦ ±×³É º¹»çÇØ ¿Í¼­ ºÙ¿´À»¶§ ÀûÀýÈ÷ htmlÈ­ ÇØ ÁÖ´Â ±â´Éµµ Çѹø »ý°¢ÇØ º¸ÀÚ.
  • ¼öÁ¤ ºÎºÐ : ÀÌ ºÎºÐ¿¡¼­´Â TeX source¸¦ ¶ÇÇÑ html·Î ¹Ù²Ù´Â °ÍÀÌ ÇÊ¿äÇÒµí ÇÏ´Ù. ¾îÂî µÇ¾ú´ø º¸¶§±æ ÀÏÀÌ´Ù.
  • ã¾Æº¸±â ºÎºÐÀº : category·Î ã±â(ÀÏÀü¿¡ Çß´ø °Í °°ÀÌ ±×³É À§¿¡¼­ ¾Æ·¡·Î Âß ³ª¿­ÇÏ´Â ½ÄÀÌ ¾Æ´Ñ paging(?) À̶ó°í ÇÏ´Â technique¸¦ ÀÌ¿ëÇÒ °Í, abstract(°³¿ä)·Î ã±â, ³¯Â¥·Î ã±âµî ÀÌ»ó ´õ ÇÊ¿äÇÑ°ÍÀÌ ÀÖÀ»±î¿ä?
  • Áö¿ì±â
  • TeX¸¸µé±â
  • ½ÃÇè¹®Á¦ ¸¸µé±â µîÀÔ´Ï´Ù.

1.4 DB ÀúÀå½Ã html¹®¼­·Î ÀúÀåÇϱâ

  • DB ÀúÀå½Ã htmlÇüÅ·ΠÀúÀåÇϱâ·Î Çß´Ù. ¹°·Ð ¸ðµç Ç׸ñÀ» ´Ù ±×·¸°Ô ÀúÀåÇÒ ÇÊ¿ä´Â ¾øÁö¸¸ html·Î ÀúÀåÇÏ´Â °ÍÀÌ ³ªÁß¿¡ ã¾Æº¸±â ÇßÀ»¶§ ¿øº» ±×´ë·ÎÀÇ ´À³¦À» °¡Áú¼ö ÀÖÀ»µí Çؼ­ÀÌ´Ù.
  • htmltolatex ¶ó´Â java programÀÌ ÀÖ´Ù. ÀÌ°ÍÀ» »ç¿ëÇÏ·Á°í ÇÑ´Ù. ¾îµð±îÁö µÉ·±Áö´Â Àǹ®ÀÌÁö¸¸, ¿ì¸® °Í °°ÀÌ °£´ÜÇÑ °ÍÀ» ÃæºÐÈ÷ °¡´ÉÇϸ®¶ó »ý°¢ÇÑ´Ù. http://htmltolatex.sourceforge.net/ ¿©±â¿¡¼­ down¹Þ¾Æ¼­ ½ÇÇàÇØ º¸´Ï ±×·±´ë·Î µÇ´Âµí ½Í´Ù.

^
Valid XHTML 1.0! Valid CSS! powered by MoniWiki
last modified 2006-11-28 07:39:38
Processing time 0.2075 sec