📄 图书管理系统数据库设计说明书.htm
字号:
style="mso-bookmark: _Toc521466033"><B><SPAN lang=EN-US
style="FONT-FAMILY: 黑体; mso-fareast-font-family: 宋体">VF7.0/PowerDesigner</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466033"><SPAN lang=EN-US
style="FONT-SIZE: 15pt; mso-bidi-font-size: 12.0pt"><o:p></o:p></SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 21pt; TEXT-ALIGN: center"
align=center><SPAN style="mso-bookmark: _Toc521466033"><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 22pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">第三章</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466033"><B
style="mso-bidi-font-weight: normal"><SPAN style="FONT-SIZE: 22pt"><FONT
face="Times New Roman"> </FONT></SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466033"><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 22pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">结构设计</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466033"></SPAN><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 22pt"><o:p></o:p></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><A name=_Toc521466034><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><FONT
face="Times New Roman">3.1</FONT></SPAN></B></A><SPAN
style="mso-bookmark: _Toc521466034"><B
style="mso-bidi-font-weight: normal"><SPAN
style="FONT-SIZE: 15pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">概念结构设计</SPAN></B></SPAN><SPAN
style="mso-bookmark: _Toc521466034"></SPAN><B
style="mso-bidi-font-weight: normal"><SPAN lang=EN-US
style="FONT-SIZE: 15pt"><o:p></o:p></SPAN></B></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%"><A
name=_Toc521466035></A><A name=_Toc124326123><SPAN
style="mso-bookmark: _Toc521466035"><SPAN class=CharChar1><SPAN lang=EN-US
style="FONT-WEIGHT: normal; FONT-SIZE: 15pt; LINE-HEIGHT: 150%; mso-bidi-font-size: 16.0pt; mso-bidi-font-family: 'Times New Roman'"><o:p><FONT
face=Arial> </FONT></o:p></SPAN></SPAN></SPAN></A></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc124326123"><SPAN
style="mso-bookmark: _Toc521466035"><SPAN class=CharChar1><SPAN lang=EN-US
style="FONT-WEIGHT: normal; FONT-SIZE: 15pt; LINE-HEIGHT: 150%; mso-bidi-font-size: 16.0pt; mso-bidi-font-family: 'Times New Roman'"><o:p><FONT
face=Arial> </FONT></o:p></SPAN></SPAN></SPAN></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%"><v:group
id=_x0000_s1091
style="MARGIN-TOP: 54.6pt; Z-INDEX: 5; LEFT: 0px; MARGIN-LEFT: 36pt; WIDTH: 261pt; POSITION: absolute; HEIGHT: 192.3pt; TEXT-ALIGN: left"
coordorigin="2415,5496" coordsize="5220,3846"><v:rect id=_x0000_s1092
style="LEFT: 5020px; WIDTH: 750px; POSITION: absolute; TOP: 6900px; HEIGHT: 624px"><v:shadow
on="t" offset="6pt,6pt"></v:shadow><v:textbox
style="mso-next-textbox: #_x0000_s1092">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-size: 10.5pt">图书</SPAN></P></DIV></TD></TR></TBODY></TABLE></v:textbox></v:rect><v:oval
id=_x0000_s1093
style="LEFT: 3970px; WIDTH: 1260px; POSITION: absolute; TOP: 6018px; HEIGHT: 726px"><v:textbox
style="mso-next-textbox: #_x0000_s1093" inset=".5mm,4.3mm,.5mm,.3mm">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">出版日期</SPAN></P></DIV></TD></TR></TBODY></TABLE></v:textbox></v:oval><v:oval
id=_x0000_s1094
style="LEFT: 5835px; WIDTH: 1620px; POSITION: absolute; TOP: 8616px; HEIGHT: 726px"><v:textbox
style="mso-next-textbox: #_x0000_s1094" inset=".5mm,4.3mm,.5mm,.3mm">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">条形码</SPAN></P></DIV></TD></TR></TBODY></TABLE></v:textbox></v:oval><v:oval
id=_x0000_s1095
style="LEFT: 2415px; WIDTH: 1320px; POSITION: absolute; TOP: 6744px; HEIGHT: 726px"><v:textbox
style="mso-next-textbox: #_x0000_s1095" inset=".5mm,4.3mm,.5mm,.3mm">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">出版社</SPAN></P></DIV></TD></TR></TBODY></TABLE></v:textbox></v:oval><v:oval
id=_x0000_s1096
style="LEFT: 5220px; WIDTH: 1260px; POSITION: absolute; TOP: 5496px; HEIGHT: 726px"><o:extrusion
backdepth="1in" viewpoint="0" viewpointorigin="0" skewangle="-90"
type="perspective" v:ext="view"></o:extrusion><v:textbox
style="mso-next-textbox: #_x0000_s1096" inset=".5mm,4.3mm,.5mm,.3mm">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">图书编号</SPAN></P></DIV></TD></TR></TBODY></TABLE></v:textbox></v:oval><v:oval
id=_x0000_s1097
style="LEFT: 2595px; WIDTH: 1111px; POSITION: absolute; TOP: 7836px; HEIGHT: 624px"><v:textbox
style="mso-next-textbox: #_x0000_s1097" inset=".5mm,4.3mm,.5mm,.3mm">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">库存</SPAN></P></DIV></TD></TR></TBODY></TABLE></v:textbox></v:oval><v:oval
id=_x0000_s1098
style="LEFT: 6310px; WIDTH: 869px; POSITION: absolute; TOP: 6276px; HEIGHT: 624px"><v:textbox
style="mso-next-textbox: #_x0000_s1098" inset=".5mm,4.3mm,.5mm,.3mm">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
style="BORDER-LEFT-COLOR: #ece9d8; BORDER-BOTTOM-COLOR: #ece9d8; BORDER-TOP-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ece9d8">
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">书名</SPAN></P></DIV></TD></TR></TBODY></TABLE></v:textbox></v:oval><v:line
id=_x0000_s1099 style="POSITION: absolute; flip: y" from="5590,6276"
to="5770,6900"><FONT size=3></FONT></v:line><v:line id=_x0000_s1100
style="POSITION: absolute; flip: y" from="5770,6588" to="6310,6900"><FONT
size=3></FONT></v:line><v:line id=_x0000_s1101 style="POSITION: absolute"
from="5770,7368" to="7635,7524"><FONT size=3></FONT></v:line><v:line
id=_x0000_s1102 style="POSITION: absolute" from="5770,7524"
to="6195,8616"><FONT size=3></FONT></v:line><v:line id=_x0000_s1103
style="POSITION: absolute; flip: x" from="4755,7524" to="5230,8772"><FONT
size=3></FONT></v:line><v:line id=_x0000_s1104
style="POSITION: absolute; flip: x" from="3675,7368" to="5050,7992"><FONT
size=3></FONT></v:line><v:line id=_x0000_s1105
style="POSITION: absolute; flip: x" from="3675,7212" to="5050,7213"><FONT
size=3></FONT></v:line><v:line id=_x0000_s1106
style="POSITION: absolute; flip: x y" from="4870,6744"
to="5050,6900"><FONT size=3></FONT></v:line></v:group><STRONG><SPAN
style="mso-bookmark: _Toc124326123"><SPAN
style="mso-bookmark: _Toc521466035"><SPAN class=CharChar1><SPAN lang=EN-US
style="FONT-SIZE: 14pt; LINE-HEIGHT: 150%; mso-bidi-font-weight: normal; mso-bidi-font-family: 'Times New Roman'"><FONT
face=Arial>3.1.1</FONT></SPAN></SPAN></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc124326123"><SPAN
style="mso-bookmark: _Toc521466035"><SPAN class=CharChar1><SPAN
style="FONT-SIZE: 14pt; LINE-HEIGHT: 150%; FONT-FAMILY: 黑体; mso-bidi-font-weight: normal; mso-ascii-font-family: Arial; mso-bidi-font-family: 'Times New Roman'">实体和属性的定义</SPAN></SPAN></SPAN></SPAN></STRONG><SPAN
style="mso-bookmark: _Toc124326123"><SPAN
style="mso-bookmark: _Toc521466035"><SPAN class=CharChar1><SPAN
style="FONT-WEIGHT: normal; FONT-SIZE: 14pt; LINE-HEIGHT: 150%; FONT-FAMILY: 黑体; mso-ascii-font-family: Arial; mso-bidi-font-family: 'Times New Roman'">：</SPAN></SPAN></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc124326123"></SPAN><SPAN
style="mso-bookmark: _Toc521466035"><SPAN lang=EN-US
style="FONT-SIZE: 15pt; LINE-HEIGHT: 150%; FONT-FAMILY: 黑体"><BR></SPAN></SPAN><SPAN
style="mso-bookmark: _Toc521466035"><SPAN lang=EN-US
style="FONT-SIZE: 12pt; LINE-HEIGHT: 150%"><FONT
face="Times New Roman">
</FONT></SPAN></SPAN><SPAN style="mso-bookmark: _Toc521466035"><SPAN
style="FONT-SIZE: 12pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">图书（图书编号，图书名称，作者，出版社，出版日期，备注，价格，库存）</SPAN></SPAN><SPAN
style="mso-bookmark: _Toc521466035"><SPAN lang=EN-US
style="FONT-SIZE: 12pt; LINE-HEIGHT: 150%"><o:p></o:p></SPAN></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466035"><SPAN lang=EN-US
style="FONT-SIZE: 12pt; LINE-HEIGHT: 150%"><o:p><FONT
face="Times New Roman"> </FONT></o:p></SPAN></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%"><SPAN
style="mso-bookmark: _Toc521466035"><SPAN lang=EN-US
style="FONT-SIZE: 12pt; LINE-HEIGHT: 150%"><o:p><FONT
face="Times New Roman"> </FONT></o:p></SPAN></SPAN></P>
<P class=MsoNormal
style="MARGIN: 0cm -3.8pt 0pt 0cm; LINE-HEIGHT: 150%; mso-para-margin-right: -.36gd"><SPAN
style="mso-bookmark: _Toc521466035"><SPAN lang=EN-US
style="FONT-SIZE: 12pt; LINE-HEIGHT: 150%"><o:p><FONT
face="Times New Roman"> </FONT></o:p></SPAN></SPAN></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: 150%"><v:oval
id=_x0000_s1090
style="MARGIN-TOP: 0px; Z-INDEX: 4; LEFT: 0px; MARGIN-LEFT: 297pt; WIDTH: 54pt; POSITION: absolute; HEIGHT: 31.2pt; TEXT-ALIGN: left"><v:textbox
style="mso-next-textbox: #_x0000_s1090" inset=".5mm,4.3mm,.5mm,.3mm">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -