MyQuestionIcon

1

You visited us 1 times! Enjoying our articles? Unlock Full Access!

Letters for Digits

Consider the ...

Question

Consider the following relations where keys are underlined:
P(X, Y, Z) and Q (A, X)
P contain 500 records and Q contain 1500 records. X in Q is a NON-NULL attribute and a foreign key referencing to P. If a is the maximum number of records in
$P ⋈ Q and b is the minimum number of records in$
$P ⋈ Q$ .
What is the value of 2a-b________
(Where $⋈$ is a natural join)
1500

Open in App

Solution

The correct option is A 1500
$'X' in P is a key so it contain all different value and 'X' in Q is not key and referencing to P so all its record will match to 'X' in P. So there is total 1500 minimum record and also 1500 maximum records. a = 1500, b = 1500 2 a - b = 2 \times 1500 - 1500 = 1500$

Suggest Corrections

thumbs-up

0

Similar questions

Q. Consider the relation R(A, B) in which (AB) is the primary key and the relations S(A, C) where A is the primary key. Assume there are no null values and no foreign keys or integrity constraints.

Q_{1} : Select A from R where A in (Select A from S)

Q_{2} : Select A from S where A in (Select A from R)

Which of the following option is correct related to the above queries?

Q. Consider the following statements:
I. In a relation R, if some set of attributes X is such that closure set of X contains all the attributes of R i.e. X determines every attribute of R then X is a candidate key of R.

II. It is possible for a relation to have no non-trivial functional dependencies.

III. If set of all attributes combined from a candidate key for some relation R then R does not contain any non-trivial FD.

IV. In a relation R, If X is some set of attributes and Y is some prime attribute such that X determines Y is a non-trivial FD. Then R has at least two candidate keys.

Which of the above statements is/are false?

Q. Consider x as number of primer attribute and y as number of non-prime attribute of relation R(m, n, o, p, q, r, s, t), from given functional dependencies:

F = (q \to r s t, m n \to p q r s t, o \to p q, p \to m)

The value of x × y is _______

Q. Consider the following entity relationship diagram (ERD), where two entities E1 and E2 have a relation R of cardinality 1 : m

The attributes of E1 and A11, A12 and A13 where A11 is the key attribute. The attributes of E2 are A21, A22 and A23 where A21 is the key attribute and A23 is a multi-valued attribute.
Relation R does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is

B^{+}

tree in which search key 20 bytes long, block size is 1500 bytes, record pointer is 10 bytes long and block pointer is 8 bytes long. The maximum number of keys that can be accommodated in each leaf node of the tree is _______

View More

Join BYJU'S Learning Program

similar_icon

Related Videos

lock

Puzzles with Digits

MATHEMATICS

Watch in App

explore_more_icon

Explore more

Letters for Digits

Standard VIII Mathematics

Join BYJU'S Learning Program

CrossIcon