EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources] نسخه متنی

Chapter 2. Creating a Logical Data Model

Terms you'll need to understand:

Entity Relationship Model

Entity

Kernel entity

Associative entity

Characteristic entity

Attribute

Identifier

Dependency

Primary key

Foreign key

Normalization

Denormalization

Normal forms

Relationship

Cardinality

Techniques you'll need to master:

Entity Relationship Modeling

Database normalization/denormalization

Key and relationship definition