Select all binary relation properties that apply to the following relation: Equal magnitude: |x| = |y] O antisymmetric O reflexive O symmetric O transitive

Given the relation T below, use ordered pair notation to express the relation To T. ToT { Ex: (a, b), (b, c) b Lo a с } T

3) A relation is said to be in 3NF if it is in 2NF and no nonprime attribute of R is blank the primary key. A) an alternate forB) transitively dependent on C) Part of D) partially functionally dependent onE) fully funcionally dependent on

Fill in the matrix representation for the relation depicted in the arrow diagram. 1 2 1 2 3 1 Pick Pick Pick 2 Pick Pick Pick 3 Pick Pick Pick

2) A relation schema R is defined tot be in 2NF if every nonprime attribute of R is blank the primary key of R.A) transitively dependent on B) fully functionally dependent onC) a candidate key of D) partially functionally dependent onE) part of

Select the following relations on Z that are reflexive. {(a, b) | ab >0} {(a, b) | a>b-1} {(a,b) a² > b} 2 {(a,b) | a² = b² (mod 7)}

Let R₁ and R₂ be the relations on X={a,b,c}, R₁={ (b,a), (c,b), (a,c) } R₂={ (a,c), (b,c)} R₁-¹= R₂ ° R₁=

Determine which of these relations are reflexive. The variables x,y,x',y' represent integers. A. x~y if and only if x+y is even B. x~y if and only if x+y is odd C. x~y if and only if x+y is positive D. x~y if and only if xy is positive E. x~y if and only if x-y is a multiple of 10

answer the following boxes

1) Consider the following relation instance of R1(A, B, C) contains the tuples {(a1,b1.c1). (a2,b1,c1), (a3,b3,c3), (a4,b3,c3), (a5,b5.c5). (a6,b6,c6)} and S1(B, C, D, E) contains the tuples ((b1.c1,d1,e1), (b1.c1.d2.e2),.(b1.c1,d3,e3), (b2.c2,d2.e2), (b3,c3,d4,e4).(b6.c7.d8,e9)) The following SQL query will result in how many tuples? Select From R1 r LEFT OUTER JOIN S1 s (ON r.B= s.B AND r.C=s.C): (The answer will simply be an integer, like 25). Answer: 2) Consider a relation schema R = (A, B, C, D, E, F, G} with the following set of functional dependencies: F = (BG A, CGA, A BC, BC A, BD E, EF, CF B) The decomposition of R into R1 = (A, B, C, G), R2 = {B, D, E), R3 = (B, C, F) and R4 = (E, F) is O In BCNF but Not in 3NF. In 3NF but Not in BCNF. In 3NF and in BCNF. Not in 3NF and Not in BCNF 3)