TheRelationalDataModel.pptVIP

The Relational Data Model Why Relational Model? Most of the current DBMS are based on the relational data model: simplicity mathematically based: expressions (queries) can be analyzed by DBMS transformed to equivalent expressions automatically (query optimization) Basics The relational data model is a particular way of structuring data (relations) Each relation is a two-dimensional table: Attributes, Schemas, and Tuples Domains Requirements Each component of a tuple is atomic (similar to atomic requirement in E/R diagram) Each attribute is associated with a domain Equivalent representation