📄 bookpublisher.html
字号:
<HTML>
<HEAD>
<TITLE>SSD7_Exercise1</TITLE>
</HEAD>
<BODY>
<table border=2 >
<caption align=top><font size=5>BOOK</font></caption>
<tr><th>Primary Author</th>
<th>Title</th>
<th>ISBN</th>
<th>PublisherID</th>
<th>Edtion</th>
<th>Date of Publication</th>
<th>Price</th>
<th>Book Description</th>
<tr><td align=left>Brookshear, J. Glenn.</td>
<td align=left>Computer system concepts for real life</td>
<td align=center> S782.2-2 </td>
<td align=center>001</td>
<td align=center>The first edtion</td>
<td align=center>3/2/2008</td>
<td align=center>89</td>
<td align=center>About syestem</td>
<tr><td align=left> Stair, Ralph M. </td>
<td align=left>Exploring tomorrow's technology</td>
<td align=center> S783.2-2 </td>
<td align=center>002</td>
<td align=center>The first edtion</td>
<td align=center>3/5/2008</td>
<td align=center>92</td>
<td align=center>About computer</td>
<tr><td align=left>Pfaffenberger, Bryan </td>
<td align=left>Computers in your future </td>
<td align=center> S682.2-2 </td>
<td align=center>003</td>
<td align=center>The first edtion</td>
<td align=center>1/5/2008</td>
<td align=center>89</td>
<td align=center>About computer</td>
<tr><td align=left>Parsons, June Jamrich. </td>
<td align=left>Tomorow's Computers </td>
<td align=center> S789.2-2 </td>
<td align=center>004</td>
<td align=center>The first edtion</td>
<td align=center>1/5/2008</td>
<td align=center>108</td>
<td align=center>About software</td>
</table>
<br><br>
<table border=2>
<tr><th>Columns</th>
<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><th>Domain</th>
<td align=center>VARCHAR(30)</td>
<td align=center>VARCHAR(40)</td>
<td align=center>VARCHAR(20)</td>
<td align=center>CHAR(4)</td>
<td align=center>VARCHAR(20)</td>
<td align=center>DATE</td>
<td align=center>FLOAT</td>
<td align=center>VARCHAR(400)</td>
</table>
<br>
Answer:
<LI> Primary Key of the table : ISBN
<LI> Alternate Key of the table: {Title}or {PublisherID}
<LI> Foreign Key of the table: PublisherID
<br><br><br>
<table border=2>
<caption align=top><font size=5>PUBLISHER</font></caption>
<tr><th>PublisherID</th>
<th>Name</th>
<th>Address</th>
<tr><td align=center>001</td>
<td align=left>NWPU Publisher</td>
<td align=left>Youyi road</td>
<tr><td align=center>002</td>
<td align=left>Xidian universcity publisher</td>
<td align=left>Chang'an Road</td>
<tr><td align=center>003</td>
<td align=left>Qinghua universcity publisher</td>
<td align=left>Beijing City</td>
<tr><td align=center>004</td>
<td align=left>Zhejiang universcity publisher</td>
<td align=left>Zhejiang province</td>
</table>
<br><br>
<table border=2>
<tr><th>Columns</th>
<th>PublisherId</th>
<th>Name</th>
<th>Adderss </th>
<tr><th>Domain</th>
<td align=center>CHAR(4)</td>
<td align=center>VARCHAR(50)</td>
<td align=center>VARCHAR(100)</td>
</table>
<br>
Answer:
<LI> Primary Key of the table : PublisherID
<LI> Alternate Key of the table:{name} or {address}
<LI> Foreign Key of the table: None.
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -