1.

Consider the instance of the CUSTOMER and BRANCH relations shown in the following table. Write the Cartesian Product of the two relations.  CUSTOMERAcc_NoAcc_NoBranchJDAmountAC123AlbinB100150000AC103RasheedaB100125000AC106VishnuB100125000               BRANCHBranchJDNameB1001KochiB1002GuruvayurB10TTIduki

Answer»
                              CUSTOMER X BRANCH
Acc NoNameBranch IDAmount Branch IDName
AC123 AlbinAlbinB100150000B1001Kochi
AC 123AlbinB100150000B1002Guruvayur
AC123AlbinB100150000B1077Idukki
AC103RasheedaB100125000B1001Kochi
AC103RasheedaB100125000B1002Guruvayur
AC103RasheedaB100125000B1077Idukki
AC106VishnuB100125000B1001Kochi
AC106VishnuB100125000B1002Guruvayur
AC106VishnuB100125000B1077Idukki
AC108AiswaryaB107730000B1001Kochi
AC108AiswaryaB107730000B1002Guruvayur
AC108AiswaryaB107730000B1077Idukki


Discussion

No Comment Found