BITE302L Database Systems (Theory) Winter 2024-25 (B2+TB2) [VL2024250502774]
Looking for BITE302L Database Systems (Theory) Winter 2024-25 (B2+TB2) [VL2024250502774] test answers and solutions? Browse our comprehensive collection of verified answers for BITE302L Database Systems (Theory) Winter 2024-25 (B2+TB2) [VL2024250502774] at moovit.vit.ac.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Consider a relation schema R(A, B, C, D) and the set of functional dependencies F = {A determines B, B determines C, C determines D}. A minimal cover of F is
0%
0%
0%
100%
View this question
Which of the following statements is FALSE?
0%
0%
33%
0%
View this question
Consider the relation schema (Hotel_no, Guest_no, Date_from, Date_to, Room_no, primary key(Hotel_no, Guest_no, Date_from). An expression in relational algebra to find out the guest number (guest_no) who stayed in hotel number (hotel_no) 72 but never stayed in hotel number 74 can be
0%
100%
0%
0%
View this question
Suppose that the relation R(A, B, C, D, E) has the following functional dependencies: A determines B, B determines C, BC determines A, A determines D, E determines A, D determines E. Which of the following is not a key of R?
0%
100%
0%
0%
View this question
The set of rules that can be used to find logically implied functional dependencies from a given set of functional dependencies is called
100%
0%
0%
0%
View this question
If there are four tuples in a state of a relation R(A, B, C, D) and the tuplese are t1 = <a1, b1, c1, d1>, t2 = <a1, b1, c1, d2>, t3 = <a1, b2, c2, d1> and t4 = <a2, b1, c3, d1> then which of the following functional dependencies hold on the relation?
0%
100%
0%
0%
View this question
A minimal cover of the set {A determines B, B determines C, A determines C} is
0%
0%
0%
100%
View this question
Consider the relation schema LICENSE(License_id primary key, Fname, Lname, City, Phone, Age). An expression in relational algebra to find out license id, city and phone number of license holder whose first name starts with an A and is above 20 years of age can be
0%
0%
100%
0%
View this question
Consider the set of functional dependencies F = {A determines BC, CD determines E, B determines D, E determines A} defined on a relation schema R(A, B, C, D, E). Which of the following statements is FALSE?
0%
0%
100%
0%
View this question
Want instant access to all verified answers on moovit.vit.ac.in?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!