Solution Manual for Data Modeling and Database Design 2nd Edition by Umanath

Solution Manual for Data Modeling and Database Design 2nd Edition by Umanath

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Data Modeling and Database Design 2-1 Chapter 2 – Conceptual Data Modeling Chapter 2 Objectives After completing this chapter, the student will understand: The fundamental terms (i.e., grammar) associated with the Entity-Relationship Model Entity type Attribute Integrity constraints as technical expressions of business rules Relationship type Structural constraints of a relationship type Base entity type versus weak entity type Cluster entity type Associative entity type Deletion rules/constraints Common errors that occur during the development of data models Chapter 2 Overview This chapter introduces the fundamental constructs and rules for conceptual data modeling using the entity-relationship (ER) modeling grammar as the modeling tool. The basic units of the ER model, that is, entity type, entity class, attribute, unique identifier, and relationship type, are treated in detail. This is followed by exemplified descriptions of weak entity type, cluster entity type and associative entity type. Finally, the role of deletion rules and the specification of deletion constraints are discussed.
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon