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 83
Page 184
... scheme does . Therefore , we have one tuple for each customer for a loan only in the relation on Customer - loan - scheme . In the other relations involving loan- number ( those on schemes Loan - info - scheme and Customer - loan - scheme ) ...
... scheme does . Therefore , we have one tuple for each customer for a loan only in the relation on Customer - loan - scheme . In the other relations involving loan- number ( those on schemes Loan - info - scheme and Customer - loan - scheme ) ...
Page 185
Henry F. Korth, Abraham Silberschatz. The scheme , Borrow - scheme , however , is not in BCNF . First , note that loan - number is not a superkey for Borrow - scheme since we could have a pair of tuples representing a single loan made to ...
Henry F. Korth, Abraham Silberschatz. The scheme , Borrow - scheme , however , is not in BCNF . First , note that loan - number is not a superkey for Borrow - scheme since we could have a pair of tuples representing a single loan made to ...
Page 187
... scheme is not in BCNF . We replace Lending - scheme by Branch - scheme = ( branch - name , branch - city , assets ) Deposit - scheme = ( branch - name , loan - number , customer - name , amount ) • The only nontrivial functional ...
... scheme is not in BCNF . We replace Lending - scheme by Branch - scheme = ( branch - name , branch - city , assets ) Deposit - scheme = ( branch - name , loan - number , customer - name , amount ) • The only nontrivial functional ...
Contents
Introduction | 1 |
EntityRelationship Model | 23 |
Chapter 3 Relational Model | 53 |
Copyright | |
40 other sections not shown
Common terms and phrases
abort account-number algorithm allows attributes B-tree balance bank BCNF block borrow branch-city branch-name bucket buffer candidate key cascading rollback Chapter commit compute concurrency control conflict serializable consider constraints contains coordinator corresponding CustAcct customer-city customer-name data item data model database system DBTG deadlock decomposition defined delete discussed disk domain domain relational calculus Downtown E-R diagram employees ensure entity set example execution expression functional dependencies hash function insert Johnson join loan loan-number locking protocol log records main memory manager Mianus multivalued dependencies node object-oriented Perryridge branch pointer primary key query language r₁ R₂ read(A record type recovery relation scheme relational algebra relational database relationship set require result rule schedule search-key value Section serializability set occurrence stable storage Stonebraker stored strategy structure superkey T₁ T₂ techniques timestamp transaction tree-structure diagram tuple relational calculus update wait-for graph weak entity write write(Q