tP II

- - - -

tP II

~1~;k~

98

¥1f.J.t,*~~g 1_~t«' ~

! ^W(*

^{J Jt)}

~ ~

: t-1ftTl!.f:

_{~ -='1f-~}

a

~ ~::x

:

⁷ ~ 29

a

~ 3

ip

13:30-14:50

# ^{§ :}

t-.,.Jf.*­

(7-150)

1. ~P1~a)jIU]~~f~I¥J~~5G~~NfljrJ(referential

integrity constraint)

trg~~

(107t)

2.

~~U~rm~~f-tl5£(relational

algebra)

8"Jf:E-@~*im~~-T,

:Ml$

f§lJ~a)jZ(10

7t)

3.

~~u.~ooWrmllMifnl~j:y;~UfOO:(tuple)~~~{J;AB"J1ft~J§~

(10 7})

4.

~~rJm~f~~B"JIE~JHt(normalization)8"J±~§1¥J(10

7t)

5.

(a)

~~a)jf?l5jIt;f§ft«functional dependency)e"Jn.~, ~D A, B4C

(87t)

(b)

_;g;-~:m

w

1r~Ifl;f§ft(:

A,

_B~C, .§.~m=lEm

ftcsecond normal form), J'{U A, B

~filJ!f¥1~?

(7 ?t)

6.

~Rt~-.ml1JJf*Iil(Entity-Relationship

diagram),

j;J~it~~1J

!f4:;[1::

(aJ~Ili~~.tti;.~Wl ---~- __ --_ __. _{_~_--} -_. _

(b)

g~r~*f~m, m~li, fii!~li

(c)

m-ff~r'~-@tJ-.t.(~ 1 _)Z~I

(d)

m-~I~:g,.fj'~-OOtmr~, ijlaJj;J::f.ll~{f:-1lJtmr~(10

7t)

7.

~JtmElA~4J!l!**1C~}it~5

!B"J §

B"J,&:f:ftu1~~~ti:*5 [~~J:lS"J

$Jj(10 7})

8.

~~~~:Mli:r~ffiU(

concurrency control)

*l~B"J:ff:x~(transaction) B"Jm-~~~'r1:? ~P1~1Ja~~~*~tr1:

(107t)

§$p;§AElR.

9• J:l. R7t ::n0

(a)

=~rg~~U.E$(

two-phase locking) (8 fj-)

(b)

=~~!i~JE$:trff~11]EiuJ~? l~:t&~{ilJ?

(7 )J-)