如何画数据库er图.htm

数据库系统工程师的考点 难点 很值得一看的有

<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">学生选</SPAN></P>
      <P class=MsoNormal><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">课请求</SPAN></P>
      <P class=MsoNormal><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">和成绩</SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:rect><v:rect 
id=_x0000_s1044 
style="LEFT: 3420px; WIDTH: 1080px; POSITION: absolute; TOP: 10332px; HEIGHT: 780px" 
coordsize = "21600,21600" strokecolor = "white"><v:textbox 
style="MARGIN-TOP: 4.687pt; LEFT: auto; MARGIN-LEFT: 8.312pt; WIDTH: 38.875pt; TOP: auto; HEIGHT: 31.062pt; mso-next-textbox: #_x0000_s1044"><![if !mso]>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">教师任</SPAN></P>
      <P class=MsoNormal><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">课信息</SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:rect><v:rect 
id=_x0000_s1039 
style="LEFT: 2880px; WIDTH: 540px; POSITION: absolute; TOP: 9552px; HEIGHT: 4212px" 
coordsize = "21600,21600"><v:textbox 
style="MARGIN-TOP: 4.687pt; LEFT: auto; MARGIN-LEFT: 8.312pt; WIDTH: 11.875pt; TOP: auto; HEIGHT: 202.656pt; mso-next-textbox: #_x0000_s1039"><![if !mso]>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal><SPAN lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
      <P class=MsoNormal><SPAN lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
      <P class=MsoNormal><SPAN lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
      <P class=MsoNormal><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">管理员和学生</SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:rect><v:oval 
id=_x0000_s1040 
style="LEFT: 4320px; WIDTH: 1620px; POSITION: absolute; TOP: 8772px; HEIGHT: 1404px" 
coordsize = "21600,21600"><v:textbox 
style="MARGIN-TOP: 13.812pt; LEFT: auto; MARGIN-LEFT: 17.968pt; WIDTH: 46.562pt; TOP: auto; HEIGHT: 44pt; mso-next-textbox: #_x0000_s1040"><![if !mso]>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      lang=EN-US>1</SPAN></P>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">基本数据</SPAN></P>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">录入维护</SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:oval><v:oval 
id=_x0000_s1046 
style="LEFT: 4500px; WIDTH: 1620px; POSITION: absolute; TOP: 10332px; HEIGHT: 1872px" 
coordsize = "21600,21600"><v:textbox 
style="MARGIN-TOP: 17.25pt; LEFT: auto; MARGIN-LEFT: 17.968pt; WIDTH: 46.562pt; TOP: auto; HEIGHT: 60.531pt; mso-next-textbox: #_x0000_s1046"><![if !mso]>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      lang=EN-US>2</SPAN></P>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">任课数据录入、安排和考勤</SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:oval><v:oval 
id=_x0000_s1047 
style="LEFT: 4500px; WIDTH: 1800px; POSITION: absolute; TOP: 12516px; HEIGHT: 1560px" 
coordsize = "21600,21600"><v:textbox 
style="MARGIN-TOP: 14.656pt; LEFT: auto; MARGIN-LEFT: 19.281pt; WIDTH: 52.937pt; TOP: auto; HEIGHT: 49.5pt; mso-next-textbox: #_x0000_s1047"><![if !mso]>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      lang=EN-US>3</SPAN></P>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">学生选课<SPAN 
      class=GramE>和</SPAN></SPAN></P>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">成绩录入</SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:oval><v:oval 
id=_x0000_s1050 
style="LEFT: 9900px; WIDTH: 1440px; POSITION: absolute; TOP: 10644px; HEIGHT: 1092px" 
coordsize = "21600,21600"><v:textbox 
style="MARGIN-TOP: 11.375pt; LEFT: auto; MARGIN-LEFT: 16.656pt; WIDTH: 40.187pt; TOP: auto; HEIGHT: 32.968pt; mso-next-textbox: #_x0000_s1050"><![if !mso]>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      lang=EN-US>4</SPAN></P>
      <P class=MsoNormal style="TEXT-ALIGN: center" align=center><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">查询</SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:oval><v:rect 
id=_x0000_s1125 
style="LEFT: 10260px; WIDTH: 540px; POSITION: absolute; TOP: 12516px; HEIGHT: 1404px" 
coordsize = "21600,21600"><v:textbox 
style="MARGIN-TOP: 4.375pt; LEFT: auto; MARGIN-LEFT: 8.312pt; WIDTH: 11.875pt; TOP: auto; HEIGHT: 62.25pt; mso-next-textbox: #_x0000_s1125"><![if !mso]>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">教务主任</SPAN></P>
      <P class=MsoNormal><SPAN lang=EN-US><o:p>&nbsp;</o:p></SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:rect><v:group 
id=_x0000_s1127 
style="LEFT: 3420px; WIDTH: 7020px; POSITION: absolute; TOP: 8616px; HEIGHT: 5148px" 
coordsize = "7020,5148" coordorigin = "3420,8616"><v:line id=_x0000_s1043 
style="POSITION: absolute" from = "3420,9708" to = "4320,9708"><v:stroke 
endarrow = "block"></v:stroke></v:line><v:line id=_x0000_s1045 
style="POSITION: absolute" from = "3420,11268" to = "4500,11268"><v:stroke 
endarrow = "block"></v:stroke></v:line><v:line id=_x0000_s1049 
style="POSITION: absolute" from = "3420,12984" to = "4500,12984"><v:stroke 
endarrow = "block"></v:stroke></v:line><v:group id=_x0000_s1058 
style="LEFT: 6480px; WIDTH: 2520px; POSITION: absolute; TOP: 9240px; HEIGHT: 780px" 
coordsize = "2520,780" coordorigin = "7020,8772"><v:rect id=_x0000_s1059 
style="LEFT: 7020px; WIDTH: 2340px; POSITION: absolute; TOP: 8928px; HEIGHT: 468px" 
coordsize = "21600,21600"><v:textbox 
style="MARGIN-TOP: 4.375pt; LEFT: auto; MARGIN-LEFT: 8.312pt; WIDTH: 101.875pt; TOP: auto; HEIGHT: 15.468pt; mso-next-textbox: #_x0000_s1059"><![if !mso]>
<TABLE cellSpacing=0 cellPadding=0 width="100%">
  <TBODY>
  <TR>
    <TD><![endif]>
      <DIV>
      <P class=MsoNormal><SPAN lang=EN-US>F3<SPAN 
      style="mso-spacerun: yes">&nbsp; </SPAN></SPAN><SPAN 
      style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">教师基本情况</SPAN></P></DIV><![if !mso]></TD></TR></TBODY></TABLE><![endif]></v:textbox></v:rect><v:rect 
id=_x0000_s1060 
style="LEFT: 9180px; WIDTH: 360px; POSITION: absolute; TOP: 8772px; HEIGHT: 780px" 
coordsize = "21600,21600" strokecolor = "white"></v:rect><v:line id=_x0000_s1061 
style="POSITION: absolute" from = "7560,8928" to = 
"7560,9396"></v:line></v:group><v:line id=_x0000_s1066 
style="POSITION: absolute" from = "5790,9084" to = "6510,9084"><v:stroke 
endarrow = "block"></v:stroke></v:line><v:line id=_x0000_s1067 
style="POSITION: absolute" from = "5970,9552" to = "6510,9552"><v:stroke 
endarrow = "block"></v:stroke></v:line><v:line id=_x0000_s1068 
style="POSITION: absolute" from = "5790,9864" to = "6510,10332"><v:stroke 
endarrow = "block"></v:stroke></v:line><v:line id=_x0000_s1093 
style="POSITION: absolute" from = "6120,11112" to = "6480,11112"><v:stroke 
endarrow = "block"></v:stroke></v:line><v:line id=_x0000_s1094 
style="POSITION: absolute" from = "6120,11424" to = "6480,11580"><v:stroke 
endarrow = "block"></v:stroke></v:line><v:line id=_x0000_s1101 
style="POSITION: absolute; flip: x" from = "5790,8772" to = 
"6150,10644"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1102 style="POSITION: absolute; flip: y" from = "5430,8616" to = 
"5970,8772"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1103 style="POSITION: absolute; flip: x" from = "5970,9864" to = 
"6510,10800"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1104 style="POSITION: absolute; flip: x" from = "6150,10488" to = 
"6510,10956"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1105 style="POSITION: absolute" from = "5760,12048" to = 
"6480,12204"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1107 style="POSITION: absolute; flip: x" from = "6120,12516" to = 
"6660,12828"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1108 style="POSITION: absolute" from = "6300,13140" to = 
"6660,13140"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1110 style="POSITION: absolute" from = "8820,9240" to = 
"8820,12672"></v:line><v:line id=_x0000_s1111 
style="POSITION: absolute; flip: x" from = "7560,12672" to = 
"8820,12984"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1113 style="POSITION: absolute; flip: y" from = "8280,11580" to = 
"10080,12048"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1114 style="POSITION: absolute" from = "8280,9864" to = 
"10080,10800"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1119 style="POSITION: absolute" from = "6300,13608" to = 
"6660,13764"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1121 style="POSITION: absolute; flip: y" from = "9360,11580" to = 
"10260,13452"><v:stroke endarrow = "block"></v:stroke></v:line><v:line 
id=_x0000_s1122 style="POSITION: absolute; flip: y" from = "7920,10644" to = 
"9000,10800"></v:line><v:line id=_x0000_s1123 style="POSITION: absolute" from = 
"9000,10644" to = "9900,10956"><v:stroke endarrow = 
"block"></v:stroke></v:line><v:line id=_x0000_s1126 style="POSITION: absolute" 
from = "10440,11736" to = "10440,12516"><v:stroke endarrow = 
"block"></v:stroke></v:line></v:group></v:group></v:group></v:group><![endif]--><![if !vml]><span
style='mso-ignore:vglayout;position:absolute;z-index:3;left:0px;margin-left:
23px;margin-top:9px;width:570px;height:408px'><img width=570 height=408
src="如何画数据库ER图.files/image004.gif" v:shapes="_x0000_s1130 _x0000_s1062 _x0000_s1063 _x0000_s1064 _x0000_s1065 _x0000_s1071 _x0000_s1072 _x0000_s1073 _x0000_s1074 _x0000_s1075 _x0000_s1076 _x0000_s1077 _x0000_s1078 _x0000_s1079 _x0000_s1080 _x0000_s1081 _x0000_s1082 _x0000_s1083 _x0000_s1084 _x0000_s1085 _x0000_s1086 _x0000_s1115 _x0000_s1116 _x0000_s1117 _x0000_s1118 _x0000_s1120 _x0000_s1129 _x0000_s1088 _x0000_s1089 _x0000_s1090 _x0000_s1091 _x0000_s1057 _x0000_s1053 _x0000_s1054 _x0000_s1055 _x0000_s1128 _x0000_s1042 _x0000_s1069 _x0000_s1044 _x0000_s1039 _x0000_s1040 _x0000_s1046 _x0000_s1047 _x0000_s1050 _x0000_s1125 _x0000_s1127 _x0000_s1043 _x0000_s1045 _x0000_s1049 _x0000_s1058 _x0000_s1059 _x0000_s1060 _x0000_s1061 _x0000_s1066 _x0000_s1067 _x0000_s1068 _x0000_s1093 _x0000_s1094 _x0000_s1101 _x0000_s1102 _x0000_s1103 _x0000_s1104 _x0000_s1105 _x0000_s1107 _x0000_s1108 _x0000_s1110 _x0000_s1111 _x0000_s1113 _x0000_s1114 _x0000_s1119 _x0000_s1121 _x0000_s1122 _x0000_s1123 _x0000_s1126"></span><![endif]><SPAN lang=EN-US><SPAN style="mso-spacerun: yes">&nbsp; </SPAN></SPAN><SPAN 
style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">（二）</SPAN><SPAN 
lang=EN-US>0</SPAN><SPAN 
style="FONT-FAMILY: 宋体; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">层数据流图</SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><SPAN 
style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </SPAN></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-stops: 396.0pt"><SPAN 
lang=EN-US><o:p>&nbsp;</o:p></SPAN></P>
<P class=MsoNormal style="tab-st