ER Diagram Flashcards
What shapes represent entities in an ER Diagram?
Rectangles
What shapes represent attributes (field names) in an ER Diagram?
Ovals/Circles
What shapes represent relationships in an ER Diagram?
Diamond
What represents real-world objects or concepts in an ER diagram?
Entity
What are the properties or characteristics of entities called?
Attributes
What depicts how entities interact or relate to each other within a database?
Relationships.
What describes the numerical relationship between entities in a relationship?
Cardinality
What are attributes that uniquely identify each instance of an entity?
Identifying keys
What is the process of organizing a relational database to minimize redundancy and dependency?
Normalization