slide020.html
来自「《Big C++ 》Third Edition电子书和代码全集-Part1」· HTML 代码 · 共 119 行
HTML
119 行
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="blendTrans(Duration=2)" http-equiv="Page-Enter">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" src="./config.js"></script>
<script language="JavaScript" src="./pageFormat.js"></script>
<script><!-- // Set title on page
title()
//--></script>
</head>
<body>
<div onclick="document.location='slide021.html'">
<h2><font color="#009999">28.1.3 Implementing One-to-Many Relationships
(cont.)</font></h2>
<font size="+1">
<table cellpadding='12'>
<tr>
<td><font size='+1'>
<ul>
<li>Break into 2 tables</li>
<li>Link items to an invoice w/<tt>Invoice_Number</tt></li>
</ul>
</td>
<td rowspan='2'>
<table border='1' cellpadding='4'>
<tr><th colspan='3'>Item</th></tr>
<tr bgcolor='#00ffff'>
<th>Invoice_<br>Number</th>
<th>Product_<br>Code</th>
<th>Quantity</th>
</tr>
<tr>
<td align='center'><tt>INTEGER</tt></td>
<td align='center'><tt>CHAR(10)</tt></td>
<td align='center'><tt>INTEGER</tt></td>
</tr>
<tr>
<td align='center'>11731</td>
<td align='center'>116-064</td>
<td align='center'>3</td>
</tr>
<tr>
<td align='center'>11731</td>
<td align='center'>257-535</td>
<td align='center'>1</td>
</tr>
<tr>
<td align='center'>11731</td>
<td align='center'>643-119</td>
<td align='center'>2</td>
</tr>
<tr>
<td align='center'>11732</td>
<td align='center'>116-064</td>
<td align='center'>10</td>
</tr>
<tr>
<td align='center'>11733</td>
<td align='center'>116-064</td>
<td align='center'>2</td>
</tr>
<tr>
<td align='center'>11733</td>
<td align='center'>643-119</td>
<td align='center'>1</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border='1' cellpadding='4'>
<tr><th colspan='3'>Invoice</th></tr>
<tr bgcolor='#00ffff'>
<th>Invoice_<br>Number</th>
<th>Customer_<br>Number</th>
<th>Payment</th>
</tr>
<tr>
<td align='center'><tt>INTEGER</tt></td>
<td align='center'><tt>INTEGER</tt></td>
<td align='center'><tt>DECIMAL(10,2)</tt></td>
</tr>
<tr>
<td align='center'>11731</td>
<td align='center'>3175</td>
<td align='center'>0</td>
</tr>
<tr>
<td align='center'>11732</td>
<td align='center'>3176</td>
<td align='center'>249.5</td>
</tr>
<tr>
<td align='center'>11733</td>
<td align='center'>3175</td>
<td align='center'>0</td>
</tr>
</table>
</td>
</tr>
</table>
</font>
<hr>
<center><small>
<a href='slide019.html'>prev</a>
|<a href='slide001.html'>top</a>
|<a href='slide021.html'>next</a>
</small></center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?