📄 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=100%>
<THEAD>
<TR>
<TH>Primary Author</TH>
<TH>Title(AK)</TH>
<TH>ISBN(PK)</TH>
<TH>PubID(FK)</TH>
<TH>Edition</TH>
<TH>DateofPublication</TH>
<TH>Price</TH>
<TH>BookDes</TH>
</TR>
</THEAD>
<TBODY>
<TR>
<TD>Domain: a character string Format:name</TD>
<TD>Domain: string </TD>
<TD>Domain: a character string Format:d-dddd-dddd-d</TD>
<TD>Domain: a character string begin with a char Format:Cddd</TD>
<TD>Domain: a Positive Int(d)</TD>
<TD>Domain: a character string Format:dddd.dd.dd)</TD>
<TD>Domain: a character string Format:$*.*)</TD>
<TD>Domain: a character string</TD>
</TR>
</TBODY>
</TABLE>
<br>
<TABLE BORDER=1 WIDTH=100%>
<THEAD>
<TR>
<TH>PrimaryAuthor</TH>
<TH>Title(AK)</TH>
<TH>ISBN(PK)</TH>
<TH>PublisherID(FK)</TH>
<TH>Edition</TH>
<TH>DateofPublication</TH>
<TH>Price</TH>
<TH>BookDescription</TH>
</TR>
</THEAD>
<TBODY>
<TR>
<TD>DannyShum</TD>
<TD>Thinking in Java</TD>
<TD>7-5370-5289-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>computer culter</TD>
<TD>1-5636-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>C++ primer</TD>
<TD>3-33478-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>uml</TD>
<TD>3-4789-5246-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>operating System</TD>
<TD>7-5436-5454-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>
<br>
<hr color=red ,size = 10,width=100%>
<TABLE BORDER=1 WIDTH=100%>
<THEAD>
<TR>
<TH>PubID(PK)</TH>
<TH>Name</TH>
<TH>Address</TH>
</TR>
</THEAD>
<TBODY>
<TR>
<TD>Domain:A character string begin with a char Format:Cddd</TD>
<TD>A character string</TD>
<TD>A character string</TD>
</TR>
</TABLE>
<br>
<TABLE BORDER=1 WIDTH=100%>
<THEAD>
<TR>
<TH>PubID(PK)</TH>
<TH>Name</TH>
<TH>Address</TH>
</TR>
</THEAD>
<TBODY>
<TR>
<TD>A001</TD>
<TD>WAP</TD>
<TD>BTU.ISS.CV </TD>
</TR>
<TR>
<TD>A002</TD>
<TD>KBSP</TD>
<TD>HMC.ISS.Ch </TD>
</TR>
<TR>
<TD>A003</TD>
<TD>KKCP</TD>
<TD>ULd.Ioc </TD>
</TR>
<TR>
<TD>A004</TD>
<TD>UIOP</TD>
<TD>WHU.ISS.BB </TD>
</TR>
</TBODY>
</TABLE>
<hr color=red ,size = 10,width=100%>
<li>An AK has to uniquely identify a publisher. so there is no Ak in the table Publisher because there is no other column that can uniquely identify a publisher.</li>
<li><b>ISBN</b> and <b>PublisherID</b> are unique, so we can use them to identify a row,so they can be the primary key PK or Fk.</li>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -