📄 session1-t3.htm
字号:
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="Author" content="Andy">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<title>规范化</title>
</head>
<body text="#000000" bgcolor="#FFFFFF" link="#000066" vlink="#666600" alink="#000066">
<p> </p>
<center><table BORDER=0 COLS=1 WIDTH="520" >
<tr>
<td> <center>
<span style="color: #000099; font-family: 宋体,Arial; font-size: 18pt"><b>规范化</b></span><br>
<br>
<hr WIDTH="100%">
<font style="font-size:9pt"> </font>
<div align="left">
<p><font style="font-size:9pt">应该以系统的方式组织数据。以表的形式获取数据库中的数据和存储数据，这种过程称为规范化。这是一个非常重要的过程，是大量研究的结晶。</font></p>
<p><font style="font-size:9pt">重要的规范化概念</font></p>
<p><font style="font-size:9pt">规范化的目的是要在对数据库执行任何操作的情况下，都能确保数据的完整性。</font></p>
<p><font style="font-size:9pt">每个实体都转化为一个表。其中的一些实体有：乘客 (Passenger)、预订 (Reservation)、食谱 (Meal)、服务 (Service)。</font><font style="font-size:9pt">
</font></p>
<table border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse; mso-table-layout-alt: fixed; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; border-style: none; border-width: medium; margin-left: 135.9pt" width="167">
<tr>
<td width="151" valign="top" style="border: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="left">
<p class="MsoNormal" align="center"><font style="font-size:9pt"><b>Passenger</b></font></p></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="left">
<p class="MsoHeading9"><font style="font-size:9pt">PNR_no</font></p></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="left">
<p class="MsoHeading8"><font style="font-size:9pt">Ticket_no</font></p></td>
</tr>
<tr>
<td width="151" height="15" align="left" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoHeading9"><font style="font-size:9pt">Name</font></p></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="left">
<p class="MsoHeading9"><font style="font-size:9pt">Age</font></p></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="left">
<p class="MsoHeading9"><font style="font-size:9pt">Sex </font></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="left">
<p class="MsoHeading9"><font style="font-size:9pt">PP No</font></p></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in" align="left">
<p class="MsoHeading9"><font style="font-size:9pt">Meal Pref</font></p></td>
</tr>
</table>
<p align="center"><font style="font-size:9pt">表 1</font></p>
<table border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse; mso-table-layout-alt: fixed; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0in 5.4pt 0in 5.4pt; border-style: none; border-width: medium; margin-left: 135.9pt" width="167">
<tr>
<td width="151" valign="top" style="border: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<div align="center"><span style="mso-spacerun: yes; font-size: 11.0pt; mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: normal"><font style="font-size:9pt"><b>Reservation</b></font></span><span style="font-size:11.0pt;mso-bidi-font-size:10.0pt"><o:p></o:p></span><b style="mso-bidi-font-weight:
normal"><span style="font-size:11.0pt;mso-bidi-font-size:10.0pt"><o:p> </o:p>
</span></b></div></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoHeading9"><font style="font-size:9pt">PNR_no</font><o:p> </o:p> </p></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoHeading9"><font style="font-size:9pt">Aircraft_code</font><o:p> </o:p> </p></td>
</tr>
<tr>
<td width="151" valign="top" style="mso-border-top-alt: solid windowtext .5pt; border-left: .5pt solid windowtext; border-right: .5pt solid windowtext; border-top-style: none; border-top-width: medium; border-bottom: .5pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0in; padding-bottom: 0in">
<p class="MsoHeading9"><font style="font-size:9pt">Journey_date</font><o:p> </o:p> </p></td>
</tr>
<tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -