Consider a relation R=(A,B,C,D) with the following instance:

A	B	C	D
1	1	2	3
1	2	2	3
1	3	2	3
2	4	5	6
3	6	7	8

Which of the following function dependencies are satisfied? Why or How?

1. A => B

2. A => CD

3. C => D

b) The SQL like operator is case sensitive, but the lower () function on strings can be used to perform case insensitive matching. To show how, write a query that finds departments whose names contain the string sci as a substring, regardless of the case.