University registration database is distributed to three sites S1, S2 and S3. Co

Question

University registration database is distributed to three sites S1, S2 and S3. Consider two relations Student (ssn, Fname, Lname, Major, StartDate) Enrollment (ssn, courselD, Semester) Student is fragmented using following selects: S1: select * from Student where Major lessthan "Comp and Info Tech" S2: select * from student where Major greaterthan= "Comp and Info Tech" and    Major lessthan   "History" S3: select * from Student where Major greaterthan "History" Relation Enrollment is fragmented using derived horizontal fragmentation    using   same  filtering predicates and allocated to respective sites. Which sites following queries will be executed. Select * from Student where StartDate = "2015" and Major = "English" Select * from student natural join Enrollment where semester = "Spring2015" and major lessthan = "English" Select * from Enrollment where semester = 'Fall2015"

Explanation / Answer

(a) S2

(b) S2

(c) S3

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.