数据库原理授课计划2007.mht

数据库的一些资料

BORDER-LEFT: medium none; WIDTH: 153.45pt; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; mso-border-alt: solid windowtext =
.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
    width=3D205>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 2.4pt 0cm; mso-para-margin-top: .2gd; =
mso-para-margin-right: 0cm; mso-para-margin-bottom: .2gd; =
mso-para-margin-left: 0cm"><SPAN=20
      style=3D"FONT-FAMILY: =
=B7=C2=CB=CE_GB2312">=D5=C6=CE=D5=B3=A3=BC=FB=B5=C4=CA=FD=BE=DD=C4=A3=D0=CD=
=A3=AC=D5=C6=CE=D5</SPAN><SPAN=20
      style=3D"COLOR: black; FONT-FAMILY: =B7=C2=CB=CE_GB2312; =
mso-hansi-font-family: =CB=CE=CC=E5; mso-bidi-font-size: =
14.0pt">=B9=D8=CF=B5=C4=A3=D0=CD=B5=C4=BB=F9=B1=BE=B8=C5=C4=EE=A1=A2=D0=D4=
=D6=CA=BA=CD=CC=D8=B5=E3=A1=A3=D5=C6=CE=D5=B9=D8=CF=B5=CD=EA=D5=FB=D0=D4=D4=
=BC=CA=F8=A1=A3=D5=C6=CE=D5</SPAN><SPAN=20
      style=3D"COLOR: black; FONT-FAMILY: =B7=C2=CB=CE_GB2312; =
mso-hansi-font-family: =
=CB=CE=CC=E5">=CA=FD=BE=DD=BF=E2=C9=E8=BC=C6=B5=C4=CC=D8=B5=E3=BA=CD=BB=F9=
=B1=BE=B2=BD=D6=E8=A1=A3</SPAN><SPAN=20
      lang=3DEN-US style=3D"FONT-FAMILY: =
=B7=C2=CB=CE_GB2312"><o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; mso-border-alt: solid windowtext .5pt; =
mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid =
windowtext .5pt"=20
    width=3D108>
      <P class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><SPAN=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312; mso-hansi-font-family: =
=CB=CE=CC=E5">=D4=C4=B6=C1<SPAN=20
      lang=3DEN-US>3.1</SPAN>=A3=AC<SPAN =
lang=3DEN-US>3.3<o:p></o:p></SPAN></SPAN></P>
      <P class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><SPAN=20
      lang=3DEN-US=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312; mso-hansi-font-family: =
=CB=CE=CC=E5"><o:p>&nbsp;</o:p></SPAN></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 4">
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; mso-border-alt: solid windowtext .5pt; =
mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal=20
      style=3D"TEXT-ALIGN: center; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto"=20
      align=3Dcenter><SPAN lang=3DEN-US=20
      style=3D"FONT-SIZE: 12pt; FONT-FAMILY: =CB=CE=CC=E5; =
mso-bidi-font-family: =CB=CE=CC=E5"><U1:P>4<o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext =
1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal=20
      style=3D"TEXT-ALIGN: center; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto"=20
      align=3Dcenter><SPAN lang=3DEN-US=20
      style=3D"FONT-SIZE: 12pt; FONT-FAMILY: =CB=CE=CC=E5; =
mso-bidi-font-family: =CB=CE=CC=E5"><U1:P>4<o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext =
1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal><SPAN style=3D"FONT-FAMILY: =
=B7=C2=CB=CE_GB2312"><U1:P>=B9=D8=CF=B5=CA=FD=BE=DD=C4=A3=D0=CD<SPAN=20
      lang=3DEN-US>(The relational data =
model)<o:p></o:p></SPAN></SPAN></P>
      <P class=3DMsoNormal><SPAN=20
      style=3D"COLOR: black; FONT-FAMILY: =B7=C2=CB=CE_GB2312; =
mso-hansi-font-family: =
=CB=CE=CC=E5">=B9=E6=B7=B6=BB=AF=C0=ED=C2=DB=BA=CD=B7=BD=B7=A8=A1=A3=CA=FD=
=BE=DD=D2=C0=C0=B5=A1=A3</SPAN><SPAN=20
      lang=3DEN-US style=3D"FONT-FAMILY: =
=B7=C2=CB=CE_GB2312">1NF,2NF,3NF</SPAN><SPAN=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312">=BA=CD<SPAN =
lang=3DEN-US>BCNF</SPAN>=A1=A3<SPAN=20
      lang=3DEN-US><o:p></o:p></SPAN></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext =
1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
    vAlign=3Dtop>
      <P class=3DMsoNormal><SPAN lang=3DEN-US=20
      style=3D"FONT-SIZE: 12pt; FONT-FAMILY: =CB=CE=CC=E5; =
mso-bidi-font-family: =CB=CE=CC=E5">2</SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; WIDTH: 153.45pt; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; mso-border-alt: solid windowtext =
.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
    width=3D205>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 2.4pt 0cm; mso-para-margin-top: .2gd; =
mso-para-margin-right: 0cm; mso-para-margin-bottom: .2gd; =
mso-para-margin-left: 0cm"><SPAN=20
      style=3D"COLOR: black; FONT-FAMILY: =B7=C2=CB=CE_GB2312; =
mso-hansi-font-family: =
=CB=CE=CC=E5">=D5=C6=CE=D5=B9=E6=B7=B6=BB=AF=C0=ED=C2=DB=D2=D4=BC=B0=CA=FD=
=BE=DD=D2=C0=C0=B5=B5=C4=BB=F9=B1=BE=B8=C5=C4=EE=A1=A3</SPAN><SPAN=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312">=D5=C6=CE=D5<SPAN =
lang=3DEN-US>1NF,2NF,3NF</SPAN>=BA=CD<SPAN=20
      =
lang=3DEN-US>BCNF</SPAN>=B5=C4=B6=A8=D2=E5=BA=CD=C5=D0=B6=CF=A1=A3<SPAN=20
    lang=3DEN-US><o:p></o:p></SPAN></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; mso-border-alt: solid windowtext .5pt; =
mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid =
windowtext .5pt"=20
    width=3D108>
      <P class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><SPAN=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312; mso-hansi-font-family: =
=CB=CE=CC=E5">=D4=C4=B6=C1<SPAN=20
      lang=3DEN-US>3.5-3.7<o:p></o:p></SPAN></SPAN></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 5">
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; mso-border-alt: solid windowtext .5pt; =
mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal=20
      style=3D"TEXT-ALIGN: center; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto"=20
      align=3Dcenter><SPAN lang=3DEN-US=20
      style=3D"mso-bidi-font-size: 10.5pt">5<o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext =
1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal=20
      style=3D"TEXT-ALIGN: center; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto"=20
      align=3Dcenter><SPAN lang=3DEN-US=20
      style=3D"mso-bidi-font-size: =
10.5pt"></U1:P>5<o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext =
1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal><SPAN style=3D"FONT-FAMILY: =
=B7=C2=CB=CE_GB2312"></U1:P>=B9=D8=CF=B5=B4=FA=CA=FD<SPAN=20
      lang=3DEN-US>(Algebra of Relational =
Model)<o:p></o:p></SPAN></SPAN></P>
      <P class=3DMsoNormal><SPAN=20
      style=3D"COLOR: black; FONT-FAMILY: =B7=C2=CB=CE_GB2312; =
mso-hansi-font-family: =CB=CE=CC=E5; mso-bidi-font-size: =
14.0pt">=B9=D8=CF=B5=CA=FD=BE=DD=D3=EF=D1=D4=B7=D6=C0=E0=A3=AC=B9=D8=CF=B5=
=B4=FA=CA=FD=B5=C4=CC=D8=B5=E3=A1=A2=D4=CB=CB=E3=B7=FB=BA=CD=B1=ED=B4=EF=CA=
=BD=A1=A3</SPAN><SPAN=20
      lang=3DEN-US style=3D"FONT-FAMILY: =
=B7=C2=CB=CE_GB2312"><o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext =
1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt"=20
    vAlign=3Dtop>
      <P class=3DMsoNormal><SPAN lang=3DEN-US=20
      style=3D"FONT-SIZE: 12pt; FONT-FAMILY: =CB=CE=CC=E5; =
mso-bidi-font-family: =CB=CE=CC=E5">2</SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; WIDTH: 153.45pt; PADDING-TOP: 0cm; =
BORDER-BOTTOM: windowtext 1pt solid; mso-border-alt: solid windowtext =
.5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: =
solid windowtext .5pt"=20
    width=3D205>
      <P class=3DMsoNormal=20
      style=3D"MARGIN: 2.4pt 0cm; mso-para-margin-top: .2gd; =
mso-para-margin-right: 0cm; mso-para-margin-bottom: .2gd; =
mso-para-margin-left: 0cm"><SPAN=20
      style=3D"COLOR: black; FONT-FAMILY: =B7=C2=CB=CE_GB2312; =
mso-hansi-font-family: =CB=CE=CC=E5; mso-bidi-font-size: =
14.0pt">=C1=CB=BD=E2=B9=D8=CF=B5=CA=FD=BE=DD=D3=EF=D1=D4=B7=D6=C0=E0=A1=A3=
=D5=C6=CE=D5=B9=D8=CF=B5=B4=FA=CA=FD=D3=EF=D1=D4=B5=C4=CC=D8=B5=E3=A1=A2=D4=
=CB=CB=E3=B7=FB=BA=CD=B1=ED=B4=EF=CA=BD=A1=A3</SPAN><SPAN=20
      lang=3DEN-US style=3D"FONT-FAMILY: =
=B7=C2=CB=CE_GB2312"><o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; WIDTH: 81pt; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; mso-border-alt: solid windowtext .5pt; =
mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid =
windowtext .5pt"=20
    width=3D108>
      <P class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><SPAN=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312; mso-hansi-font-family: =
=CB=CE=CC=E5">=D4=C4=B6=C1<SPAN=20
      lang=3DEN-US>4.1<o:p></o:p></SPAN></SPAN></P>
      <P class=3DMsoNormal style=3D"TEXT-ALIGN: center" =
align=3Dcenter><SPAN=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312; mso-hansi-font-family: =
=CB=CE=CC=E5">=D7=DB=BA=CF=CC=E2<SPAN=20
      lang=3DEN-US>1</SPAN>=B5=C0<SPAN =
lang=3DEN-US><o:p></o:p></SPAN></SPAN></P></TD></TR>
  <TR style=3D"mso-yfti-irow: 6">
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 0cm; BORDER-BOTTOM: =
windowtext 1pt solid; mso-border-alt: solid windowtext .5pt; =
mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal=20
      style=3D"TEXT-ALIGN: center; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto"=20
      align=3Dcenter><SPAN lang=3DEN-US=20
      style=3D"mso-bidi-font-size: 10.5pt">6<o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext =
1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal=20
      style=3D"TEXT-ALIGN: center; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto"=20
      align=3Dcenter><SPAN lang=3DEN-US=20
      style=3D"mso-bidi-font-size: =
10.5pt"></U1:P>6<o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =
BORDER-TOP: medium none; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0cm; =
BORDER-LEFT: medium none; PADDING-TOP: 0cm; BORDER-BOTTOM: windowtext =
1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: =
solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt">
      <P class=3DMsoNormal><SPAN lang=3DEN-US=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312"></U1:P>SQL</SPAN><SPAN=20
      style=3D"FONT-FAMILY: =B7=C2=CB=CE_GB2312">=D3=EF=D1=D4<SPAN =
lang=3DEN-US>(The Database Language=20
      SQL)<o:p></o:p></SPAN></SPAN></P>
      <P class=3DMsoNormal><SPAN lang=3DEN-US=20
      style=3D"COLOR: black; FONT-FAMILY: =B7=C2=CB=CE_GB2312; =
mso-hansi-font-family: =CB=CE=CC=E5">SQL</SPAN><SPAN=20
      style=3D"COLOR: black; FONT-FAMILY: =B7=C2=CB=CE_GB2312; =
mso-hansi-font-family: =
=CB=CE=CC=E5">=D3=EF=D1=D4=B5=C4=CC=D8=B5=E3=A1=A3=CA=FD=BE=DD=B6=A8=D2=E5=
=D3=EF=BE=E4=A1=A3=B5=A5=B1=ED=B2=E9=D1=AF=D3=EF=BE=E4=A1=A3</SPAN><SPAN =

      lang=3DEN-US style=3D"FONT-FAMILY: =
=B7=C2=CB=CE_GB2312"><o:p></o:p></SPAN></P></TD>
    <TD=20
    style=3D"BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; =