From the instance of a relation scheme R (A, B, C) | A | B | C

Back to the 2019 paper

Module 2: Relational Query Languages & Design

20192m

From the instance of a relation scheme R (A, B, C)

A	B	C
1	1	1
1	1	0
2	3	2
2	3	2

we can conclude that:
(i) A functionally determines B and B functionally determines C
(ii) A functionally determines B and B does not functionally determine C
(iii) B does not functionally determine C
(iv) A does not functionally determine B and B does not functionally determine C

Search Google Ask AI

Similar questions

Database Management SystemFor relation: R(A,B,C); FDs={A \rightarrow B, B \rightarrow A}. Which statement is true? (i) A and B both are candidate keys (ii) Only A is key (iii) Only B is key (iv) Neither A nor B is key20252m Database Management SystemConsider the relation scheme R = {E, F, G, H, I, J, K, L, M, N} and the set of functional dependencies {{E, F} → {G}, {F} → {I, J}, {E, H} → {K, L}, K → {M}, L → {N}} on R. What is the key for R? (i) {E, F} (ii) {E, F, H} (iii) {E, F, H, K, L} (iv) {E}20192m Database Management SystemCompute the closure (F+) of the following set of functional dependencies for the relational schema (A, B, C, D, E) = R. List the candidate keys for R: A → BC CD → E B → D E → A202014m Database Management SystemYou are given the following set F of functional dependencies for a relation: R(A, B, C, D, E, F): F = {ABC → D, ABD → E, CD → F, CDF → B, BF → D} (i) Find all keys of R based on these functional dependencies. (ii) Is this relation in Boyce-Codd normal form? Is it 3NF? Explain your answer. (iii) Can the set F be simplified (by removing functional dependencies or by removing attributes from the left-hand side of functional dependencies) without changing the closure of F (i.e. F+)?20199m

PreviousGiven the Students' relation as shown below: | StudentID | StudentName | StudentE-mail | StudentAge | CPI | |---|---|---|---|---| | 2345 | Shankar | shankar@math | X | 9.4 | | 1287 | Swati | swati@ee | 19 | 9.5 | | 7853 | Shankar | shankar@cse | 19 | 9.4 | | 9876 | Swati | swati@mech | 18 | 9.3 | | 8765 | Ganesh | ganesh@civil | 19 | 8.7 | For (StudentName, StudentAge) to be the key for this instance, the value X should not be equal to: (i) 18 (ii) 19 (iii) 15 (iv) 20 NextDatabase is generally: (i) system centered (ii) user centered (iii) company centered (iv) data centered

Official AppAndroid App

PYQDeck for Android

Solve BEU previous-year exam papers anywhere, anytime. Fast search, offline paper viewing, and step-by-step solutions designed specifically for your phone.

Get on Google Play