CS338 Lecture Notes - Lecture 1: Superkey, Relational Model, Database

• School: University of Waterloo
• Department: Computer Science
• Course: CS338
• Professor: Michael Liu

Document Summary

Know the basic definitions: mini-world, dbms, database, ddl, dml. Metadata = database definition or descriptive information. Program-data independence = database definition or descriptive information. Program-operation independence = independence of function calls relative to their implementation: data abstraction allows the above two. Conceptual representation of data = no details of how data is stored or implementation of operations: e. g. A data model may be used as a conceptual representation. View = subset of data that is derived from data of the db but is not explicitly stored. Transactions = isolated (one at a time) and atomic (all or nothing) Types of database users (e. g. professional, end) and their responsibilities. Categories of data models (conceptual, representational, physical) : concepts of each model. Database state = the actual data in a database at a particular moment in time. Dbms architecture: centralized dbms architecture, dbms client/server architecture, three-tier & n-tier architectures.