a) 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.

NOTE: PLEASE Writing is not recommended by hand