Given fig3. below and its functional dependencies, FD1, FD2, FD3, r(R) ABCDEFJKM fig3.) FD1 FD2 FD3 which functional dependency is a partial dependency? FD1 O FD2 O FD3 O None of them are partial dependencies.

Course: Principles of Database   please solve it within 30 minutes. please please, pleaseThank you Single Choice Questions 11. Given a relation R and a condition f for selecting from relation R, the correct relational algebraic expression is (    ). A、R X R             B、 R ⋈ R        C、sf(R)                 D、 ∏f(R) 12. If relations R and S have a common attribute set Y, when executing , tuples that do not have matching values on attribute Y will be discarded. To avoid discarding those tuples, which operation should be used? (    ) A. Aggregation.                        B. Grouping. C. Outer union.                        D. Outer join. 13. To address the "lost update" problem, a transaction must obtain (    ) before updating a data set. A. Shared lock (S-lock).               B. Exclusive lock (X-lock). C. Shared lock (S-lock) and exclusive lock (X-lock). D. Shared lock (S-lock) or exclusive lock (X-lock). 14. If, during the system operation, data stored on external storage is…

Please explain

Suppose the functional dependency StudentIDàStudentName is correct. If we know the StudentName value for a given student, can we know the only StudentID value which the given student has? If not, give an example to justify your answer.