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