📄 bookpublisher.html
字号:
<html>
<head>
<title>BookPublisher</title>
</head>
<body><br><br><h1 align="center"> BookPublisher Table</h1><h2 align="left">BOOK</h2>
<table width="1070" height="534" border="1" align="center">
<tbody><tr>
<td align="center">Primary_Author</td>
<td align="center">Title <br></td>
<td align="center">ISBN <br></td>
<td align="center">PublisherID</td>
<td align="center">Edition</td>
<td align="center">Date_of_Publication <br></td>
<td align="center">Price <br></td>
<td align="center">Book_Description <br></td></tr>
<tr>
<td><a target="_new" class="v1">Alan Ezust</a></td>
<td>An Introduction to Design Patterns in C++ with Qt 4</td>
<td align="center">0131879057</td>
<td align="center">001<b style=""><span lang="EN-US"></span></b><br></td>
<td align="center">1</td>
<td align="center">Aug. 2006</td>
<td><span class="large green">48.30</span> <br></td>
<td><span class="docEmphasis">This book is dedicated to Miriam Ezust,
without whom none of our work would have been possible.</span></td></tr>
<tr>
<td><a target="_new" class="v1">Jasmin Blanchet</a></td>
<td>C++ GUI Programming with Qt 4</td>
<td align="center">0131872494</td>
<td align="center">002</td>
<td align="center">2</td>
<td align="center">Jun. 2006</td>
<td align="center">25.70</td>
<td><span class="docEmphStrong">The Only Official Best-Practice Guide to Qt 4.1
Programming.
</span>
</td>
</tr>
<tr>
<td>Stanley B.Lippman</td>
<td align="center">C++ Primer</td>
<td align="center">7115151695</td>
<td align="center">003</td>
<td align="center">4</td>
<td align="center">Mar. 2006<br></td>
<td align="center">88.50</td>
<td>The best-seller of C++.<br></td></tr>
<tr>
<td align="left"><span>Jacquie Barker</span><br></td>
<td>Beginning Java Objects: From Concepts To Code</td>
<td align="center">1590594576</td>
<td align="center">004<br></td>
<td align="center">2<br></td>
<td align="center">Mar. 2007 </td>
<td align="center">76.50</td>
<td>The book takes readers through object design, from the very beginning, at a
relaxed pace.</td></tr>
<tr>
<td align="center"><font color="#0000ff">VARCHAR(25)<br></font></td>
<td align="center"><font color="#0000ff">VARCHAR(50)</font></td>
<td><font color="#0000ff">VARCHAR(10)<br></font></td>
<td align="center"><font color="#0000ff">VARCHAR(5)</font></td>
<td align="center"><font color="#0000ff">SMALLINT</font></td>
<td align="center"><font color="#0000ff">VARCHAR(15)</font></td>
<td align="center"><font color="#0000ff">FLOAT</font></td>
<td><font color="#0000ff">VARCHAR(200)<br></font></td></tr>
</tbody>
</table>
<br>
<b>Primary Key:</b> ISBN, the ISBN of one book must be different from that of the other's.<br>
<b>Alternate Key:</b> None. Because none of the other attributes except the ISBN can identify a book uniquely.<br>
<b>Foreign Key:</b> PublisherID, the PublisherID matches the Primary Key of the PUBLISHER table.<br><br><h2>PUBLISHER</h2>
<table width="568" border="1" height="173">
<tbody>
<tr>
<td align="center">PublisherID</td>
<td align="center">Name</td>
<td align="center">Address <br></td></tr>
<tr>
<td align="center">001</td>
<td align="center">Prentice Hall</td>
<td align="center">New York<br></td></tr>
<tr>
<td align="center">002<br></td>
<td align="center">Tomos Timdes<br></td>
<td align="center">Boston</td></tr>
<tr>
<td align="center">003<br></td>
<td align="center">Atros<br></td>
<td align="center">New York<br></td></tr>
<tr>
<td align="center">004</td>
<td align="center">Canerrey Bos<br></td>
<td align="center">Chicago</td></tr>
<tr>
<td align="center"><font color="#0000ff">VARCHAR(5)</font></td>
<td align="center"><font color="#0000ff">VARCHAR(20)</font></td>
<td align="center"><font color="#0000ff">VARCHAR(20)</font></td></tr>
</tbody>
</table>
<br>
<b>Primary Key:</b> PublisherID, the PublisherID of one publisher must be different from that of the other's.<br>
<b>Alternate Key:</b> Name. Because in the actual world, there are no two publishers whose Name are the same.<br>
<b>Foreign Key:</b> None. Because there is not one attribute which matches the Primary Key of another relation.<br>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -