Question:
Consider a database that includes the following relations :
Defender(name, rating, side, goals)
Forward(name, rating, assists, goals)
Team(name, club, price)
Which ONE of the following relational algebra expressions checks that every name occurring in Team appears in either Defender or Forward, where Φ denotes the empty set ?
Consider a database that includes the following relations :
Defender(name, rating, side, goals)
Forward(name, rating, assists, goals)
Team(name, club, price)
Which ONE of the following relational algebra expressions checks that every name occurring in Team appears in either Defender or Forward, where Φ denotes the empty set ?
Defender(name, rating, side, goals)
Forward(name, rating, assists, goals)
Team(name, club, price)
Which ONE of the following relational algebra expressions checks that every name occurring in Team appears in either Defender or Forward, where Φ denotes the empty set ?
Updated On: Jul 9, 2024
- Пname (Team) \ (Пname (Defender) ∩ Пname (Forward)) = Φ
- (Пname (Defender) ∩ (Пname (Forward) \ Пname (Team) = Φ
- Пname (Team) \ (Пname (Defender) ∪ Пname (Forward)) = Φ
- (Пname (Defender) ∪ (Пname (Forward) \ Пname (Team)) = Φ
Hide Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
The correct option is (C) : Пname (Team) \ (Пname (Defender) ∪ Пname (Forward)) = Φ.
Was this answer helpful?
0
0
Questions Asked in GATE AR exam
- Which of the following methods is/are used in traffic survey to measure the Running Speed and Journey Speed?
- GATE AR - 2024
- Traffic survey methods, Traffic flow Analysis
- For the beam shown below, ignoring the self-weight, the maximum hogging moment (in kN·m) generated for the loads indicated is _______ (rounded off to one decimal place).
- GATE AR - 2024
- High Rise and Long Span structures, gravity and lateral load resisting systems
- Let f: R→ R be a function. Note: R denotes the set of real numbers.
\(f(x) = \left\{ \begin{array}{ll} -x, & \text{if } x < -2 \\ ax^2+bx+c, & \text{if }\ x \in[-2,2]\\ x, & \text{if } x>2 \end{array} \right.\)
Which ONE of the following choices gives the values of a, b, c that make the function f continuous and differentiable ?- GATE AR - 2024
- Differential Equations
- Consider the dataset with six datapoints : {(x1, y1), (x2, y2), ..., (x6, y6)}, where x1 = \(\begin{bmatrix} 1 \\ 0 \end{bmatrix}\), x2 = \(\begin{bmatrix} 0 \\ 1 \end{bmatrix}\), x3 = \(\begin{bmatrix} 0 \\ -1 \end{bmatrix}\), x4 = \(\begin{bmatrix} -1 \\ 0 \end{bmatrix}\), x5 = \(\begin{bmatrix} 2\\ 2 \end{bmatrix}\), x6 = \(\begin{bmatrix} -2 \\ -2 \end{bmatrix}\) and the labels are given by y1 = y2 = y5 = 1, and y3 = y4 = y6 = -1 .A hard margin linear support vector machine is trained on the above dataset. Which ONE of the following sets is a possible set of support vectors?
- GATE AR - 2024
- Database Concepts
- A ramp with a slope of 1 : 12 is required for wheelchair access. Intermediate landings of length 1.5 m each have to be provided after every 9 m running length. The running length of a straight ramp including landing, to negotiate a level difference of 900 mm vertical height, in m, is ( rounded off to two decimal places).
- GATE AR - 2024
- Urban renewal and conservation
View More Questions