retagged by
1,375 views
0 votes
0 votes
I want to know as we know codd's rule says that no two tuples in a relation should be same. i.e we can not have 2 tuples with same values in clm feilds. now to maintain these constraints, we choose to have some key over the relation which can uniquely identify relation. but we know that in SQL you can have 2 tuples with same values as this is the foundational block of multiset operations which we can perform in SQL. so my ques is SQL does not follow codd rule! right??  by this argument and if it does not follow, so in case of table having mutiset values, (as there are no keys present), how Dbms do indexing to retrive records?

someone help me on this pls.
retagged by

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
2
CKgurav asked Jan 1, 2016
1,223 views
How aggrigate functions in query will behave in data contains NULL values.I think answer should be D as all aggrigatre functions EXCEPT count will ignore NULL values. so,...
0 votes
0 votes
4 answers
3
ShiveshRoy asked Apr 1, 2016
2,096 views
What will COUNT(*) returns if all the collection has only null values???
1 votes
1 votes
1 answer
4
Isha Gupta asked Jun 12, 2016
4,040 views
which operation is used to extract specific columns from a table?