<table width="200" border="1">
  <tr>
  	<th>bookid</th>
    <th>title</th>
    <th>authors</th>
    <th>isbn</th>
    <th>cost</th>
   </tr>
   <tr>
   	<td>10001
    <td>Simple HTML
    <td>Brown and Smith
    <td>764505414
    <td>39.95
    <tr>
     <td>10002
     <td>Simple PHP
     <td>Thomas Edison
     <td>764535114
     <td>49.95
   <tr>
     <td>10003
     <td>Linux Bible
     <td>Green and Camarda
     <td>834594939
     <td>96
   <tr>
     <td>10004
     <td>Web Design
     <td>Jenny Wang
     <td>429594939
     <td>50
   <tr>
     <td>10005
     <td>Simple Networks
     <td>Harry Nguyen
     <td>224593049
     <td>26
   </table>
  <table width="200" border="1">
    <tr>
      <td>studentid</td>
      <td>name</td>
      <td>surname</td>
      <td>street</td>
      <td>suburb</td>
      <td>postcode</td>
      <td>phone</td>
    </tr>
    <tr>
      <td>1001</td>
      <td>Peter</td>
      <td>Smith</td>
      <td>1 Hope St</td>
      <td>Vermont</td>
      <td>3131</td>
      <td>0409196460</td>
    </tr>
    <tr>
      <td>1002</td>
      <td>John</td>
      <td>Jones</td>
      <td>3 Hat Rd</td>
      <td>Buwood</td>
      <td>3151</td>
      <td>0414306601</td>
    </tr>
    <tr>
      <td>1003</td>
      <td>Huynh</td>
      <td>Nguyen</td>
      <td>2 Red Ave</td>
      <td>Kew</td>
      <td>3101</td>
      <td>0411096456</td>
    </tr>
    <tr>
      <td>1004</td>
      <td>Nancy</td>
      <td>Fong</td>
      <td>78 Green St</td>
      <td>Mulgrave</td>
      <td>3170</td>
      <td>0412061567</td>
    </tr>
    <tr>
      <td>1005</td>
      <td>Jing</td>
      <td>Yong</td>
      <td>3 Windsor St</td>
      <td>Clayton</td>
      <td>3168</td>
      <td>0414356499</td>
    </tr>
  </table>
  <table width="200" border="1">
    <tr>
      <td>loanid</td>
      <td>student_id</td>
      <td>book_bookid</td>
      <td>loandate</td>
      <td>duedate</td>
      <td>returned</td>
    </tr>
    <tr>
      <td>100001</td>
      <td>1005</td>
      <td>10002</td>
      <td>2014-10-01</td>
      <td>2014-10-15</td>
      <td>Y</td>
    </tr>
    <tr>
      <td>100002</td>
      <td>1002</td>
      <td>10006</td>
      <td>2014-10-02</td>
      <td>2014-10-04</td>
      <td>Y</td>
    </tr>
    <tr>
      <td>100004</td>
      <td>1004</td>
      <td>10009</td>
      <td>2014-10-16</td>
      <td>2014-10-30</td>
      <td>Y</td>
    </tr>
    <tr>
      <td>100006</td>
      <td>1004</td>
      <td>10003</td>
      <td>2014-11-18</td>
      <td>2014-11-20</td>
      <td>Y</td>
    </tr>
    <tr>
      <td>100007</td>
      <td>1002</td>
      <td>10002</td>
      <td>2014-11-20</td>
      <td>2014-11-24</td>
      <td>Y</td>
    </tr>
    <tr>
      <td>100010</td>
      <td>1004</td>
      <td>10004</td>
      <td>2014-11-24</td>
      <td>2014-11-25</td>
      <td>Y</td>
    </tr>
    <tr>
      <td>100012</td>
      <td>1004</td>
      <td>10007</td>
      <td>2014-11-25</td>
      <td>2014-11-26</td>
      <td>N</td>
    </tr>
    <tr>
      <td>100014</td>
      <td>1002</td>
      <td>10004</td>
      <td>2014-11-27</td>
      <td>2014-11-28</td>
      <td>N</td>
    </tr>
    <tr>
      <td>100015</td>
      <td>1003</td>
      <td>10003</td>
      <td>2014-12-02</td>
      <td>2014-12-15</td>
      <td>Y</td>
    </tr>
  </table>