Introducing Keys
."$2("0&$""."
+!1J73H11(#"((
(".'+!#"((""
1E!J1!0&##"((".+!
1J73H11#43B1!7#0&###
"#'.&%.0#('
%((".-(+
!)(".(##"(()&$"'%
key+.##%.%(&+1#$#(".
#"(#$/.#$%"%(#
+"'&(#0.""#/&
.(.$("(..+
'((('/.#%.&0.+8&$0
(%&#("primary key)%2("0&('
&<(%#.%#"(("
"(..+670(#%#"(..(#%#+!.
9#%#:&D77+
Using Multiple Tables And Foreign Keys
&$&0-"###&
'.#+3%(0#&''.(
0%(".(1J73H11#43B1!7
+5%#%%&20"#'&(
2A0&.%.1J73H110
("#'.43B1!7+5#%.
&%foreign keys0&"%(#"#
((9":+0&'9$:(
9:(+2("#0&
43B1!7-(".(((".((
1J73H11+5"%.'(".(.
43B1!7(%'.+(""(..
%'.%.+
5'#'"%%'.+8&$0
""0.-$"/%''.%A
%%#"##.&.%#./'#
&#'%#(##+D%.0%#
/%<.#"%+!$#%%
&.%%.(##AB'@+K&$?%#&
$#+!67/&"%(2("%$.
("20%(##%%$.
##'%2("##'%&'"+