1. For the given database schema:

R1(A,B,C,D)

R2(A,E)

R3(B,F,H)

R4(C,G)

R5(H,I)

Please list all the foreign keys in R1.

	a.	A
	b.	B
	c.	C
	d.	All of A, B, and C are foreign key in R1

2. Given universal schema R(A,B,C,D,E,F,G,H,I) and a set of functional dependencies as follows:

AB CD

A E

B FH

C G

D B

G C

H I

when schema R(A,B,C,D,E,F,G,H,I) is normalized or decomposed into the following schema:

R1(A,B,C,D)

R2(A,E)

R3(B,F,H)

R4(C,G)

R5(H,I)

	a.	The normalized schema: R1(A,B,C,D) R2(A,E) R3(B,F,H) R4(C,G) R5(H,I) possesses the lossless join decomposition property.
	b.	The normalized schema: R1(A,B,C,D) R2(A,E) R3(B,F,H) R4(C,G) R5(H,I) possesses the functional dependency preservation property.
	c.	Both a. and b.
	d.	neither a. nor b.