1Database models & DBMS

• 1.1The role and architecture of a DBMS

  Covers the five roles a database management system (DBMS) plays in an integrated way—data definition, data manipulation, concurrency control, failure recovery, and data independence—and the judgment skill of determining, when a failure occurs, what the DBMS does and does not guarantee.

• 1.2The three-level schema and data independence

  Covers the structure of the three-level schema—the external schema, conceptual schema, and internal schema—and logical data independence and physical data independence, whereby a change at one level does not propagate to another, along with the judgment skill of determining which level a given schema change will affect.

• 1.3Fundamentals of the relational model

  Covers the core concepts of the relational model—relation, tuple, attribute, domain, degree, and cardinality—and their correspondence to tables, the distinctions among candidate key, primary key, and foreign key, and the judgment skill of choosing keys appropriately in table design.

• 1.4The diversity of data models and NoSQL

  Covers the traditional data models—hierarchical, network, the relational model, and the object-oriented model—and the characteristics of each NoSQL style—key-value store (KVS), document-oriented, column-oriented, and graph database—along with the judgment skill of choosing the optimal data model for a given requirement.