200 views
1 votes
1 votes
Why project treats two NULLs as duplicates? Does that mean if NULL appears in two tuples then only one of them will be displayed in the result since project does not allow duplicates?

1 Answer

0 votes
0 votes
This is true but the decision is arbitrary(its not fixed). But I think some convention needs to be followed (rather than rule) and hence, this convention as I think. Read Korth. Nicely given.

Related questions

0 votes
0 votes
1 answer
2
Ashutosh_17 asked Mar 30, 2023
906 views
Let R be a relation of degree 5 then the total number of projections possible on R is ___?