.
TruO'ng D~i HQc cAn ThO' Dap an d~ thi hQc ky 2 Dam hQc 2005-2006
Khoa Cong Ngh~ Thong Tin & TT Mon thi: CO' sit dfi' li~u (CD033) - LAn 02
L(rp: CD Tin hQc K30.
ThOi gian lam bai: 90 photo
NQIDUNG
£.A!!l (1.5 di~m): cho t~p ph\l thuQc ham sau:
F = { AB7 C, B7 DE, CD7 EK, CE7GH, G7 AC }
a. (0.75d) Su d\lng cac tinh chAt cua ph\l thuQc ham de ch(mg minh: AB 7 G.
Tac6: AB 7 C
B 7 DE => B 7 E => AB 7 E
=> AB 7 CE (I)
CE7GH :::> CE 7 G (2)
Tir (1) & (2) => AB7G (dpcm)
b. (0.75d) Kiem tra ph\l thuQc ham sau: BG7 H c6 thuQc F+ hay khong?
Ta c6: BG7 H E F+ <;:> HE (BG)+
M~t khac: (BG)+ = BGDEACKH => H E (BG)+
V~y BG7 H E F+.
~.l (1.0 di~m): tim t~p ph\l thuQc ham t6i thi~u cua t~p ph\l thuQc ham:
F= {A7 BCD, DE7 EFG, D7 EG}
Bwc 1 (0.25d): tach cac thuQc tinh it v~ phii cua cac pth d~ v~ phii chi con mQt thu9c tinh
H= {A7 B,A7 C,A7 D,DE7 E,DE7 F,DE7 G,D7 E,D7 G}
Bwc 2 (0.5d): Lo~i bo cac thuQc tinh thira
-XetA7 B:J= {A7 C,A7 D,DE7 E,DE7 F,DE7 G,D7 E,D7 G}
Ta c6: (A)+J = ACDEGF khong chuaH nen gitI A7 B.
-XetA7 C:J= {A7 B,A7 0, DE7 E,DE7 F,DE7 G,D7 E,D7 G}
Ta c6: (A)+J = ABDEGF khong chua C nen gitI A7 C.
-XetA7 D: J= {A7 B, A7 C,DE7 E, DE7 F,DE7 G, D7 E, D7 G}
Ta c6: (A)+J = ABC khong chua 0 nen gitI A 7 0
-XetDE7 E:J= {A7 B,A7 C,A7 D,DE7 F,DE7 G,D7 E,D7 G}
Ta c6: (DE)+J = DEFG chua E nen lo~i bo DE7 E trong H.

R2(E, F, G) vm kh6a chinh cua quaD h~ R2 1a E
A A
CAU 4 (6.0 diem):
-~ Viet bi~u thuc d~i s5 quaD h~ cho biet s5 hoa dan, hQ ten, dia chi va s5 di~n tho~i cua nhiing
khach hang c6 h6a dan xufit trong thcing 06 Dam 2006.
(I.Od)
E = (MONTH(NG_XHD)=6 AND YEAR(NG_XHD)=2006)
KHACHHANG*HOADON(E) [SOHD,HOTEN, DCHI, SODT]
b. Hay viet bi~u thuc d~i s5 quaD h~ va ve cay bi~u thuc t5i Uti tuang (rug v6'i cau a.
(O.75d)
E = (MONTH(NG_XHD)=6 AND YEAR(NG_XHD)=2006)
(KHACHHANG[MAKH, HOTEN, DCHI, SODT] *
HOADON(E) [SOHD,MAKH))[SOHD, HOTEN, DCHI, SODT]
(O.75d)
[SOHD,HOTEN, DCHI, SODT]
(E) [SOHD , DCHI, SODT]
(=~~~ KHACHHANG
2
~~-
';;' .
.

/
c. Vi~t cau l~nh SQL:
- Cho bi~t hQ ten va s5 di~n tho~i cua cac khach hang co dja chi 6' duCmg 'TrAn Hung
D~o'.
(0.75d)
SELECT HOTEN, SODT
FROM KHACHHANG
WHERE DCHI LIKE '%Tran Hung Dao%'