<div>저번에 DBMS를(SQL,Mysql,DB2 등과같은) 연동없이 만들라는 과제를 받은 유학생입니다.</div> <div>다름이아니라 </div> <div>지금 select~ from~ where~ group by~ having~;</div> <div>부분을 인터페이스로 만들어야하는데 select는 from에서 고른 테이블의 attributes들을 고를 수있다고 하는데 where 부터 어떻게 구현할지를 모르겠네요</div> <div>ㅠㅠ 조언좀 부탁드립니다.</div> <div><br /></div> <div><br /></div> <div>지금 생각해놓은 부분은</div> <div>1.From 부분에서 테이블을 선택해줍니다. 더 필요할시 'add'를 만들어 추가하는방식입니다.</div> <div>(테이블네임 중복되면 에러메세지,from에서 테이블 고르는 방식은 콤보박스 방식으로)</div> <div><br /></div> <div><br /></div> <div>2.select 부분에서는 from에서고른 테이블에 속해있는 attributes 들을 고를수있게 선택 합니다.</div> <div>(아직 sum(),avg(),max(),min() 등,이부분은 어떻게 만들어 볼지 생각을 못했습니다)</div> <div><br /></div> <div><br /></div> <div><br /></div> <div><br /></div> <div>이것은 채점기준인데 ...혹시라도 생각해놓은 부분중 잘못생각하고 있는부분이나, 좋은 조언있으시면 부탁드립니다.</div> <div>절말 간절히 조언 부탁드립니다.</div> <div> <p class="MsoListParagraph" align="left" style="margin-left: 36pt; text-indent: -36pt; line-height: 150%"><b><span lang="EN-US" style="font-size: 14pt; line-height: 150%; font-family: 'Times New Roman', serif">.<span style="font-weight: normal; font-size: 7pt; line-height: normal; font-family: 'Times New Roman'">                  </span></span></b><b><span lang="EN-US" style="font-size: 14pt; line-height: 150%; font-family: 'Times New Roman', serif">Grading rule of Practice<o:p></o:p></span></b></p> <p class="MsoListParagraph" style="margin-left: 42.5pt; text-indent: 0cm; line-height: 150%"><b><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif; color: red">The DBMS project composes 30%, see the detail in Table 1.<o:p></o:p></span></b></p> <p class="MsoListParagraph" style="margin-left: 63.5pt; text-indent: -21pt; line-height: 150%"><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: SimSun">•<span style="font-size: 7pt; line-height: normal; font-family: 'Times New Roman'">    </span></span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">Create(database, table) </span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">（</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">5 points</span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">）</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif"><o:p></o:p></span></p> <p class="MsoListParagraph" style="margin-left: 63.5pt; text-indent: -21pt; line-height: 150%"><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: SimSun">•<span style="font-size: 7pt; line-height: normal; font-family: 'Times New Roman'">    </span></span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">Simple Select </span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">（</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">select-from-where, 5 points</span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">）</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif"><o:p></o:p></span></p> <p class="MsoListParagraph" style="margin-left: 63.5pt; text-indent: -21pt; line-height: 150%"><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: SimSun">•<span style="font-size: 7pt; line-height: normal; font-family: 'Times New Roman'">    </span></span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">Comlex Select </span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">（</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">select-from-where-group by having, 5 points</span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">）</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif"><o:p></o:p></span></p> <p class="MsoListParagraph" style="margin-left: 63.5pt; text-indent: -21pt; line-height: 150%"><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: SimSun">•<span style="font-size: 7pt; line-height: normal; font-family: 'Times New Roman'">    </span></span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">Insert </span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">（</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">5 points</span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">）</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif"><o:p></o:p></span></p> <p class="MsoListParagraph" style="margin-left: 63.5pt; text-indent: -21pt; line-height: 150%"><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: SimSun">•<span style="font-size: 7pt; line-height: normal; font-family: 'Times New Roman'">    </span></span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">Update </span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">（</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">5 points</span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">）</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif"><o:p></o:p></span></p> <p class="MsoListParagraph" style="margin-left: 63.5pt; text-indent: 0cm; line-height: 150%"><span lang="EN-US" style="font-family: SimSun">•<span style="font-size: 7pt; line-height: normal; font-family: 'Times New Roman'">   </span></span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">Delete </span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">（</span><span lang="EN-US" style="font-size: 12pt; line-height: 150%; font-family: 'Times New Roman', serif">5 points</span><span lang="ZH-CN" style="font-size: 12pt; line-height: 150%; font-family: SimSun">）</span><span lang="EN-US"><o:p></o:p></span></p></div>