bookpublisher.html

ssd7数据库的联系一到练习三

<style type="text/css">
<!--
.STYLE1 {color: #000000}
-->
</style>
<label></label>
<p>BOOK:</p>
<table width="789" height="293" border="1">
  <tr>
    <td width="112">Primary Author </td>
    <td width="91">Title</td>
    <td width="91">ISBN</td>
    <td width="77">PublisherID</td>
    <td width="56">Edition </td>
    <td width="84">Date of Publication </td>
    <td width="42">Price</td>
    <td width="184">Book Description </td>
  </tr>
  <tr>
    <td height="29">Mark Allen Weiss</td>
    <td><p>Data  Structures and Algorithm Analysis in C++</p>      <span class="STYLE1"><a href="http://www.amazon.com/Data-Structures-Algorithm-Analysis-3rd/dp/0321375319/ref=sr_11_1/102-8987672-9583359?ie=UTF8" target="_blank"></a></span></td>
    <td><br />
    9780321441461</td>
    <td>1001</td>
    <td>3</td>
    <td>2006-02-28</td>
    <td>48.99</td>
    <td>Mark Allen Weiss’ innovative approach to algorithms and data structures teaches   the simultaneous development of sound analytical and programming skills for the   advanced data structures course. Readers learn how to reduce time constraints   and develop programs efficiently by analyzing the feasibility of an algorithm   before it is coded.</td>
  </tr>
  <tr>
    <td height="26"><p><br />
      Abraham  Silberschatz, Henry F.Korth, S.Sudarshan<a href="/search/power_search/power_search.asp?key1=Abraham+Silberschatz%2C+Henry+F%2EKorth%2C+S%2ESudarshan" target="_blank" class="STYLE1"></a></p>    </td>
    <td><p>Fundamentals of Database Systems<br />
    </p>    </td>
    <td>9780321415066<br /></td>
    <td>1002</td>
    <td>5</td>
    <td>2006-10-1</td>
    <td>69.5</td>
    <td><p>Clear explanations of theory and design, broad coverage of models and real   systems, and an up-to-date introduction to modern database technologies result   in a leading introduction to database systems.</p></td>
  </tr>
  <tr>
    <td height="31">Bruce Eckel </td>
    <td><p>Thinking  in Java</p>      <a href="http://www.amazon.com/Thinking-Java-4th-Bruce-Eckel/dp/0131872486/ref=sr_11_1/104-7541332-0393550?ie=UTF8&amp;qid=1182221667&amp;sr=11-1" target="_blank"></a></td>
    <td>9780131872486<br /></td>
    <td>1003</td>
    <td>4</td>
    <td>2007-6-19</td>
    <td>42.99</td>
    <td>“<em>Thinking in Java</em> should be read cover to cover by every Java programmer,   then kept close at hand for frequent reference. The exercises are challenging,   and the chapter on Collections is superb! Not only did this book help me to pass   the Sun Certified Java Programmer exam; it’s also the first book I turn to   whenever I have a Java question.”</td>
  </tr>
  <tr>
    <td height="31">Stanley B.Lippman,Josée LaJoie,Barbara E.Moo </td>
    <td>C++ Primer Plus </td>
    <td>9780201721485<br /></td>
    <td>1001</td>
    <td>4</td>
    <td>2006-3-31</td>
    <td>35.99</td>
    <td>Just as C++ has evolved since the last edition, so has the authors' approach to   teaching it. They now introduce the C++ standard library from the beginning,   giving readers the means to write useful programs without first having to master   every language detail. Highlighting today's best practices, they show how to   write programs that are safe, can be built quickly, and yet offer outstanding   performance. Examples that take advantage of the library, and explain the   features of C++, also show how to make the best use of the language. As in its   previous editions, the book's authoritative discussion of fundamental C++   concepts and techniques makes it a valuable resource even for more experienced   programmers. </td>
  </tr>
  <tr>
    <td height="40">varchar(100)</td>
    <td>varchar(100)</td>
    <td>varchar(40)</td>
    <td>integer</td>
    <td>integer</td>
    <td>date</td>
    <td>numeric(5,2)</td>
    <td>varchar(1000)</td>
  </tr>
</table>

<p>&nbsp;</p>
<p>PUBLISHER:</p>
<table width="506" height="104" border="1">
  <tr>
    <td width="124">PublisherID</td>
    <td width="165">Name</td>
    <td width="195">Address</td>
  </tr>
  <tr>
    <td>1001</td>
    <td>Addison Wesley</td>
    <td>Washington </td>
  </tr>
  <tr>
    <td>1002</td>
    <td>McGraw Hill</td>
    <td>New York </td>
  </tr>
  <tr>
    <td>1003</td>
    <td><p>Prentice  Hall PTR</p>      <a href="/search/power_search/power_search.asp?key1=Prentice+Hall+PTR" target="_blank"></a></td>
    <td>New York </td>
  </tr>
  <tr>
    <td>integer</td>
    <td>varchar(20)</td>
    <td>varchar(40)</td>
  </tr>
</table>
<p>&nbsp;</p>
<p>BOOK&nbsp;Table:</p>
<p>ISBN is the Primary Key,because it can identify the BOOK uniquely. </p>
<p>PublisherID is the Foreign Key,because it matchs the candidate key of PUBLISHER.</p>
<p>Primary Author,Title,Edition are the Alternate Keys. </p>
<p>&nbsp;</p>
<p>PUBLISHER Table: </p>
<p>PublisherID is the Primary Key,because it can identify the PUBLISHER uniquely.</p>
<p>Name,Address are the Alternate Keys.</p>
<p>Foreign Key is not exist. </p>
<p>&nbsp;</p>
<label></label>
<p>&nbsp;</p>