Assume A = R and the relation R ⊆ A × A such that for x,...
Assume A = R and the relation R ⊆ A × A such that for x, y, ∈ R,
xRy if and only if sin2 x + cos2 y = 1. Prove that R is an
equivalence relation and for any fixed x ∈ R, find the equivalence
class x
Let A = R x R, and let a relation S be defined as: “(x1, y1)
S (x2, y2) ⬄ points (x1, y1) and (x2, y2)are 5 units
apart.” Determine whether S is reflexive, symmetric, or transitive.
If the answer is “yes,” give a justification (full proof is not
needed); if the answer is “no” you must give a
counterexample.
Consider the equation x^2+(y-2)^2 and the relation “(x, y) R (0,
2)”, where R is read as “has distance 1 of”. For example, “(0, 3) R
(0, 2)”, that is, “(0, 3) has distance 1 of (0, 2)”. This relation
can also be read as “(x, y) belongs to the circle of radius 1 with
center (0, 2)”. In other words: “(x, y) satisfies this equation if,
and only if, (x, y) R (0, 2)”. Does this equation determine a...
6. Let R be a relation on Z x Z such that for all ordered pairs
(a, b),(c, d) ∈ Z x Z, (a, b) R (c, d) ⇔ a ≤ c and b|d . Prove that
R is a partial order relation.
Question 1. Equivalence Relation 1
Define a relation R on by iff .
Prove that R is an equivalence relation, that is, prove
that it is reflexive, symmetric, and transitive.
Determine the equivalence classes of this
relation.
What members are in the class [2]?
How many members do the equivalence classes have? Do
they all have the same number of members?
How many equivalence classes are there?
Question 2. Equivalence Relation 2
Consider the relation from last week defined
as:...
QUERY PROCESSING JOIN
1) Let the schema of a relation r as R(A,B,C), and a relation s
has schema S(C,D,E). Relation table r has 40K tuples, relation s
has 60K tuples. The block factor of r is 25. The block factor of s
is 30. Let the average seek time is t S and average block transfer
time is t T . Assume you have a memory that contains M pages, but
M< 40K/25 (indicating that s cannot be entirely...
Suppose x,y ∈ R and assume that x < y. Show that for all z
∈ (x,y), there exists α ∈ (0,1) so that αx+(1−α)y = z. Now, also
prove that a set X ⊆ R is convex if and only if the set X satisfies
the property that for all x,y ∈ X, with x < y, for all z ∈
(x,y), z ∈ X.
Show that the given relation R is an equivalence relation on set
S. Then describe the equivalence class containing the given element
z in S, and determine the number of distinct equivalence classes of
R.
Let S be the set of all possible strings of 3 or 4 letters, let
z = ABCD and define x R y to mean that x has the same first letter
as y and also the same third letter as y.
Assume a relation X(A,B,C) defined by the following
statement:
CREATE TABLE X (A int, B int, C int);
The relation is currently empty. You have to insert exactly 3
tuples into the relation, without duplicates, to create a data
instance in which the functional dependency A → BC holds and the
functional dependencies B → C and C → B do not hold.
Submit your 3 insert statements