-Person, place, object, event, concept, etc. (Noun) Show
-Entity type vs. entity instance (Table vs. Row) type: should be: -An object that will be composed of multiple attributes -An object that we are trying to model Should not be: -An output of the database system (e.g., a report) What term describes the characteristics of an entity?Attribute. A characteristic or trait of an entity type that describes the entity, for example, the Person entity type has the Date of Birth attribute.
What is the term for a collection of entities that share common characteristics?Entity Type. A collection of entities that share common properties or characteristics. Entity-Relationship Model. Detailed, logical representation of the data for an organization or for a business area. Entity Instance.
What is a term used to describe the relationship between two entities?A unary relationship, also called recursive, is one in which a relationship exists between occurrences of the same entity set. In this relationship, the primary and foreign keys are the same, but they represent two entities with different roles.
What is a property or characteristic of an entity or relationship type that is of interest to the Organisation?Attribute: A named property or characteristic of an entity type that is of interest to the organization.
|