31. The following query will execute without errors:
select customer.customer_name, salesman.sales_quota
from customer
where customer.salesman_id =
(select salesman_id
from salesman
where lname = ‘SMITH’);
a.TRUE
b.FALSE
32. Table TT {J , D , C , V , N , G } and a set of functional
dependencies
J,C,N → V,G
D → C,V,G
J → D,C,G
The closure of {D } is:
Giáo Trình Cơ Sở Dữ Liệu Trang 102
Biên soạn : Phan Tấn Quốc- Trường Cao Đẳng Kỹ Thuật Cao Thắng
a) J D C V N G
b) J D C V G
c) J C V G
d) D C V N
e) D C V G
33. Table TT {O , M , Z , I , Q } and a set of functional dependencies
O → I,Q
I → M,Z
O,Z → M
Table TT is:
a) 1 NF
b) 2 NF
c) 3 NF

(d) All of the above
(e) A and C
39. Table Q(A,B,C) and a set of functional dependencies
AB → C;
C → A;
Table Q is:
a) 1 NF
b) 2 NF
c) 3 NF
d) BCNF
40. Table Q(A,B,C,D) and a set of functional dependencies
AB → C;
D → B;
C → AD
Table Q is:
a) 1 NF
e) 2 NF
f) 3 NF
g) BCNF
41. The following table and functional dependencies exhibits what
type of dependency?
Table(A, B, C)
A -> C
A -> B
B -> C
(a) Partial Dependence
(b) Transitive Dependence
(c) Full Dependence
(d) A and B
(e) None of the above