?? bookpublisher.html
字號:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>BookPublisher</title></head>
<BODY bgcolor="#EBDFCB">
<body>
<p><strong>1.</strong></p>
<p><strong>FOR Book Table: </strong></p>
<p><strong>PK is ISBN.</strong></p>
<p><strong>AK is Title.</strong></p>
<p><strong>FK is PublisherID.</strong></p>
<p> </p>
<p><strong>FOR the PUBLISHER Table:</strong></p>
<p><strong>PK is PublisherID.</strong></p>
<p><strong> AK is name. </strong></p>
<p><strong>FK is none, because there is no PK or AK for Book Table. </strong></p>
<p><strong>2.</strong></p>
<table width="866" height="378" border="1">
<tr>
<th width="80" height="68" scope="col">Primary Author </th>
<th width="162" scope="col">Title </th>
<th width="72" scope="col">ISBN </th>
<th width="89" scope="col">PublisherID</th>
<th width="64" scope="col">Edition </th>
<th width="96" scope="col">Date of Publication </th>
<th width="48" scope="col">Price</th>
<th width="203" scope="col">Book Description </th>
</tr>
<tr>
<td height="70">Kennethe C.Louden</td>
<td>Complier Construction Principles and Practice </td>
<td>978-7-111-077703-9</td>
<td>2458</td>
<td>1</td>
<td>2007.9</td>
<td>39</td>
<td>Major about complier Construction Principles and Practice.</td>
</tr>
<tr>
<td height="76">Bruce Eckel </td>
<td>Thingking in C++ </td>
<td>7-111-10807-8</td>
<td>2458</td>
<td>2</td>
<td>2005.11</td>
<td>59</td>
<td><p>Description about C++, which is a kind of programme language. </p> </td>
</tr>
<tr>
<td height="75">Richard A. Knaak </td>
<td>Day of The Dragon</td>
<td>978-7-80741-137-6</td>
<td>2785</td>
<td>1</td>
<td>2007.5</td>
<td>20</td>
<td>A book about a interesting story. </td>
</tr>
<tr>
<td height="75">William Stallings </td>
<td>Computer Organization and Architecture </td>
<td>978-7-302-12444-3</td>
<td>3478</td>
<td>7</td>
<td>2007.8</td>
<td>66</td>
<td>Major about Computer Organization and Architecture . </td>
</tr>
</table>
<p> </p>
<table width="867" height="181" border="1">
<tr>
<th scope="col">PublisherID</th>
<th scope="col">Name</th>
<th scope="col">Address</th>
</tr>
<tr>
<th scope="row">2458</th>
<td>China Machine Press </td>
<td>Beijing</td>
</tr>
<tr>
<th scope="row">2458</th>
<td>China Machine Press </td>
<td>Beijing</td>
</tr>
<tr>
<th scope="row">2785</th>
<td>Wenhui Publishing House </td>
<td>Shanghai</td>
</tr>
<tr>
<th scope="row">3478</th>
<td>Tsinghua University Press</td>
<td>Beijing</td>
</tr>
</table>
<p> </p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -