?? bookpublisher.html
字號:
<html>
<body>
<h3>BOOK:</h3>
<table border="1">
<tr>
<td>Primary Author</td>
<td>Title</td>
<td>ISBN</td>
<td>PublisherID</td>
<td>Edition</td>
<td>Date of Publication</td>
<td>Price</td>
<td>Book Description</td>
</tr>
<tr>
<td> Thomas Connolly </td>
<td> Database Systems </td>
<td> 7-5053-9418-5 </td>
<td> 13001 </td>
<td> 3 </td>
<td> 2005-9-2 </td>
<td> 79.00 </td>
<td> A practical Approach to Design, Implementation, and Management Third Edition </td>
</tr>
<tr>
<td> Lippman </td>
<td> Operating Systems </td>
<td> 978-711-10915-6-1 </td>
<td> 13077 </td>
<td> 2 </td>
<td> 2002-01-01 </td>
<td> 48.00 </td>
<td> Computer Operation Systems </td>
</tr>
<tr>
<td> James F.Kurose </td>
<td> Computer Networking </td>
<td> 538-7-111-16505-7 </td>
<td> 13002 </td>
<td> 3 </td>
<td> 2006-5-6 </td>
<td> 55.00 </td>
<td> A Top-Down Approach Featuring the Internet, Third Edition </td>
</tr>
<tr>
<td> Stanley </td>
<td> C++ Primer </td>
<td> 978-711-51455-4-3 </td>
<td> 13066 </td>
<td> 4 </td>
<td> 2006-03-01 </td>
<td> 50.00 </td>
<td> C++ </td>
</tr>
</table>
<h4>Primary Key（主關鍵字）: ISBN, the ISBN of every book is different</h4>
<h4>Alternate Key(輔關鍵字：沒有被選為主關鍵字的候選關鍵字): PublisherID </h4>
<h4>Foreign Key（外部關鍵字）: PublisherID, the key of BOOK matching PUBLISHER's</h4>
<h3>PUBLISHER:</h3>
<table border="1">
<tr>
<td>PublisherID</td>
<td>Name</td>
<td>Address</td>
</tr>
<tr>
<td>13001</td>
<td>Thomas Connolly </td>
<td>Beijing</td>
</tr>
<tr>
<td>13077</td>
<td>Lippman</td>
<td>Xi'an</td>
</tr>
<tr>
<td>13002</td>
<td>Mechanism</td>
<td>Beijing</td>
</tr>
<tr>
<td>13066</td>
<td>Langman</td>
<td>Beijing</td>
</tr>
</table>
<h4>Primary Key: PublisherID, one publisher can only has one ID, so the key is unique</h4>
<h4>Alternate Key: Have no alternate key,because name and address not unique </h4>
<h3>LIST:</h3>
<table border="1">
<tr>
<td>Columns</td>
<td>Domains</td>
</tr>
<tr>
<td>Primary Author</td>
<td>char(25)</td>
</tr>
<tr>
<td>Title</td>
<td>char(25)</td>
</tr>
<tr>
<td>ISBN</td>
<td>char(25)</td>
</tr>
<tr>
<td>PublisherID</td>
<td>integer</td>
</tr>
<tr>
<td>Edition</td>
<td>integer</td>
</tr>
<tr>
<td>Date of Publication</td>
<td>date</td>
</tr>
<tr>
<td>Price</td>
<td>decimal(4,2)</td>
</tr>
<tr>
<td>Book Description</td>
<td>char(100)</td>
</tr>
<tr>
<td>Name</td>
<td>char(25)</td>
</tr>
<tr>
<td>Address</td>
<td>char(25)</td>
</tr>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -