📄 bookpublisher.html
字号:
<HTML>
<HEAD>
<TITLE>Ex1_张桐_063309</TITLE>
</HEAD>
<BODY>
Part 1:
<br>
<CENTER><H3>BOOK</H3></CENTER>
<table border=2>
<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><td>Jack</td><td>Database System</td><td>001</td><td>01</td><td>Second</td><td>2006-03-01</td><td>79.00</td><td>About basic knowledge of DBS with ISBN: 001</td>
<tr><td>Tom</td><td>The Soup Of Soul</td><td>002</td><td>02</td><td>Third</td><td>2008-04-02</td><td>65.00</td><td>Heart's home with ISBN: 002</td>
<tr><td>Kate</td><td>Network Tips</td><td>003</td><td>03</td><td>First</td><td>2003-12-01</td><td>45.00</td><td>Tips about networkwith ISBN: 003</td>
<tr><td>John</td><td>CCNA</td><td>004</td><td>04</td><td>Second</td><td>2006-09-01</td><td>21.89</td><td>Description about cisco's works with ISBN:004</td> <tr><th>type</th>
<tr><td>varchar(20)</td><td>varchar(40)</td><td>varchar(20)</td><td>varchar(20)</td><td>varchar(20)</td><td>date</td><td>decimal(4,2)</td><td>varchar(100)</td>
</table>
<br>
<b>Primary Key: </b>ISBN, because each book's ISBN is unique.
<br>
<b> Alternate Key: </b>Book Description, because every book's description must be different.
<br>
<b>Foreign Key: </b>PublisherID, because its an attribute of this table, and its a PK of table PUBLISHER.
<br>
<CENTER><H3>PUBLISHER</H3></CENTER>
<table border=2>
<tr><th>PublisherID</th><th>Name</th><th>Address</th>
<tr><td>01</td><td>Tsinghua</td><td>Beijing</td>
<tr><td>02</td><td>Nwpu</td><td>Xi'an</td>
<tr><td>04</td><td>Electronic Industry</td><td>Beijing</td>
<tr><td>05</td><td>Mechanical Industry</td><td>Beiing</td>
<tr><th>type</th>
<tr><td>varchar(20)</td><td>varchar(40)</td><td>varchar(20)</td>
</table>
<br>
<b>Primary Key: </b>PublisherID, because each PUBLISHER' ID is unique.
<br>
<b> Alternate Key: </b>Name, because PUBLISHER' name must be different or breaking the copyright law.
<br>
<b>Foreign Key: </b>There no FK, because there isn't an attribute that is a PK of another table.
<br>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -