Databases in Theory and PracticeDatabases: In Theory and Practice adopts a pragmatic, technical approach to the subject of database systems. In this book the authors set about dealing with the underlying theory of databases in an accessible, non-mathematical manner. Covering all aspects of the subject, the book introduces the concepts from a problem-solving point of view with numerous practical examples and problems. |
Common terms and phrases
ACCNO account number account type ACCTYPE allow application program approach attributes BALANCE branch code candidate key Chapter CHAR COBOL CODASYL conceptual model created CUSTINV CUSTNO CUSTNUM customer name customer number data analysis data items database design database management systems database systems DBMS defined definition deleted design stage disc dump efficiency entity error example existing functional analysis functionally dependent hashing function identifier implemented inheritance Insurance company investment account investment record journal file language load program logical data model logical model m:n relationships mapping member records Note occur OODB OODBMS operating system owner PL/SQL pointers possible problems query relational databases reload repeating group restructure result rollback schema second normal form Section SELECT sequential shown in Figure single storage stored submodel subschema SURNAME third normal form TRANS transactions tuple unique update