Register

Tuples

• edited by
273 views
2 votes
2 votes
Consider a relation R(A,B,C) with the following functional dependency AC→B .A can take 200 distinct values, B can take 100 distinct values and C can take 1000 distinct values. What is the maximum and minimum possible tuples of the self join of R on C?
• edited by
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

3 votes
3 votes
2 answers
1
iarnav asked Dec 6, 2017
1,315 views
#DBMS What will be the Minimum Number of Tuples?
Say we have two relations R (a,b,c) and S (b,d,e). Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Join)?
Say we have two relations R (a,b,c) and S (b,d,e).Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Joi...
User Avatar
0 votes
0 votes
1 answer
2
Ramayya asked Jan 7
198 views
ISRO 2024
In SQL the statement $\text{select * from R, S}$ is equivalent to $\text{select * from R natural join S}$ $\text{select * from R cross join S}$ $\text{select * from R outer join S}$ $\text{select * from R inner join S}$
In SQL the statement $\text{select * from R, S}$ is equivalent to$\text{select * from R natural join S}$$\text{select * from R cross join S}$$\text{select * from R outer ...
User Avatar
1 votes
1 votes
1 answer
4
tusharb asked Mar 27, 2022
693 views
Self Doubt
I want to join the two tables of movies and actors and then output only those results that have gender =”F”, can you tell me where I am going wrong?
I want to join the two tables of movies and actors and then output only those results that have gender =”F”, can you tell me where I am going wrong?
User Avatar
Link Copied!