<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head> <meta http-equiv="Content-Type" content="text/html; charset=unicode"> <meta name="ProgId" content="Word.Document"> <meta name="Generator" content="Microsoft Word 14"> <meta name="Originator" content="Microsoft Word 14"> <link rel="File-List" href="js-21.files/filelist.xml"><title>򹟖򠲸00謯焄2</title><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>muraoka-lab</o:Author> <o:Template>Normal</o:Template> <o:LastAuthor>mura-lab61</o:LastAuthor> <o:Revision>22</o:Revision> <o:TotalTime>58</o:TotalTime> <o:Created>2010-05-27T06:29:00Z</o:Created> <o:LastSaved>2015-06-09T05:19:00Z</o:LastSaved> <o:Pages>4</o:Pages> <o:Words>345</o:Words> <o:Characters>1968</o:Characters> <o:Company>kochi-university</o:Company> <o:Lines>16</o:Lines> <o:Paragraphs>4</o:Paragraphs> <o:CharactersWithSpaces>2309</o:CharactersWithSpaces> <o:Version>14.00</o:Version> </o:DocumentProperties> </xml><![endif]--> <link rel="themeData" href="js-21.files/themedata.thmx"> <link rel="colorSchemeMapping" href="js-21.files/colorschememapping.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Print</w:View> <w:Zoom>BestFit</w:Zoom> <w:TrackMoves>false</w:TrackMoves> <w:TrackFormatting/> <w:DrawingGridHorizontalSpacing>6 pt</w:DrawingGridHorizontalSpacing> <w:DrawingGridVerticalSpacing>18.25 pt</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>2</w:DisplayHorizontalDrawingGridEvery> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>JA</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="&#45;-"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false" DefSemiHidden="false" DefQFormat="false" LatentStyleCount="267"> <w:LsdException Locked="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="caption"/> <w:LsdException Locked="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="99" Name="No List"/> <w:LsdException Locked="false" Priority="99" SemiHidden="true" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" Name="Light List"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" Priority="99" SemiHidden="true" Name="Revision"/> <w:LsdException Locked="false" Priority="34" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" SemiHidden="true" UnhideWhenUsed="true" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" SemiHidden="true" UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:"-3 񾷼򬿴"; panose-1:2 11 6 9 7 2 5 8 2 4; mso-font-alt:"MS Gothic"; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-536870145 1791491579 18 0 131231 0;} @font-face {font-family:"-3 񾷼򬿴"; panose-1:2 11 6 9 7 2 5 8 2 4; mso-font-alt:"MS Gothic"; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-536870145 1791491579 18 0 131231 0;} @font-face {font-family:"-3 0񾷼򬿴"; panose-1:2 11 6 0 7 2 5 8 2 4; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:variable; mso-font-signature:-536870145 1791491579 18 0 131231 0;} @font-face {font-family:"\@-3 0񾷼򬿴"; panose-1:2 11 6 0 7 2 5 8 2 4; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:variable; mso-font-signature:-536870145 1791491579 18 0 131231 0;} @font-face {font-family:"\@-3 񾷼򬿴"; panose-1:2 11 6 9 7 2 5 8 2 4; mso-font-charset:128; mso-generic-font-family:modern; mso-font-pitch:fixed; mso-font-signature:-536870145 1791491579 18 0 131231 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0mm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"-3 0񾷼򬿴"; mso-bidi-font-family:"-3 0񾷼򬿴";} h2 {mso-style-unhide:no; mso-style-qformat:yes; mso-style-link:"媺鶴W0 2 \(噀W[\)"; mso-margin-top-alt:auto; margin-right:0mm; mso-margin-bottom-alt:auto; margin-left:0mm; mso-pagination:widow-orphan; mso-outline-level:2; font-size:18.0pt; font-family:"-3 0񾷼򬿴"; mso-bidi-font-family:"-3 0񾷼򬿴";} h3 {mso-style-unhide:no; mso-style-qformat:yes; mso-style-link:"媺鶴W0 3 \(噀W[\)"; mso-margin-top-alt:auto; margin-right:0mm; mso-margin-bottom-alt:auto; margin-left:0mm; mso-pagination:widow-orphan; mso-outline-level:3; font-size:13.5pt; font-family:"-3 0񾷼򬿴"; mso-bidi-font-family:"-3 0񾷼򬿴";} p.MsoHeader, li.MsoHeader, div.MsoHeader {mso-style-unhide:no; mso-style-link:"󭩔򣽎 \(噀W[\)"; margin:0mm; margin-bottom:.0001pt; mso-pagination:widow-orphan; tab-stops:center 212.6pt right 425.2pt; layout-grid-mode:char; font-size:12.0pt; font-family:"-3 0񾷼򬿴"; mso-bidi-font-family:"-3 0񾷼򬿴";} p.MsoFooter, li.MsoFooter, div.MsoFooter {mso-style-unhide:no; mso-style-link:"󤚬򠸖 \(噀W[\)"; margin:0mm; margin-bottom:.0001pt; mso-pagination:widow-orphan; tab-stops:center 212.6pt right 425.2pt; layout-grid-mode:char; font-size:12.0pt; font-family:"-3 0񾷼򬿴"; mso-bidi-font-family:"-3 0񾷼򬿴";} a:link, span.MsoHyperlink {mso-style-unhide:no; color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-unhide:no; color:blue; text-decoration:underline; text-underline:single;} pre {mso-style-unhide:no; mso-style-link:"HTML 鴉_豊M0 \(噀W[\)"; margin:0mm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"-3 񾷼򬿴"; mso-bidi-font-family:"-3 񾷼򬿴";} span.2 {mso-style-name:"媺鶴W0 2 \(噀W[\)"; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"媺鶴W0 2"; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"Arial","sans-serif"; mso-ascii-font-family:Arial; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"-3 񾷼򬿴"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Arial; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi;} span.3 {mso-style-name:"媺鶴W0 3 \(噀W[\)"; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"媺鶴W0 3"; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"Arial","sans-serif"; mso-ascii-font-family:Arial; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"-3 񾷼򬿴"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Arial; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi;} span.HTML {mso-style-name:"HTML 鴉_豊M0 \(噀W[\)"; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"HTML 鴉_豊M0"; font-family:"Courier New"; mso-ascii-font-family:"Courier New"; mso-fareast-font-family:"-3 0񾷼򬿴"; mso-hansi-font-family:"Courier New"; mso-bidi-font-family:"Courier New";} span.a {mso-style-name:"󭩔򣽎 \(噀W[\)"; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:󭩔򣽎; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"-3 0񾷼򬿴"; mso-ascii-font-family:"-3 0񾷼򬿴"; mso-fareast-font-family:"-3 0񾷼򬿴"; mso-hansi-font-family:"-3 0񾷼򬿴"; mso-bidi-font-family:"-3 0񾷼򬿴";} span.a0 {mso-style-name:"󤚬򠸖 \(噀W[\)"; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:󤚬򠸖; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"-3 0񾷼򬿴"; mso-ascii-font-family:"-3 0񾷼򬿴"; mso-fareast-font-family:"-3 0񾷼򬿴"; mso-hansi-font-family:"-3 0񾷼򬿴"; mso-bidi-font-family:"-3 0񾷼򬿴";} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; mso-ascii-font-family:"Times New Roman"; mso-hansi-font-family:"Times New Roman"; mso-font-kerning:0pt;} @page WordSection1 {size:595.3pt 841.9pt; margin:99.25pt 30.0mm 30.0mm 30.0mm; mso-header-margin:42.55pt; mso-footer-margin:49.6pt; mso-paper-source:0; layout-grid:18.25pt;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:617491151; mso-list-type:hybrid; mso-list-template-ids:306075754 2113721174 67698699 67698701 67698689 67698699 67698701 67698689 67698699 67698701;} @list l0:level1 {mso-level-start-at:0; mso-level-number-format:bullet; mso-level-text:0; mso-level-tab-stop:18.0pt; mso-level-number-position:left; margin-left:18.0pt; text-indent:-18.0pt; font-family:"-3 0񾷼򬿴"; mso-bidi-font-family:"-3 0񾷼򬿴";} @list l0:level2 {mso-level-tab-stop:72.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l0:level3 {mso-level-tab-stop:108.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l0:level4 {mso-level-tab-stop:144.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l0:level5 {mso-level-tab-stop:180.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l0:level6 {mso-level-tab-stop:216.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l0:level7 {mso-level-tab-stop:252.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l0:level8 {mso-level-tab-stop:288.0pt; mso-level-number-position:left; text-indent:-18.0pt;} @list l0:level9 {mso-level-tab-stop:324.0pt; mso-level-number-position:left; text-indent:-18.0pt;} ol {margin-bottom:0mm;} ul {margin-bottom:0mm;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:j杗n0h; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0mm 5.4pt 0mm 5.4pt; mso-para-margin:0mm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} </style> <![endif]--><!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026"> <v:textbox inset="5.85pt,.7pt,5.85pt,.7pt"/> </o:shapedefaults></xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1"/> </o:shapelayout></xml><![endif]--></head><body style="" lang="JA" link="blue" vlink="blue"> <div class="WordSection1 HTML"> <h2><span style="font-size: 18pt;">򹟖򠲸00謯o 2</span></h2> <h2><span style="font-size: 18pt;"></span></h2> <ul> <li>,g錯n0匭筟</li> <ul> <li>ag鯪錝n0󋲈0薸 </li> <li>󞖐0<br> </li> <li>򶚞󧥴n0魐Mz</li> <li>򶚞󧥴n0P}T</li> <li>P}T0(uD0_0i"}<br> </li> </ul> </ul> <br> <h3>杗橮</h3> <ul> <li>蔔錯n0og0o0錘 Nn0d0n0򶚞󧥴0(uD0~0Y00</li> </ul> <span style="font-weight: bold;"></span><br> <div style="margin-left: 40px;">class2_indi<br> </div> <table class="MsoNormalTable" style="margin-left: 40px;" border="0" cellpadding="0"> <tbody><tr style=""> <td style="padding: 0.75pt; width: 150pt;" width="200"> <p class="MsoNormal">name<br> </p> </td> <td style="padding: 0.75pt; width: 75pt;" width="100"> <p class="MsoNormal">age<br> </p> </td> <td style="padding: 0.75pt; width: 150pt;" width="200"> <p class="MsoNormal">address<br> </p> </td> <td style="padding: 0.75pt; width: 150pt;" width="200"> <p class="MsoNormal"><span lang="EN-US">tel<br> </span></p> </td> <td style="padding: 0.75pt; width: 75pt;" width="100"> <p class="MsoNormal">food<br> </p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">󎳮􀎄<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">52</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">弝 wS]N轢^</p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">080-3456-6543</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">Z</p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">􃒼򎎰0<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">41</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">q\ w Pwe^</p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">090-0123-4567</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">R</p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">񻴼0<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">33</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">SwmS-gL^^</p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">090-1212-3434</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">Z</p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">󘅨񣔌<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">48</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">'Y*枩^:X^</p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">080-9876-5432</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">墍</p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">򦾠0000<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">53</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">杔~ w噳^</p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">080-2468-9753</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">R</p> </td> </tr> </tbody></table> <span style="font-weight: bold;"><br> &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; class2_publ</span> <table class="MsoNormalTable" style="margin-left: 40px;" border="0" cellpadding="0"> <tbody><tr style=""> <td style="padding: 0.75pt; width: 113.9pt;" width="152"> <p class="MsoNormal">name<br> </p> </td> <td style="padding: 0.75pt; width: 58.4pt;" width="78"> <p class="MsoNormal">floor<br> </p> </td> <td style="padding: 0.75pt; width: 136.05pt;" width="181"> <p class="MsoNormal">mail_address<br> </p> </td> <td style="padding: 0.75pt; width: 113.85pt;" width="152"> <p class="MsoNormal">role<br> </p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;">󎳮􀎄<br> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">5</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">ito@is.kochi-u.ac.jp</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">芉Ye坈</p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">􃒼򎎰0<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">5</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">ryooka@is.kochi-u.ac.jp</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">Ye坈</p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">񻴼0<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">5</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">miyoshi@is.kochi-u.ac.jp</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">+^</p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">󘅨񣔌<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">4<br> </span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">shiota@is.kochi-u.ac.jp</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">芉Ye坈</p> </td> </tr> <tr style=""> <td style="padding: 0.75pt;"> <p class="MsoNormal">򦾠0000<br> </p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">3</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal"><span lang="EN-US">toyonaga@is.kochi-u.ac.jp</span></p> </td> <td style="padding: 0.75pt;"> <p class="MsoNormal">Ye坈</p> </td> </tr> </tbody></table> <br> <ul> <li>~0Z0藌a0 NR0(MR轛n0o0L坈0f0D00篘 </li> </ul> <table style="text-align: left; width: 753px; height: 81px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);">$ cd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> $ <span style="color: red;"><span style="color: black;">pg_ctl start -D DB</span><br style="color: black;"> <span style="color: black;">$ cd dbclass</span><br> </span> </td> </tr> </tbody> </table> <ul style="margin-left: 40px; color: red;"> <li>MR轛n0o0L坈0f0D0j0D0篘h00B0H0Z00陙Bf摃k0j0c0_00o1K00磻S0h0 </li> </ul> <table style="text-align: left; width: 753px; height: 81px; margin-left: 80px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: silver;">$ cd&nbsp; <br style="color: black;"> <span style="color: black;">$ mkdir DB &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><br style="color: black;"><span style="color: black;"> $ </span><span style="color: red;"><span style="color: black;">pg_ctl start -D DB</span><br style="color: black;"> <span style="color: black;">$ mkdir dbclass</span><br style="color: black;"><span style="color: black;"> $ cd dbclass</span><br style="color: black;"> <span style="color: black;">$ createdb test</span><br> </span> </td> </tr> </tbody> </table> <br> <br> <ul> <li><span lang="EN-US"><o:p> N妌0SQL󤕘񍲄0dbclassk0 class2.sqlh0D0F0 TMRg0\Ob軴X[ <br> </o:p></span></li> </ul> <br> <table style="text-align: left; width: 753px; height: 81px; margin-left: 40px; background-color: rgb(204, 255, 255);" border="1" cellpadding="2" cellspacing="2"> <tbody><tr><td style="vertical-align: top; background-color: rgb(204, 255, 255);">DROP TABLE class2_indi;<br> DROP TABLE class2_publ;<br> <br> CREATE TABLE class2_indi (<br> &nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(20),<br> &nbsp;&nbsp;&nbsp;&nbsp; age&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INTEGER,<br> &nbsp;&nbsp;&nbsp;&nbsp; address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(30),<br> &nbsp;&nbsp;&nbsp;&nbsp; tel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(20),<br> &nbsp;&nbsp;&nbsp;&nbsp; food&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(20)<br> );<br> <br> CREATE TABLE class2_publ(<br> &nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(20),<br> &nbsp;&nbsp;&nbsp;&nbsp; floor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INTEGER,<br> &nbsp;&nbsp;&nbsp;&nbsp; mail_address&nbsp; CHAR(30),<br> &nbsp;&nbsp;&nbsp;&nbsp; role&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(10)<br> );<br> <br> INSERT INTO class2_indi VALUES('󎳮􀎄',52,'弝 wS]N轢^','080-3456-6543','Z');<br> INSERT INTO class2_indi VALUES('􃒼򎎰0',41,'q\ w Pwe^','090-0123-4567','R');<br> INSERT INTO class2_indi VALUES('񻴼0',33,'SwmS-gL^^','090-1212-3434','Z');<br> INSERT INTO class2_indi VALUES('󘅨񣔌',48,''Y*枩^:X^','080-9876-5432','墍');<br> INSERT INTO class2_indi VALUES('򦾠0000',53,'杔~ w噳^','080-2468-9753','R');<br> <br> INSERT INTO class2_publ VALUES('󎳮􀎄',5,'neumann@is.kochi-u.ac.jp','芉Ye坈');<br> INSERT INTO class2_publ VALUES('􃒼򎎰0',5,'minsky@is.kochi-u.ac.jp','Ye坈');<br> INSERT INTO class2_publ VALUES('񻴼0',5,'codd@is.kochi-u.ac.jp','+^');<br> INSERT INTO class2_publ VALUES('󘅨񣔌',4,'pascal@is.kochi-u.ac.jp','芉Ye坈');<br> INSERT INTO class2_publ VALUES('򦾠0000',3,'turing@is.kochi-u.ac.jp','Ye坈');<br> </td> </tr> </tbody> </table> <p class="MsoNormal" style="margin-bottom: 12pt; margin-left: 40px;"><br> <span lang="EN-US"><a href="class2.sql"><span lang="EN-US"><span lang="EN-US"><span style="font-weight: bold;"></span></span></span></a></span></p> <span style="text-decoration: underline;"><span style="font-weight: bold;"></span></span> <ul> <li><span lang="EN-US">&nbsp;S0n0sql󤕘񍲄0Oc0f00򹟖򠲸00 testk0򶚞󧥴 class2_indih0class2_pub0\ObY00</span></li> </ul> <table style="text-align: left; width: 833px; height: 37px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);">$&nbsp; psql test -f class2.sql<br><span style="color: red;"><br> </span> </td> </tr> </tbody> </table> <br> <ul> <li><span lang="EN-US">&nbsp;S0S0K00r0h0~0Z0񍳔򠵘񯡺񊩺􌢾0g0簒崐W0j0L00L團0</span></li> </ul> <table style="text-align: left; width: 833px; height: 351px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);">$ psql test<br> psql (9.6.3)<br> Type "help" for help.<br> <br> test=# SELECT * FROM class2_indi;<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | age |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; food&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> ----------------------------+-----+---------------------------------------+----------------------+-----------------------<br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 52 | 弝 wS]N轢^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 080-3456-6543&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 41 | q\ w Pwe^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 090-0123-4567&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | R&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 33 | SwmS-gL^^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 090-1212-3434&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 48 | 'Y*枩^:X^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 080-9876-5432&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 墍&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 53 | 杔~ w噳^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 080-2468-9753&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | R&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> (5 rows)<br> <br> test=# SELECT * FROM class2_publ;<br> 錘 Nweu<br> <br><span style="color: red;"><br> </span> </td> </tr> </tbody> </table> <br> <span style="font-weight: bold;"></span><h3 style="font-weight: normal;"><span lang="EN-US">IN, LIKE </span>h堽s</h3> <ul> <li>塸en0x悶bn0-NK000]00k0T魜Y000n00i"}Y00Bfk0o00<span lang="EN-US">IN, LIKE </span>h堽s0OF0S0h0L0g0M000</li> </ul> <pre><span lang="EN-US"><o:p>&nbsp;</o:p></span><br> <span style="color: rgb(51, 102, 255);" lang="EN-US">SELECT * FROM class2_publ WHERE floor IN (4, 5);<br></span><br></pre> <p class="MsoNormal"> <span lang="EN-US"></span><br> </p> <table style="text-align: left; width: 873px; height: 148px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);">test=# <span style="color: rgb(0, 0, 153);">SELECT * FROM class2_publ WHERE floor IN (4, 5);</span><br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | floor |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mail_address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; role&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> ---------------------------+-------+--------------------------------+---------------<br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 5 | neumann@is.kochi-u.ac.jp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 5 | minsky@is.kochi-u.ac.jp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 5 | codd@is.kochi-u.ac.jp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | +^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 4 | pascal@is.kochi-u.ac.jp&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> (4 rows)<span style="color: red;"><br> </span> </td> </tr> </tbody> </table> <br> <pre><br></pre> <h3><span style="font-weight: normal;">ag鯪錝n0eQ0P[0[󋲈0薸 </span><span lang="EN-US">]</span></h3> <ul> <li>芉Ye坈n0麞q妀u鱏0鍂0_0D04XT0i"}㘚a宯0h圠0d0k0j000<span lang="EN-US"></span></li><li> N妌00F0k0<span lang="EN-US">(IN)</span>k0ag鯪錝0eQ0P[k0Y00S0h0k00c0f00噀g0鴉O0S0h0L0g0M000INn0諲k0LIKE0O(u鶴eg0</li> </ul> <pre><span lang="EN-US"><o:p>&nbsp;</o:p></span></pre><pre style="margin-left: 80px; color: rgb(51, 102, 255);"><span lang="EN-US">SELECT ... FROM ... <span style=""></span>WHERE name IN (SELECT ..FROM ... WHERE ....</span><span lang="EN-US">);</span></pre> <p class="MsoNormal"><br> <span lang="EN-US"></span><br> </p> <table style="text-align: left; width: 873px; height: 148px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);">test=# <span style="color: rgb(51, 51, 255);">SELECT name,tel FROM class2_indi WHERE name IN (SELECT name FROM class2_publ WHERE role='芉Ye坈');</span><br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> --------------------------+----------------------<br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 080-3456-6543&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 080-9876-5432&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> (2 rows)<span style="color: red;"><br> </span> </td> </tr> </tbody> </table> <br> <br> <p class="MsoNormal"><span style="font-weight: bold;"><br> </span></p> <p class="MsoNormal"><span style="font-weight: bold;"></span>󞖐0</p> <ul> <li><span lang="EN-US"></span>]00^00n0h圞000 TMRh0t^b00 TMRh0role`0Q00h00`0W0_0󞖐00\ObY00<br> </li> </ul> 000000<span style="color: rgb(51, 102, 255);">CREATE VIEW AS SELECT......</span><br> <table style="text-align: left; width: 873px; height: 39px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);">test=# <span style="color: rgb(51, 102, 255);">CREATE VIEW class3_indi AS SELECT name, age FROM class2_indi;</span><br> CREATE VIEW<br> test=# <span style="color: rgb(51, 102, 255);">SELECT * FROM class3_indi;</span><br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | age <br> ----------------------------+-----<br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 52<br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 41<br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; |&nbsp; 33<br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 48<br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 53<br> (5 rows)<br> <br> test=# <span style="color: rgb(51, 102, 255);">CREATE VIEW class3_publ AS SELECT name, role FROM class2_publ;</span><br> CREATE VIEW<br> test=# SELECT * FROM class3_publ;<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; role&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> ----------------------------+---------------<br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; | +^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> (5 rows)<br> <span style="color: red;"><br> </span> </td> </tr> </tbody> </table> <pre><span lang="EN-US"><o:p>&nbsp;</o:p></span></pre> <h3>魐Mz<br> </h3> <ul> <li><span lang="EN-US"></span>d0n0h坣0魐Mz0\ObY00k0o0 N妌0悐0k0Y00S00L02kW0D03奼0o0j0D0S0h0L0J0J0D0L0 <br> </li> </ul> <br> <table style="text-align: left; width: 873px; height: 39px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);">test=# <span style="color: rgb(51, 51, 255);">SELECT * FROM class3_indi, class3_publ;</span><br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | age |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; role&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> ----------------------------+-----+----------------------------+---------------<br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 52 | 󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 41 | 󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 33 | 󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 48 | 󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; |&nbsp; 53 | 󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 52 | 􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 41 | 􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; |&nbsp; 33 | 􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; |&nbsp; 48 | 􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; |&nbsp; 53 | 􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; 52 | 񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | +^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 41 | 񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | +^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 33 | 񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | +^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 48 | 񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | +^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; |&nbsp; 53 | 񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | +^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 52 | 󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 41 | 󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; |&nbsp; 33 | 󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 48 | 󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; |&nbsp; 53 | 󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 52 | 򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; |&nbsp; 41 | 򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; |&nbsp; 33 | 򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 48 | 򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; |&nbsp; 53 | 򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> (25 rows)<span style="color: red;"><br> </span> </td> </tr> </tbody> </table> <span lang="EN-US"><o:p>&nbsp;</o:p></span> <span lang="EN-US"><br></span> <h3>P}T<br> </h3> <ul> <li><span lang="EN-US"></span>d0n0h坣0P}T0\ObY00k0o0 N妌0悐0k0Y00<br> </li> </ul> <br> <table style="text-align: left; width: 873px; height: 39px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);">test=# <span style="color: rgb(51, 51, 255);">SELECT class3_indi.name,class3_indi.age,class3_publ.role&nbsp; FROM class3_indi,class3_publ&nbsp; WHERE class3_indi.name = class3_publ.name; </span><br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | age |&nbsp;&nbsp;&nbsp;&nbsp; role&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> ----------------------------+-----+---------------<br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 52 | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;􃒼򎎰0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 41 | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;񻴼0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp; |&nbsp; 33 | +^&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; |&nbsp; 48 | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> &nbsp;򦾠0000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 53 | Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> (5 rows)<br> <span style="color: red;"><br> </span> </td> </tr> </tbody> </table> <span lang="EN-US"><o:p>&nbsp;</o:p></span> <span lang="EN-US"><br></span> <h3>婳L<br> </h3> <ul> <li><span lang="EN-US"></span>芉Ye坈n0t^b煉0繆y00k0o000<br> </li> </ul> <br> <table style="text-align: left; width: 873px; height: 39px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);"><span style="color: rgb(51, 51, 255);"></span>test=# <span style="color: rgb(51, 51, 255);">SELECT class3_indi.name,class3_indi.age FROM class3_indi,class3_publ WHERE class3_indi.name = class3_publ.name AND class3_publ.role='芉Ye坈';</span><br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | age <br> --------------------------+-----<br> &nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 52<br> &nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 48<br><span style="color: red;"><br> </span> </td> </tr> </tbody> </table> <span lang="EN-US"><o:p>&nbsp;</o:p></span> <br> <ul> <li><span lang="EN-US"></span>~0_0o0P}T򶚞󧥴𖖤00h0W0f0D0c0_00軴X[W0f0J0D0f0<br> </li> </ul> <br> <table style="text-align: left; width: 873px; height: 39px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);"><span style="color: rgb(51, 51, 255);"></span><span style="color: red;"><span style="color: black;">test=# <span style="color: rgb(51, 51, 255);">CREATE VIEW class3_view AS SELECT class3_indi.name,class3_indi.age,class3_publ.role&nbsp; FROM class3_indi,class3_publ&nbsp; WHERE class3_indi.name = class3_publ.name; </span><br> CREATE VIEW<br> <br> <span style="color: black;">t</span><span style="color: rgb(51, 51, 255);"><span style="color: black;">est=# </span>SELECT * FROM&nbsp; class3_view WHERE role='芉Ye坈';</span></span><br style="color: black;"> <span style="color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | age |&nbsp;&nbsp;&nbsp;&nbsp; role&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><br style="color: black;"> <span style="color: black;">--------------------------+-----+---------------</span><br style="color: black;"> <span style="color: black;">&nbsp;󎳮􀎄&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 52 | 芉Ye坈&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><br style="color: black;"> <span style="color: black;">&nbsp;󘅨񣔌&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 48 | 芉Ye坈&nbsp;&nbsp;&nbsp;</span>&nbsp; <br> </span> </td> </tr> </tbody> </table> <span lang="EN-US"><o:p>&nbsp;</o:p></span> <span lang="EN-US"><o:p>&nbsp;</o:p></span> <br> <h3>B}哊Bfk0o0<br> </h3> <ul> <li><span lang="EN-US"></span>򹟖򠲸0򎐀0󔺪臺Z0B}哊W0f0J0O00坈mig0o0_M0殅M0o0L團0 <br> </li> </ul> <br> <table style="text-align: left; width: 873px; height: 39px; margin-left: 40px;" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top; background-color: rgb(255, 255, 204);"><span style="color: rgb(51, 51, 255);"></span><span style="color: red;"><span style="color: black;"><span style="color: black;">t</span><span style="color: rgb(51, 51, 255);"><span style="color: black;">est=#<span style="color: rgb(51, 51, 255);"> \q</span></span></span></span></span><span style="color: rgb(51, 51, 255);"></span> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # 殅0R0<br> $ <span style="color: rgb(51, 51, 255);">cd</span><br> $ pg_ctl stop -D DB<br><span style="color: red;"><br> </span> </td> </tr> </tbody> </table> &nbsp; <span lang="EN-US"><o:p><br> <br> </o:p></span> <h2 style=""><span style="font-family: &quot;-3 񾷼򬿴&quot;;">o矈L2<br> <span lang="EN-US"><o:p></o:p></span></span></h2> <p class="MsoNormal" style="margin-bottom: 12pt;"><span style="font-family: &quot;-3 񾷼򬿴&quot;;" lang="EN-US"><br> </span></p> N妌0OUL槖0銐D0f00report2-1.sql, result2-1.dat,report2-2.sql, result2-2.dat, 𖘰00k0鹠豊W0f0衏鶴W0j0U0D00<br> <ul> <li>\Omio0~/dbclassg0L團00n0h0Y00򦴴򬿴Y00S0h0L0 g0~0Y0 </li> <li>󤕘񍲄n0 TMRo0臺Z0c歔W0_00n0k0j0c0f0D00S0h00</li> <li>,g噀o0zz}vk0[0Z0󞏎󋲈􉞆0n0亯榞0矈L槖0衏鶴Y00鑕j0i0 廦00S0h00</li> </ul> <br> <ul> <li>沎HQ0honda@is.kochi-u.ac.jp</li> <li>鯪 T0򹟖򠲸00謯o矈L2</li> <li>鄛0R0 7/25(kp) 18:00</li> </ul> <p class="MsoNormal" style="margin-bottom: 12pt;"><span style="font-family: &quot;-3 񾷼򬿴&quot;;" lang="EN-US"><br> </span></p> 1. on0MRJSg0瑠fW0_0class2.sql0Oc0f0\ObW0_0򶚞󧥴class2_indi. class2_publk0㘚W0f00錘 Nn0蚫\O0L團0SQL噀0report2-1.sqlk00焄L圥}済0result2-1.datk0\ObW0j0U0D00<br> <span style="color: red;">j0J0Q1, Q2o0P}T0O0j0D0筫誰g00Q3, Q4o0h坣0P}T0OF0筫誰g0T{H0f0O0`0U0D00</span>0<br> <br> Q1. 0Ye坈 0n0 TMR0OO@b0鍂0_00n0SQL噀0\ObW00焄L圵0j0U0D00<br> <br> Q2. }YirL0 0墍 0k0j0c0f0D00HQun00 TMRh0󤡐0n0D}0h:yY00SQL噀0\ObW00焄L圵0j0U0D00(P}T0d0K00j0D0 <br> <br> Q3. <span style="color: red;">5帠 FloorL05 </span>k0D00 0芉Ye坈 0n0 TMRh0麞q妀u鱏0h:yY00SQL噀0\ObW00焄L圵0j0U0D00(P}T0d0K0F0 <br> <br> Q4. <span style="color: red;">SwmS悀0_0o0杔~ w</span>k0OO0g0D00HQun0􉞆0񇣀0򎊢鍂0_00n0SQL噀0\ObW00焄L圵0j0U0D00j0J00SQL噀k0o0'<span style="color: red;">SwmS-gL^^'</span>g0o0j0O00'<span style="color: red;">SwmS</span>'0c歔Y00S0h00<span style="color: red;">杔~ w</span>k0d0D0f000 T豬h0Y000 (P}T0d0K0F0 <br> <br> <br> 2. 錘 Nn0蚫\O0L團0SQL噀0report2-2.sqlk00焄L圥}済o0result2-2.datk0\ObW0j0U0D00<br> <span style="color: red;"></span>0<br> /* 򹟖0?ceQ(uSQL */<br> <pre><span style="font-family: &quot;-3 񾷼򬿴&quot;;" lang="EN-US"></span></pre> <table style="text-align: left; width: 100%; background-color: rgb(204, 255, 255);" border="1" cellpadding="2" cellspacing="2"> <tbody> <tr> <td style="vertical-align: top;">DROP TABLE Hotel;<br> DROP TABLE Reservation;<br> DROP TABLE Room;<br> DROP TABLE Staff;<br> DROP TABLE Customer;<br> <br> CREATE TABLE Hotel(<br> No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(5),<br> &nbsp;&nbsp;&nbsp;&nbsp; Hotel_Name&nbsp;&nbsp;&nbsp; CHAR(20),<br> &nbsp;&nbsp;&nbsp;&nbsp; Address&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(40),<br> &nbsp;&nbsp;&nbsp;&nbsp; Tel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(13)<br> );<br> <br> CREATE TABLE Room(<br> &nbsp;&nbsp;&nbsp;&nbsp; Hotel_No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(5),<br> &nbsp;&nbsp;&nbsp;&nbsp; Room_No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(3),<br> &nbsp;&nbsp;&nbsp;&nbsp; Room_Type&nbsp;&nbsp;&nbsp;&nbsp; CHAR(1)<br> );<br> <br> CREATE TABLE Reservation (<br> &nbsp;&nbsp;&nbsp;&nbsp; Reservation_ID&nbsp;&nbsp;&nbsp; CHAR(20),<br> &nbsp;&nbsp;&nbsp;&nbsp; Hotel_No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(5),<br> &nbsp;&nbsp;&nbsp;&nbsp; Room_No&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(3),<br> &nbsp;&nbsp;&nbsp;&nbsp; Customer_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(5),<br> &nbsp;&nbsp;&nbsp;&nbsp; Staff_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(4),<br> &nbsp;&nbsp;&nbsp;&nbsp; Checkin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(10)<br> );<br> CREATE TABLE Staff(<br> &nbsp;&nbsp;&nbsp; ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(4),<br> &nbsp;&nbsp;&nbsp;&nbsp; Staff_Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(40)<br> );<br> CREATE TABLE Customer(<br> &nbsp;&nbsp;&nbsp; ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(5),<br> &nbsp;&nbsp;&nbsp; Customer_Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CHAR(20)<br> );<br> <br> INSERT INTO Hotel (No,Hotel_Name,Address,Tel)<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES ('1001','򠶔0󶸚0','CSI wfm塠^','09-1234-5678');<br> INSERT INTO Hotel (No,Hotel_Name,Address,Tel)<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES ('1002','0񯠠0󶸚0','弝 w弝^','08-2468-1357');<br> <br> INSERT INTO Room (Hotel_No, Room_No, Room_Type) VALUES ('1001','105','0');<br> INSERT INTO Room (Hotel_No, Room_No, Room_Type) VALUES ('1002','102','2');<br> INSERT INTO Room (Hotel_No, Room_No, Room_Type) VALUES ('1001','305','1');<br> INSERT INTO Room (Hotel_No, Room_No, Room_Type) VALUES ('1001','208','0');<br> INSERT INTO Room (Hotel_No, Room_No, Room_Type) VALUES ('1002','503','1');<br> INSERT INTO Room (Hotel_No, Room_No, Room_Type) VALUES ('1002','505','0');<br> <br> INSERT INTO Reservation (Reservation_ID,Hotel_No,Room_No,Customer_ID ,Staff_ID,Checkin)<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES ('10001','1002','102','11111','2002','2015.04.01');<br> INSERT INTO Reservation (Reservation_ID,Hotel_No,Room_No,Customer_ID ,Staff_ID,Checkin)<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES ('10002','1002','503','11114','2001','2015.04.25');<br> INSERT INTO Reservation (Reservation_ID,Hotel_No,Room_No,Customer_ID ,Staff_ID,Checkin)<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES ('10003','1001','105','11113','2002','2015.04.16');<br> INSERT INTO Reservation (Reservation_ID,Hotel_No,Room_No,Customer_ID ,Staff_ID,Checkin) VALUES ('10004','1002','505','11115','2001','2015.04.12');<br> INSERT INTO Reservation (Reservation_ID,Hotel_No,Room_No,Customer_ID ,Staff_ID,Checkin) VALUES ('10005','1001','305','11112','2001','2015.04.21');<br> INSERT INTO Reservation (Reservation_ID,Hotel_No,Room_No,Customer_ID ,Staff_ID,Checkin) VALUES ('10006','1001','208','11116','2002','2015.04.17');<br> <br> INSERT INTO Staff (ID,Staff_Name) VALUES ('2001','PO鋮N螑');<br> INSERT INTO Staff (ID,Staff_Name) VALUES ('2002','4(g!k螑');<br> INSERT INTO Customer (ID, Customer_Name) VALUES ('11111','0u-N');<br> INSERT INTO Customer (ID, Customer_Name) VALUES ('11112','q\,g');<br> INSERT INTO Customer (ID, Customer_Name) VALUES ('11113','塭鋮');<br> INSERT INTO Customer (ID, Customer_Name) VALUES ('11114','甗,g');<br> INSERT INTO Customer (ID, Customer_Name) VALUES ('11115','(g N');<br> INSERT INTO Customer (ID, Customer_Name) VALUES ('11116','-N輂');<br> <br> </td> </tr> </tbody> </table> 11. N妌0SQL噀0焄L圵00򶚞󧥴\Obh0򹟖0?ceQ0L圖0j0U0D00<br> 12. 򶚞󧥴P}T0O0Z0k00򠶔0󶸚0k0縖蔿Y00篘n0 TMR0J00s000񯠠0󶸚0k0縖蔿Y00篘n0 TMR0噀g0諷0鶴W0h:yW0j0U0D00<br> 13. 1n0OUL槖00򶚞󧥴P}T0(uD0f0銐M0j0U0D00<br> 14. 򶚞󧥴P}T0(uD0f01d0n0h垝0\ObW00]0n0h圞00򎑤򭅰n0 TMRh0]0n0篘L0舃S_Y00J0n0 TMR0諷0鶴W0h:yW0j0U0D00<br> 15. 򶚞󧥴P}T0(uD0f00]00^00n0L0縖蔿W0_0󶸚0 T0򎑤򭅰 T0000ju鱏000􆏬񍮼0򦴴򬿴񍳔0諷0鶴W0h:yW0j0U0D00<br> 16. 򶚞󧥴P}T0(uD0f00򠶔0󶸚0k04g21錯k0縖蔿W0_0n0 TMR0󶸚0 T0򎑤򭅰 T0000ju鱏000􆏬񍮼0򦴴򬿴񍳔0諷0鶴W0h:yW0j0U0D00<br> <span lang="EN-US"></span> <pre style="margin-left: 80px; color: rgb(51, 102, 255);"><span lang="EN-US"></span></pre> </div> </body></html>