Database System ConceptsThis popular text in database systems is used in departments of computer science, computer engineering, and electrical engineering. The revision includes more material on SQL, relational models, logical databases, "QB" and "Datalog." |
From inside the book
Results 1-3 of 96
Page 64
... name = " Johnson " ( client x customer ) ) we get only those tuples of client × customer that • Pertain to Johnson . • Have the street and city of the customer of Johnson . client . customer . customer - name banker - name 64 Relational ...
... name = " Johnson " ( client x customer ) ) we get only those tuples of client × customer that • Pertain to Johnson . • Have the street and city of the customer of Johnson . client . customer . customer - name banker - name 64 Relational ...
Page 77
... [ customer - name ] = s [ customer - name ] A s [ branch - name ] = " Perryridge " ^ ue customer ( u [ customer - name ] = s [ customer - name ] ^ t [ customer - city ] = u [ customer - city ] ) ) } In English , this is " the set of all ...
... [ customer - name ] = s [ customer - name ] A s [ branch - name ] = " Perryridge " ^ ue customer ( u [ customer - name ] = s [ customer - name ] ^ t [ customer - city ] = u [ customer - city ] ) ) } In English , this is " the set of all ...
Page 109
Henry F. Korth, Abraham Silberschatz. select customer - name from customer where exists ( select * from deposit where deposit.customer - name = customer.customer - name and branch - name = " Perryridge " ) and not exists ( select * from ...
Henry F. Korth, Abraham Silberschatz. select customer - name from customer where exists ( select * from deposit where deposit.customer - name = customer.customer - name and branch - name = " Perryridge " ) and not exists ( select * from ...
Contents
Introduction | 1 |
EntityRelationship Model | 23 |
Relational Model | 53 |
Copyright | |
40 other sections not shown
Common terms and phrases
algorithm allows amount appear application attributes authorization balance bank block borrow branch branch-name bucket called Chapter commit compute concept concurrency consider consists constraints contains corresponding create customer-name data item database system deadlock decomposition defined definition delete dependencies deposit described diagram discussed disk distributed domain employees ensure entity set example execution exists expression failure Figure functional dependencies graph hash holds illustrate implementation insert Johnson join language loan lock manager modification node Note object operation performance Perryridge physical pointer possible presented processing protocol query record record type recovery references relation relational algebra relationship represent request require result rule schedule scheme serializability shows specify storage stored strategy structure Suppose T₁ techniques transaction tree tuples update variable write