-Person, place, object, event, concept, etc. (Noun)
-Entity type vs. entity instance (Table vs. Row)
type:
A collection of entities that share common properties or characteristics.
should be:
-An object that will have many instances in the database
-An object that will be composed of multiple attributes
-An object that we are trying to model
Should not be:
-A user of the database system
-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.