Computer Fundamentals

12

FUNDAMENTALS OF DATABASE

Contents

• Database
  • File-oriented approach and database approach
  • Characteristics of database approach
  • Data models, schemas and instances
  • Conceptual data model—Entity, attribute, relationship, and E-R model
  • Representation data model—Hierarchical, network, relational data model
  • Low level, or physical data model
• Database system
  • Components of database system— Users, software, hardware, and data
  • Architecture of database system—Internal level, conceptual level, and external level
• Database management system
  • Data independence—Logical data independence, physical data independence
  • Data dictionary, Database Administrator (DBA)
  • Database languages—DDL, and DML
• Database system architectures—Centralized DBMS architecture, ...