⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 slide020.html

📁 《Big C++ 》Third Edition电子书和代码全集-Part1
💻 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 + -