📄 bookpublisher.html
字号:
<!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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -