Lesson 1
Entities and attributes
Database designers begin the logical design stage by converting business objects and their characteristics into entities and attributes. They
plug both entities and attributes into an ER diagram as the first step in designing a conceptual model.
Keep in mind that a conceptual model does not contain any data; rather, it illustrates the structures of a database, the architecture of the data container. Think of building a house: you build the house before you place any furniture inside. But dont carry this analogy too far: when you design a database, you build a house to fit the furniture you already have rather than buying furniture to fit the house.
Learning objectives
Keep in mind that a conceptual model does not contain any data; rather, it illustrates the structures of a database, the architecture of the data container. Think of building a house: you build the house before you place any furniture inside. But dont carry this analogy too far: when you design a database, you build a house to fit the furniture you already have rather than buying furniture to fit the house.
After completing this module, you will be able to:
- Define entities and entity attributes
- Explain the purpose of entity identifiers
- List rules for creating entity identifiers
- Describe instances of entities
- Describe attribute domains and domain types
- Explain the problem with multi-valued attributes
- Describe how to resolve multi-valued attributes by adding more attributes
- Describe how to resolve multi-valued attributes by creating a new entity
- List entity and attribute constraints