正在加载图片...
Joining two relations -Natural Join Let r and s be relations on schemas R and S respectively. Then,the"natural join"of relations R and S is a relation on schema RS obtained as follows: Consider each pair of tuplesfr from r and fs from s. If f,and fs have the same value on each of the attributes in RS,add a tuple t to the result,where t has the same value as fr on r t has the same value as fs on s Database System Concepts-6th Edition 2.18 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 2.18 ©Silberschatz, Korth and Sudarshan th Edition Joining two relations – Natural Join Let r and s be relations on schemas R and S respectively. Then, the “natural join” of relations R and S is a relation on schema R  S obtained as follows: Consider each pair of tuples t r from r and ts from s. If t r and ts have the same value on each of the attributes in R  S, add a tuple t to the result, where  t has the same value as t r on r  t has the same value as ts on s
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有