正在加载图片...
Example Queries Find the names of all customers having a loan at the Perryridge branch (t|3s e borrower(t [customer_name ]=s [customer_name A3u∈loan(u[branch_name]=“Perryridge” ^u [loan_number ]=s [loan_number ])) Find the names of all customers who have a loan at the Perryridge branch,but no account at any branch of the bank {t3s e borrower (t [customer_name ]=s [customer_name A3u∈loan(u[branch_name]=“Perryridge” ^u [loan_number ]=s [loan_number ]) not 3ve depositor(v[customer_name ] t [customer_name ]) Database System Concepts-5th Edition,July 8,2005 5.8 @Silberschatz,Korth and SudarshanDatabase System Concepts - 5 5.8 ©Silberschatz, Korth and Sudarshan th Edition, July 8, 2005 Example Queries Find the names of all customers having a loan at the Perryridge branch {t | s  borrower (t [customer_name ] = s [customer_name ]  u  loan (u [branch_name ] = “Perryridge”  u [loan_number ] = s [loan_number ]))  not v  depositor (v [customer_name ] = t [customer_name ])} Find the names of all customers who have a loan at the Perryridge branch, but no account at any branch of the bank {t | s  borrower (t [customer_name ] = s [customer_name ]  u  loan (u [branch_name ] = “Perryridge”  u [loan_number ] = s [loan_number ]))}
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有