Question
R intersect S;
Then which of the following is the most restrictive, correct condition on the value of m?
a.
m = min(r,s)
b.
0 <= m <= r + s
c.
min(r,s) <= m <= max(r,s)
d.
0 <= m <= min(r,s)
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Suppose now that R(A,B) and S(A,B) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in...
Similar Questions
Discover Related MCQs
Q. Suppose relation R(A,B,C,D,E) has the following functional dependencies:
A -> B
B -> C
BC -> A
A -> D
E -> A
D -> E
Which of the following is not a key?
View solution
Q. The normal form which satisfies multivalued dependencies and which is in BCNF is
View solution
Q. Which of the following is a tuple-generating dependencies ?
View solution
Q. The main task carried out in the __________ is to remove repeating attributes to separate tables.
View solution
Q. Which of the normal form is based on multivalued dependencies ?
View solution
Q. Which forms has a relation that possesses data about an individual entity?
View solution
Q. If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.
View solution
Q. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?
View solution
Q. In which of the following , a separate schema is created consisting of that attribute and the primary key of the entity set.
View solution
Q. Fifth Normal form is concerned with
View solution
Q. In 2NF
View solution
Q. _____________ can help us detect poor E-R design.
View solution
Q. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
View solution
Q. Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
View solution
Q. What is the best way to represent the attributes in a large database?
View solution
Q. Designers use which of the following to tune performance of systems to support time-critical operations?
View solution
Q. In the schema (dept name, size) we have relations total inst 2007, total inst 2008 . Which dependency have lead to this relation ?
View solution
Q. Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009) .Here the only functional dependencies are from dept name to the other attributes .This relation is in
View solution
Q. Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
View solution
Q. Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
