ITE014 MODULE 1.2 (PART 2)

ERD: instance = PHYSICAL DESIGN: column

• True
• False

Answer explanation

ERD: instance = PHYSICAL DESIGN: row

Association among two or more entities

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

STRONG line means

• Optional
• Unique
• Mandatory
• Required

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

• Relationships
• Entities
• Attributes
• Table Diagram

ERD: Secondary UID = PHYSICAL DESIGN: foreign key

• True
• False

Answer explanation

ERD: Secondary UID = PHYSICAL DESIGN: unique key

BROKEN line means

• Mandatory
• Optional
• Required
• Unique

An additional documentation that is often used to further explain keys and columns in the physical database

• Control File
• Relational Model
• Table Diagram
• Entity Relationship Diagram

ERD: entity = PHYSICAL DESIGN: table

• True
• False

It identifies the highest-level relationships between the different entities

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

Pound (#) means

• Mandatory
• Required
• Optional
• Unique