Chapter 2 Database Environment Transparencies by Conolly-Carolyn E. Begg, Thomas Connolly
 

Chapter 2 Database Environment Transparencies Book Database systems by Conolly-Carolyn E. Begg, Thomas Connolly

• Purpose of three-level database architecture.
• Contents of external, conceptual, and internal levels.
• Purpose of external/conceptual and conceptual/internal mappings.
• Meaning of logical and physical data independence.
• Distinction between DDL and DML.
• A classification of data models.
• Purpose/importance of conceptual modeling.
• Typical functions and services a DBMS should provide.
• Function and importance of system catalog.
• Software components of a DBMS.
• Meaning of client–server architecture and advantages of this type of architecture for a DBMS.
• Function and uses of Transaction Processing Monitors.