📄 bookpublisher.html
字号:
<html>
<head>
<title>BookPublisher</title>
</head>
<body>
<table width="350" border="1">
<caption>BOOK</caption>
<tr>
<th align="center">Primary Author</th>
<th align="center">Title</th>
<th align="center">ISBN</th>
<th align="center">PublisherID</th>
<th align="center">Edition</th>
<th align="center">Date of Publication</th>
<th align="center">Price(RMB)</th>
<th align="center">Book Dscription</th>
</tr>
<tr>
<td align="left">June Jamrich Parsons</td>
<td align="left">New Perspectives on Computer Concepts</td>
<td align="left">7505381059</td>
<td align="left">001</td>
<td align="left">5</td>
<td align="left">2005-06-2</td>
<td align="left">39.00</td>
<td align="left">A foreign textbook about coumputer</td>
</tr>
<tr>
<td align="left">Bruce Eckel</td>
<td align="left">Thinking in Java</td>
<td align="left">7111213826</td>
<td align="left">002</td>
<td align="left">4</td>
<td align="left">2007-06-10</td>
<td align="left">108.00</td>
<td align="left">A foreign textbook about java language</td>
</tr>
<tr>
<td align="left">Thomas Connolly</td>
<td align="left">Database Systems</td>
<td align="left">7503387847</td>
<td align="left">001</td>
<td align="left">3</td>
<td align="left">2005-03-30</td>
<td align="left">79.00</td>
<td align="left">A foreign textbook about database system</td>
</tr>
<tr>
<td align="left">Mark Allen Weiss</td>
<td align="left">Data Structures and Problem Solving Using C++</td>
<td align="left">7302111669</td>
<td align="left">003</td>
<td align="left">2</td>
<td align="left">2005-08-5</td>
<td align="left">86.00</td>
<td align="left">A foreign textbook about data structures</td>
</tr>
<tr>
<td align="left">Ramez Elmasri</td>
<td align="left">Fundamentals of Database Systems</td>
<td align="left">0201542633</td>
<td align="left">005</td>
<td align="left">3</td>
<td align="left">1999-08-27</td>
<td align="left">79.00</td>
<td align="left">A foreign textbook about database system</td>
</tr>
</table>
<br>The primary key is "ISBN", and the alternate key is "Title", and it has a foreign key "PublisherID" which refers to the table PUBLISHER.
And the values of "ISBN" must be different.
<br><br><br><br>
<table width="350" border="1">
<caption>PUBLISHER</catpion>
<tr>
<th align="center">PublisherID</th>
<th align="center">Name</th>
<th align="center">Address</th>
</tr>
<tr>
<td align="left">001</td>
<td align="left">Electronics Industry</td>
<td align="left">Beijing, China</td>
</tr>
<tr>
<td align="left">002</td>
<td align="left">China Machine</td>
<td align="left">Beijing, China</td>
</tr>
<tr>
<td align="left">003</td>
<td align="left">Tsinghua University</td>
<td align="left">Beijing, China</td>
</tr>
<tr>
<td align="left">004</td>
<td align="left">Higher Education</td>
<td align="left">Beijing, China</td>
</tr>
<tr>
<td align="left">005</td>
<td align="left">Addison Wesley</td>
<td align="left">New York, America</td>
</tr>
</table>
<br>The primary key is "PublisherID", and the alternate key is "Name", but it has no foreign key. And the values
of "PublisherID" and the values of "Name" must be different
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -