bookpublisher.html

来自「这是卡耐基-梅泷的ssd7的第一个答案」· HTML 代码 · 共 163 行

HTML
163
字号
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> BookPublisher </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="DannyShum">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="For Assignment">
 </HEAD>

 <BODY>
  <TABLE BORDER=1 WIDTH=50%> 
<THEAD> 
<TR> 
<TH>PriAut</TH> 
<TH>Title(AK)</TH> 
<TH>ISBN(PK)</TH> 
<TH>PubID(FK)</TH> 
<TH>Edition</TH> 
<TH>PubDate</TH> 
<TH>Price</TH> 
<TH>BookDes</TH> 
</TR> 
</THEAD> 
<TBODY> 
<TR> 
<TD>A character string</TD> 
<TD>A character string</TD> 
<TD>A character string(Format:d-dddd-dddd-d)</TD> 
<TD>A character string begin with a char(Cddd)</TD> 
<TD>An Positive Int(d)</TD> 
<TD>A character string(Format:dddd.dd.dd)</TD> 
<TD>A character string(Format:$*.*)</TD> 
<TD>A character string</TD> 
</TR> 
</TBODY> 
</TABLE>
  <TABLE BORDER=1 WIDTH=50%> 
<THEAD> 
<TR> 
<TH>PriAut</TH> 
<TH>Title(AK)</TH> 
<TH>ISBN(PK)</TH> 
<TH>PubID(FK)</TH> 
<TH>Edition</TH> 
<TH>PubDate</TH> 
<TH>Price</TH> 
<TH>BookDes</TH> 
</TR> 
</THEAD> 
<TBODY> 
<TR> 
<TD>DannyShum</TD> 
<TD>Thinking in Java</TD> 
<TD>7-5600-5280-0</TD> 
<TD>A001</TD> 
<TD>3</TD> 
<TD>1988.11.12</TD> 
<TD>$118.0</TD> 
<TD>For All Levels</TD> 
</TR> 
<TR> 
<TD>RollandQiu</TD> 
<TD>Think in C</TD> 
<TD>7-5600-5280-1</TD> 
<TD>A002</TD> 
<TD>2</TD> 
<TD>1990.3.24</TD> 
<TD>$49.9</TD> 
<TD>For Freshman</TD> 
</TR> 
<TR> 
<TD>LionLuo</TD> 
<TD>Thinking in C++</TD> 
<TD>7-5600-5280-2</TD> 
<TD>A003</TD> 
<TD>5</TD> 
<TD>1989.2.16</TD> 
<TD>$56.8</TD> 
<TD>For Professor</TD> 
</TR> 
<TR> 
<TD>JimmyLi</TD> 
<TD>Thinking in Delphi</TD> 
<TD>7-5600-5280-3</TD> 
<TD>A004</TD> 
<TD>2</TD> 
<TD>1963.8.7</TD> 
<TD>$32.8</TD> 
<TD>For Freshman</TD> 
</TR> 
<TR> 
<TD>DannyShum</TD> 
<TD>Thinking in Pascal</TD> 
<TD>7-5600-5280-4</TD> 
<TD>A003</TD> 
<TD>3</TD> 
<TD>1952.4.18</TD> 
<TD>$46.8</TD> 
<TD>For Professor</TD> 
</TR> 
<TR> 
</TBODY> 
</TABLE>

<TABLE BORDER=1 WIDTH=50%> 
<THEAD> 
<TR> 
<TH>PubID(PK)</TH> 
<TH>Name(AK)</TH> 
<TH>Address</TH> 
</TR> 
</THEAD> 
<TBODY> 
<TR> 
<TD>A character string begin with a char(Cddd)</TD> 
<TD>A character string</TD> 
<TD>A character string</TD> 
 
</TR> 
</TABLE>

<TABLE BORDER=1 WIDTH=50%> 
<THEAD> 
<TR> 
<TH>PubID(PK)</TH> 
<TH>Name(AK)</TH> 
<TH>Address</TH> 
</TR> 
</THEAD> 
<TBODY> 
<TR> 
<TD>A001</TD> 
<TD>WAP</TD> 
<TD>WHU.ISS.C4 347</TD> 
 
</TR> 
<TR> 
<TD>A002</TD> 
<TD>KBSP</TD> 
<TD>WHU.ISS.C4 316</TD> 

</TR> 
<TR> 
<TD>A003</TD> 
<TD>KKCP</TD> 
<TD>WHU.ISS.C5 317</TD> 

</TR> 
<TR> 
<TD>A004</TD> 
<TD>UIOP</TD> 
<TD>WHU.ISS.C3 317</TD> 
 
</TR> 

</TBODY> 
</TABLE>
<li>Only <b>ISBN</b> and <b>PublisherID</b> are unique, so their values are sufficient to identify a row.      They can be PK or FK.</li>
<li>The other columns' value may be the same, so their values are insufficient to identify        a row. In other word, their can only be AK.</li>
 </BODY>
</HTML>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?