Crowdly
Add to Chrome
INTRO. TO DATABASE MGMT. SYST.
Looking for INTRO. TO DATABASE MGMT. SYST. test answers and solutions? Browse our comprehensive collection of verified answers for INTRO. TO DATABASE MGMT. SYST. at moodlenew.iitd.ac.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Which of the following is true about BCNF decomposition?
Consider a relation R(P, Q, R, S, T, U) with the following functional dependencies: 1. P → QR 2. Q → S 3. R → TU
Which of the following functional dependencies must also hold?
Which of the following relations is in BCNF?
Given the following SQL query:
SELECT student_id FROM Enrollments EXCEPT SELECT student_id FROM Exams;
Which of the following Relational Algebra expressions correctly represents this query?
A decomposition is lossless if:
Consider a relation R(P, Q, R, S, T) with the following functional dependencies: 1. PQ → R 2. R → S 3. S → T 4. T → P
The candidate key is PQ.
Which functional dependency (or dependencies) violate BCNF?
Consider a relation R(A, B, C, D) with the functional dependencies:
- A → B
- B → C
- C → D
What is the highest normal form satisfied by R?
Given the following SQL query:
empAge(empNo,age)
SELECT DISTINCT E1.empNoFROM empAge E1JOIN empAge E2ON E1.age > E2.age;
Which of the following Relational Algebra expressions correctly represents this query?
Consider a relation R(M, N, O, P, Q, R) with the following functional dependencies: 1. MN → OP 2. O → Q 3. P → R
R is decomposed into R1(M, N, O, P) and R2(O, Q, P, R).
Is this decomposition lossless?
Given the following SQL query:
studinfo(studid, name, sex)enroll(studId, courseId)
SELECT DISTINCT e.courseIdFROM enroll eWHERE e.courseId NOT IN ( SELECT DISTINCT e1.courseId FROM enroll e1 JOIN studInfo s ON e1.studId = s.studId WHERE s.sex = 'female');
Which of the following Relational Algebra expressions correctly represents this query?