《数据库(数据库设计E-R)》由会员分享，可在线阅读，更多相关《数据库(数据库设计E-R)（55页珍藏版）》请在金锄头文库上搜索。
1、1 7 O By Wei gang Chen May 23 2009 By Wei gang Chen p c SSSNNN 1 OOOVVV 2 E R 3 E R LLL 4 SQL Server By Wei gang Chen p O lllnnn nnn OOO 1 OOO rrrIII JJJ nnnXXX 111 EEE LLL 2 AAA mmmuuu OOO SSSAAA nnnXXX XXX MMM XXX rrr III zzz kkk TTT uuu AAA rrr III LLL 3 nnn OOO rrrIII AAA nnnXXX NNNAAA yyy AAA V
2、VVggg LLL EEE QQQUUU NNNyyy 2 nnnIII 555UUUIII XXX AAA mmm nnn 3 SSS 555 555 III By Wei gang Chen p O 4 VVVggg OOO 333III LLL rrrIII 111 888BBB uuu NNN DBMS OOO MMM NNNVVVggg VVVggg By Wei gang Chen p O 4 666 OOO 333VVVggg OOO 333 KKK eee VVVggg E R NNN DBMS LLL zzz 666 By Wei gang Chen p E R N N8 N
3、NN888 Entity set 1 NNN SSS 333 UUU ppp OOO Object XXX mmmUUU OOO iii 2 555 Attributes NNN kkk AAA555 descriptive properties XXX kkk666 555OOO ccc AAA555 333 555 kkk kkk1 kkk kkk2 3 555 Derived attributes ddd 555OOO 555 bbb kkk2 555 FFF ccc KKK dddccc By Wei gang Chen p E R N8 5 E R L Rectangle LLL N
4、NN888 Ellipse LLL 555 1 VVV Double ellipses LLL 555 2 JJJ LLL 555 3 555 eee IIIkkkeeeyyy TTT 555 By Wei gang Chen p E R N8 5 E R L NNN888 555 fff By Wei gang Chen p E R X8 Relationship Set XXX888 XXX XXX888 XXX888 E R LLL 1 Diamonds LLL XXX888 2 Lines LLL NNN888 XXX888 mmm XXX UUU kkk IIIPPP XXX XXX
5、 NNN888 mmm XXX888 LLL eee www LLL By Wei gang Chen p E R 5 5 Descriptive Attributes XXX kkk 555 555 555 555 1 XXXeee NNN888 kkk XXX888 2 XXX888 kkk 555 FFF 888 FFF PPP 777 888 FFF By Wei gang Chen p E R X8 Degree XXX NNN888 1 E R XXX XXX 2 NNN888 XXX ccc fff 2 XXX kkk XXX LLL By Wei gang Chen p E R
6、 X8 Degree nnn XXX nnn NNN employee branch job OOO LLL works uuu XXX By Wei gang Chen p E R X8 Degree nnn NNN888 mmm XXX mmm XXX XXXnnn NNN888 mmm nnn XXX eee E R UUU 333XXXeee XXX James nnn DB System Concepts By Wei gang Chen p E R X8 Degree nnn NNN888 mmm XXX mmm XXX nnn NNN XXX KKKXXXeee KKK UUU
7、333 XXX James nnn James DB System Concepts vvvkkk NNN James 333 nnn DB System Concepts By Wei gang Chen p E R n X X nnn XXX XXX XXXeee 1 By Wei gang Chen p E R E R L E R XXXeee XXX By Wei gang Chen p E R E R L 1 1 AAA NNN888 XXX 666 XXX ddd eee nnn 666 By Wei gang Chen p E R E R L 2 1 AAA XXX888 XXX
8、 FFF 888 FFF XXXJJJ XXX888333 KKK 777 XXX888MMM LLL 333 AAAuuu LLL AAAuuu LLL 555 kkkXXXeee XXX nnn 666 ddd By Wei gang Chen p E R E R L JJJ 1 666 XXX 2 nnn 666 3 ddd 4 eee 5 FFF 888 FFF By Wei gang Chen p SQL Server Vg lll nnn www SQL Server ddd OOO FFF UUU eee 3 aaa 1 LLL 999 SQL Server 555 tempdb
9、 SQL Server KKK AAA kkk UUU SQL Server 444 tempdb By Wei gang Chen p SQL Server X SQL SERVER 4 XXX 1 model zzz MMM SQL Server EEE model SSSNNN ddd MMM model XXXJJJ rrrFFF 333MMM XXX rrr 333 model MMM zzz MMM ggg By Wei gang Chen p SQL Server X SQL SERVER 4 XXX 1 msdb msdb ggg zzz nnnkkk SQL Server n
10、nn SQL Server Agent msdb 555SSS PPP By Wei gang Chen p SQL Server pubs northwind SSS 1 Pubs JJJ iii 222 AAA 333 SQL Server TTT JJJ SSS fff LLL kkk 12 rrrLLL XXX authors discounts titleview LLL kkk rrr aaa By Wei gang Chen p SQL Server pubs northwind 1 NorthWind JJJ EEE nnn iii TTT 222 AAA 333 SQL Server By Wei gang Chen p
