33 Views

Question : Section (sect name, wing, expenses) and Student (student_ID, name, sect name, fees).

Here in both of these relations, the sect_name attribute appears commonly. In this case, using common attributes in the relation schema is a way in which we can relate the ___________ relations.

Option 1: Tuple of common

Option 2: Attributes of common

Option 3: Attributes of distinct

Option 4: Tuple of distinct


Team Careers360 16th Jan, 2024
Answer (1)
Team Careers360 22nd Jan, 2024

Correct Answer: Tuple of distinct


Solution : In left, the related time periods don't overlap if two separate tuples include part ranges that meet or overlap (though they might meet). The associated part ranges don't overlap in right if two separate tuples have time periods that meet or overlap (though they might meet).

Hence the Correct answer is option 4.

Related Questions

Amity University | M.Tech Adm...
Apply
Ranked amongst top 3% universities globally (QS Rankings).
Amity University Noida MBA Ad...
Apply
Amongst top 3% universities globally (QS Rankings)
Amity University Noida B.Tech...
Apply
Among Top 30 National Universities for Engineering (NIRF 2024) | 30+ Specializations | AI Powered Learning & State-of-the-Art Facilities
Amity University, Noida BBA A...
Apply
Ranked amongst top 3% universities globally (QS Rankings)
Shoolini University Admission...
Apply
NAAC A+ Grade | Ranked No.1 Private University in India (QS World University Rankings 2025) | 5000+ Placements
Graphic Era (Deemed to be Uni...
Apply
NAAC A+ Grade | Among top 100 universities of India (NIRF 2024) | 40 crore+ scholarships distributed
View All Application Forms

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books