Data Models Flashcards
Data modeling
The process of creating a specific data model for a determined problem domain.
Data model
A representation, usually graphic, of a complex “real-world” data structure
Data models are used in the database design phase of database life cycle.
The importance of data models
Data models can facilitate interaction among the designer, the applications progammer, and the end user.
entity
A person, place, thing, concept, or event for which data can be stored.
attribute
A characteristic of an entity or object.
an attribute has a name and a data type.
relationship
An association between entities.
One-to-many(1:M) relationship
Associations among two or more entites that are used by data
In a 1:M relationship, one entity instance is associated with many instances of the related entity
many-to-many relationship(M:N)
Association among two or more entities in which one occurrence of an entity is associated with many occurrences of a related entity is associated with many occurences of the first entity
one-to-one(1:1) relationship
In a 1:1 relationship, one entity instance is associated with only one instance of the related entity