03 t entity-relationship model
TRANSCRIPT
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 1/19
• !"#$%&$'#'( *"$+,$-.,-$
•
!"#$% '()'!
• *+, -.%"/
•
01/$2%. (/$/34 5+6$2 71,8$/ *.8+/34 9:;: *$/<=1/34;+$ 5+>$/33$/34 ?$2+% @$2%+%/.4 A1<+ 01/+$2>.4
(+%B$6 C+>2+ 01/+$%+6
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 2/19
•
/01/2!* 3 45!62521*7*401 08
*92 21*4*:;<267*401=94! 50>26
08 7 >7*7?7=2
2
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 3/19
•
( <$>$8$%" ,$B 8" <"D/"< $% $ E.##"EF./ .G !"#$%$&"'& <$>$•
("#$%$&"'& ,"$/% >6" <$>$ 6$% $ ,.2").2)#"%% +/<"H"/<"/>"I+%>"/E" .2 >6$> +% %",+H"2,$/"/>
•
J:3: -$>$ %>.2"< +/ D#+/3 E$8+/">4 ,$3/"FE$##B .2 .HFE$##B%>.2"< ./ $ 6$2< <+%K .2 L-);M@ +% H"2%+%>"/>
•
*6" H12H.%" +% >. %>.2" +/G.2,$F./ $8.1> E"2>$+/ >BH"% .G.8="E>%4 N6+E6 +% E$##"< "')&* O%"$P +/ <$>$8$%" #$/31$/3"
•
J:3: 8..K%4 $1>6.2%4 H18#+%6"2%4 %>1<"/>%4 #"E>12"2%4 E.12%"%
3
• @A', B+ ' >','C'+"
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 4/19
• J/FF"% $2" 8..K%
• J/F>B E#$%% +% >6" %"> .G $## H.%%+8#" 8..K%
•
J/F>B %"> O$> >6+% ,.,"/>P +% >6" %H"E+DE %"> .G QR 8..K% +/ >6" >$8#" 4
• 2(DD"+E 2(D,F /G'++E 3 2(D,F =",
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 5/19
•
J/FF"% H.%%"%% E"2>$+/ H2.H"2F"%4 N6+E6 $2" E$##"< $S2+81>"%•
*6" "/F>B E#$%% ,$B 6$% >6" %$,"4 $## $S2+81>"% .G >6""/FF"% O<"H"/< ./ >6" <$>$8$%" <"%+3/"2P
•
T12H.%" .G $/ $S2+81>"
• *. +/E#1<" +/G.2,$F./ +/ >6" <$>$8$%"
• J:3: N" N$/> >. K/.N N6$> F>#" .G "$E6 8..K4 %. N"+/E#1<" >6" *+>#" $S2+81>"
• *. 6"#H 1/+U1"#B +<"/FGB +/<+V+<1$# "/FF"% N+>6+/ $/ "/F>BE#$%%
• J:3: N" ,$B N+%6 >. +/E#1<" H18#+%6"2W% 9-)/1,8"2$S2+81>" G.2 >6" (+,-%$."#$ "/F>B E#$%%
• (2" 1%"< >. <"%E2+8" 2"#$F./%6+H% 8">N""/ >6" "/FF"% +/<+X"2"/> "/F>B E#$%%"%
•
?" N+## <+%E1%% #$>"2::5
• 7H$BC-,"+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 6/19
•
/001$ $S2+81>"%Y• *+>#"Y Z.#<% >6" +/G.2,$F./ $8.1> >6" F>#" .G $ 8..K
•
95A[Y \%"< >. 1/+U1"#B +<"/FGB >6" 8..K N+>6+/ >6" /001$ "/F>B E#$%%
•
T2+E"Y Z.#<% >6" +/G.2,$F./ $8.1> >6" H2+E" .G $ 8..K
• 2+&.0#$ $S2+81>"%Y
• (1[$,"Y Z.#<% >6" +/G.2,$F./ $8.1> >6" /$," .G $/ $1>6.2•
(1T6./"Y Z.#<% >6" +/G.2,$F./ $8.1> >6" H6./" /1,8"2 .G $/$1>6.2
•
(19-Y \%"< >. 1/+U1"#B +<"/FGB >6" $1>6.2 N+>6+/ >6" 2+&.0#$ "/F>BE#$%%
•
(+,-%$."#$ $S2+81>"%Y
•
T18[$,"Y Z.#<% >6" +/G.2,$F./ $8.1> >6" /$," .G $ H18#+%6"2
• T18T6./"Y Z.#<% >6" +/G.2,$F./ $8.1> >6" H6./" /1,8"2 .G $H18#+%6"2
•
T189-Y \%"< >. 1/+U1"#B +<"/FGB >6" H18#+%6"2 N+>6+/ >6" (+,-%$."#$ "/F>B E#$%%
6
• *A" 7H$BC-,"+ %I 64?<7<: J','C'+"
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 7/19
•
*6"2" +% /. <+2"E> N$B >. >"## N6. +% >6" $1>6.2 .G $ 3+V"/ 8..K
•
*6" *+>#" $S2+81>" <."% /.> 1/+U1"#B +<"/FGB >6" 8..K O>..,$/B 8..K% 6$V" >6" %$," F>#"P: *6" 95A[ 6"2" +% $U1+/>"%%"/F$# +<"/FGB+/3 $S2+81>"
•
?" ,$B 2"$%./$8#B $%%1," >6$> /. N$B >N. H18#+%6"2% +/ >6"N.2#< 6$V" >6" %$," /$," $/< >6" %$," H6./" /1,8"2: Z"/E"
>6"%" >N. $S2+81>"% >.3">6"2 1/+U1"#B +<"/FGB >6" H18#+%6"2•
["V"2>6"#"%%4 N" 6$V" +/E#1<"< >6" H18#+%6"2W% 9- $S2+81>">. ,$K" >6" +<"/FDE$F./ ,.2" E./V"/+"/> O,.2" "]E+"/>P
7
• <"#'$.+ 'C%-, ,A"+" 'H$BC-,"+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 8/19
•
51H"2K"B% $2" %"> .G $S2+81>"% >6$> 1/+U1"#B +<"/FD"% $/B "/F>BG2., $,./3 $## H.%%+8#" "/FF"% +/ >6" "/F>B E#$%%
• J:3: *6" %"> .G ^95A[_ +/ >6" /001$ "/F>B E#$%%4 >6" %"> .G ^T189-_ $/<^T18[$,"4 T18T6./"_ $2" 8.>6 %1H"2K"B% G.2 >6" (+,-%$."#$ "/F>B E#$%%
• 51H"2K"B% $HH#+"% >. "/F>B E#$%%"%4 $/< /.> >. "/F>B %">%:
• J:3: 5"" >6" %"> .G ^*+>#"%_ +/ >6" %$,H#" AMM!5
• ( !"B +% $ ,+/+,$# %1H"2K"B• J:3: 95A[4 (19-4 $/< T189- +/ %$,H#" 79A;(;0 <$>$8$%"
• !"B% $2" %.,"F,"% E$##"< E$/<+<$>" K"B%4 %+/E" +> +% 1%1$##B >6" E$%"
>6$> N" 1%" $% $/ +<"/FD"2%
• ( K"B ,$B E./>$+/ ,.2" >6$/ ./" $S2+81>"
• J:3: ^5.E+$#5"E12+>B[1,8"2%_ $/< ^C1##[$,"4 C1##(<<2"%%4 -$>"MGA+2>6_ $2"K"B% G.2 \5 3%)4"'$ "/F>B E#$%%
• K"F+ '(J =-L"$."F+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 9/19
J/F>B ;"#$F./%6+H -+$32$, .2 J`; -+$32$,
• <"G'D%(+ABL+ ?",M""( 2(DD"+
An entity-relationship
diagram
E/R diagram
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 10/19
•
@$/B)>.),$/B 2"#$F./%6+H• J:3: 9/ 2"#$F./%6+H 8">N""/ /001$ $/< 2+&.0#$4 $ 8..K ,$B 6$V" ,$/B
$1>6.2% $/< $/ $1>6.2 ,$B N2+>" ,$/B 8..K%
•
M/")>.),$/B 2"#$F./%6+H• J:3: 9/ 2"#$F./%6+H 8">N""/ (+,-%$."#$ $/< /001$4 ./" H18#+%6"2 ,$B
H18#+%6 ,$/B 8..K%4 81> $ 8..K ,$B ./#B 8" H18#+%6"< 8B $> ,.%> ./"H18#+%6"2 O$%%1,"<P
•
M/")>.)./" 2"#$F./%6+H• -"D/+F./Y J$E6 "/F>B ./ "$E6 %+<" +% 2"#$>"< >. $> ,.%> ./" "/F>B ./
>6" .>6"2 %+<" .G >6" 2"#$F./%6+H
•
J:3: 9/ 2"#$F./%6+H 8">N""/ 2+&.0#$ $/< 30'&#%,+&0#$ • @+36> 8" E.,8+/"< +/>. ./" "/F>B E#$%% +G >6"B %6$2" >6" %$,"
$S2+81>"%
*BH"% .G ;"#$F./%6+H%
• <"G'D%(+ABL ?",M""( 2(DD"+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 11/19
•
(/ J`; ,.<"# .G $ <$>$8$%" +% $/ $8%>2$E> ,.<"#4 V+%1$#+a"<>62.136 $/ J`; <+$32$,
• *. +,H#","/> >6" J`; ,.<"#4 N" /""< >. +,H#","/> %"V"2$#>6+/3%Y
• *6" "/FF"%
• *6" "/F>B E#$%%"%
• *6" "/F>B %">%
• *6" 2"#$F./%6+H% 8">N""/ >6" "/F>B E#$%%"%
•
9,H#","/F/3 >6" 2"#$F./%6+H% 1%1$##B +/V.#V"% %.," E6$/3"%
>. >6" "/F>B E#$%%"%4 ":3: 8B $<<+/3 %.," $S2+81>"%•
*6" 2"%1#> .G >6+% +,H#","/>$F./ +% $ 2"#$F./$# <$>$8$%"
;"#$F./$# -$>$8$%"%
• 4#LG"#"(D(& 2;< 5%J"G+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 12/19
•
9,H#","/>$F./ .G $ /001$ "/F>BY• *+>#" b c./" ?+>6 $ ?+/<
• 95A[ b d)Q')eRfghi)j
• T2+E" b k'R:dd
• J/F>B L#$%%"%Y *$8#" 5E6","%
• /001$ "/F>B E#$%%l $S2+81>"%Y ^95A[4 *+>#"4 T2+E"_
.2 N" E$/ N2+>" >6+% $% A..K% O95A[4 *+>#"4 T2+E"P
• 4#LG"#"(D(& 2(DD"+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 13/19
•
J/F>B 5">%Y *$8#"%• *6" D2%> 2.N .G >6" >$8#" +% >6" >$8#" %E6"," G.2 >6" "/F>B E#$%%
• J$E6 .G >6" .>6"2 2.N% .G >6" >$8#" +,H#","/>% $/ "/F>B
• *6" %"> .G $## 2.N% .G >6" >$8#"4 "IE"H> >6" D2%> 2.N4 +,H#","/>% >6"
"/F>B %">
30')'+"5
• 4#LG"#"(D(& 2(DD"+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 14/19
•
J$E6 E.#1,/ +% #$8"#"< N+>6 $ <+%F/E> 78#%,+&" '79" (+4 .2 +%$#%. E$##"< :0-+9' ."75%';
• *6" "#","/>% .G $ E.#1,/ +% E$##"< >6" 5097%' G.2 >6$> E.#1,/
• [. >N. 2.N% .G >6" >$8#" $2" +<"/FE$#
•
( >$8#" ,$B O81> /.> 2"U1+2"<P 6$V" $ /$,"4 ":3: AMM!5
• *6" /1,8"2 .G 2.N% +% E$##"< >6" $%4" .G >6" >$8#"4 >6" /1,8"2.G E.#1,/% +% E$##"< >6" 5";#"" .G >6" >$8#"
•
*. ",H6$%+a" >6" $S2+81>"% .G $ >$8#"4 <"/.>" $ >$8#" 8B N2+F/3*O(Q4 ('4 m4 (/P: J:3: AMM!5 O95A[4 *+>#"4 T2+E"P
• *6" .2<"2 .G >6" 2.N% .G $ >$8#" +% /.> +,H.2>$/>5+,+#$2#B4 >6" .2<"2 .G E.#1,/% +% $#%. /.> +,H.2>$/>
•
-+X"2"/> E.#1,/% ,$B 6$V" >6" %$," <.,$+/4 $% #./3 $% >6"$S2+81>"% $2" <+X"2"/>
• /%(N"L, %I ' *'CG"
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 15/19
• 4#LG"#"(D(& ,A" <"G'D%(+ABL+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 16/19
•
(<< (+,-%$."#<= 2"#$F./%6+H >. /001$ "/F>B E#$%%• (<< T189- >. >6" /001$ "/F>B E#$%%Y A..K% O95A[4 *+>#"4 T189-4 T2+E"P
• *6" /001$ >$8#" %E6"," +% /.N ^95A[4 *+>#"4 T189-4 T2+E"_
M/")>.)@$/B ;"#$F./%6+H
• 4#LG"#"(D(& ,A" <"G'D%(+ABL+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 17/19
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 18/19
•
L$//.> 8" +,H#","/>"< N+>6 >N. <+%F/E> ./")>.),$/B2"#$F./%6+H%Y E$1E+/3 2"<1/<$/EB
• ?" ,$B 1%" $HH2.$E6 >. +,H#","/F/3 >6+% 8B $<<+/3 /"N>$8#" %E6"," >. >6" <$>$8$%"
• A..K`(1>6.2 "/F>B E#$%%Y A..K`(1>6.2 O95A[4 (19-P
@$/B)>.)@$/B ;"#$F./%6+H
• 4#LG"#"(D(& ,A" <"G'D%(+ABL+
8/10/2019 03 T Entity-Relationship Model
http://slidepdf.com/reader/full/03-t-entity-relationship-model 19/19
•
J$E6 V$#1" .G >6" G.2"+3/ K"B ,1%> 6$V" ,$>E6+/3 V$#1" +/ >6"2"G"2"/E"< K"BM>6"2N+%"4 N" N.1#< 6$V" $ %.)E$##"< 57';-%'; #"="#"':"
• *6" 2"U1+2","/> +% E$##"< #"="#"')7- :0'$%'&
• *6" H2.8#", .G "/%12+/3 >6" G1##D## .G >6+% 2"U1+2","/> +% E$##"<
#"="#"')7- %'&";#%&*
•
Z.N >6+% ,+36> 8" $ H2.8#",o
• 9/ +/%"2F/3 /"N "/F>B >. $/ "/F>B %">
• 9/ 1H<$F/3 $ K"B .G >6" 2"G"2"/E"< "/F>B
• 9/ <"#"F+/3 >6" "/F>B N6+E6 +% 2"G"2"< +/ >6" .>6"2 "/F>B
•
Z.N >. H2"V"/> >6+%o
• 5"p/3 1H >6" :7$:75%'; 1H<$>"% $/< <"#"F./%
L./%+<"2$F./% +/ "/F>B)2"#$F./%6+H ,.<"#
• <"I"$"(D'G 4(,"&$B,F