ITE014 MODULE 1.2 (PART 2)

It identifies the highest-level relationships between the different entities

• Entity Relationship Diagram
• Relationships
• Entity Relationship Model
• Conceptual Modeling

Real-world object or thing that has an independent existence and that is distinguishable from other objects

• Relationships
• Entities
• Attributes
• Table Diagram

Characteristics of entities or relationships that provide descriptive details about them

• Attributes
• Relationships
• UID
• Entities

Association among two or more entities

• Entity Relationship Model
• Attributes
• Relationships
• Entity Relationship Model

A graphical representation of entities and their relationships to each other, and it is used to organize data within databases or information systems

• Table Diagram
• Entity Relationship Diagram
• Conceptual Modeling
• Entity Relationship Model

A list of all entities and attributes as well as all relationships between the entities that are of importance

• Table Diagram
• Entity Relationship Diagram
• Conceptual Modeling
• Entity Relationship Model

ERD: entity = PHYSICAL DESIGN: table

• True
• False

ERD: instance = PHYSICAL DESIGN: column

• True
• False

Answer explanation

ERD: instance = PHYSICAL DESIGN: row

ERD: attribute = PHYSICAL DESIGN: column

• True
• False

ERD: primary UID = PHYSICAL DESIGN: primary key

• True
• False