📄 slide015.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='slide016.html'">
<h2><font color="#009999">28.1.2 Linking Tables (cont.)</font></h2>
<font size="+1">
<table cellpadding='12'>
<tr>
<td valign='top'><font size='+1'>
<ul>
<li>In C++, many objects can refer to a single object</li>
<li>To accomplish this in SQL:
<ul>
<li>Break data into 2 tables</li>
<li>Solves replication problem</li>
<li>Cust# <i>primary key</i> for Customer table
<ul>
<li>A <i>foreign key</i> in the Invoice table</li>
<li>Links tables</li>
</ul>
</li>
</ul>
</li>
</ul>
</font>
</td>
<td>
<table border='1' cellpadding='4'>
<tr>
<tr><th colspan='3'>Invoice</th></tr>
</tr>
<tr bgcolor='#00ffff'>
<th>Invoice_<br>Number</th>
<th>Customer_<br>Number</th>
<th>Customer_<br>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.95</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='slide014.html'>prev</a>
|<a href='slide001.html'>top</a>
|<a href='slide016.html'>next</a>
</small></center>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -