📄 bookpublisher.html
字号:
<html>
<head>
<title>Identify the keys</title>
</head>
<body>
<br>
<h3>BOOK</h3>
<table border = 1>
<tr><th>Primary Author</th><th>Title</th><th>ISBN</th><th>PublisherID</th><th>Edition</th><th>Date of Publication </th><th> Price </th><th> Book Description </th></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>James F.Kurose</td><td>Computer Networking</td><td>978-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>
<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><font color = "#FF0000">VARCHAR（20）</font></td><td><font color = "#FF0000">VARCHAR（30）</font></td><td><font color = "#FF0000">VARCHAR（20）</font></td><td><font color = "#FF0000">VARCHAR(5)</font></td><td><font color = "#FF0000">SMALLINT</font></td><td><font color = "#FF0000">DATE</font></td><td><font color = "#FF0000">DECIMAL(4,2)</font></td><td><font color = "#FF0000">VARCHAR（80）</font></td></tr>
</table>
<br>
<b>Primary Key:</b> ISBN, because the ISBN of every book is unique!<br>
<b>Alternate Key:</b> Book Description <br>
<b>Foreign Key:</b> PublisherID, the key of BOOK matching PUBLISHER's.<br>
<br>
<br>
<h3>PUBLISHER</h3>
<table border = 1>
<tr><th>PublisherID</th><th>Name</th><th>Address</th></tr>
<tr><td>13001</td><td>Electronics Industry</td><td>Beijing</td></tr>
<tr><td>13002</td><td>Mochine Press</td><td>Beijing</td></tr>
<tr><td>13066</td><td>Telecom Press</td><td>Beijing</td></tr>
<tr><td>13077</td><td>NWPU Press</td><td>Xi'an</td></tr>
<tr><td><font color = "#FF0000">VARCHAR(5)</font></td><td><font color = "#FF0000">VARCHAR(20)</font></td><td><font color = "#FF0000">VARCHAR(20)</font></td></tr>
</table>
<b>Primary Key:</b> PublisherID, one publisher can only has one ID, so the key is unique!<br>
<b>Alternate Key:</b> Name <br>
<b>Foreign Key:</b> PublisherID, the key of PUBLISHER matching BOOK's.<br>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -