Business Objects are Converted
Entities and Attributes used with ERD
This module discussed how business objects and their characteristics are converted into entities and attributes. This is in preparation for creating an ER diagram.
You also learned that multi-valued attributes violate the single-value rule for relational databases, and then learned two approaches to resolving multi-valued attributes.
Finally, you learned about constraints that can be placed on attributes and entity relationships to help ensure data integrity.
Having completed this module, you should 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
This module introduced you to the following terms:
- BLOB domain type: Short for “binary large object” ; a domain type used to store binary objects such as graphics in a relational database.
- Boolean expression: An expression that results in a value of either TRUE or FALSE. Boolean expressions are also called coparison expressions, conditional expressions, and relational expressions.
- conceptual model: A description of the structure of a database.
- data value: Data entered at the intersection of a row (record) and column (field); the data describes or identifies the subject of the record.
- Data integrity: A term used to describe the quality (in terms of accuracy, consistency, and validity) of data in a database, in the sense that values required to enforce data relationships actually exist. Problems with data integrity occur when a value in one table that’s supposed to relate to a value in another can’t, because the second value either has been deleted or was never entered.
- domain:Determines the type of data values that are permitted for that attribute.
- domain constraints: Rules that require values of attributes to come from specific domains (e.g., text, numbers, date, etc.).
- entity: A single stand-alone unit or a business object about which data are stored in a database; usually synonymous with a database table.
- instance of an entity:The equivalent of a row (record) in a database with values entered for the entity's attributes.
- key attribute: An attribute that identifies an entity; an entity identifier.
- multi-valued attribute: An attribute with more than one data value; must be resolved into a single-valued attribute.
- non-key attribute: An attribute that describes an entity.
- requirements analysis: The stage in the database design cycle when designers find out everything they can about the data the client needs to store in the
database and the conditions under which that data needs to be accessed.
- single-valued attribute: An attribute with more than one data value; must be resolved into a single-valued attribute.
The next module discusses entity relationships.
Entities Attributes - Quiz
Before moving on to the next module, click the Quiz link below to check your understanding of entities and attributes. Entities Attributes - Quiz