Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
What is an entity?
|
An entity is an existing physical or conceptual object that can be distinguished from other objects
|
|
What is an entity type?
|
An entity type is an abstract description of the common characteristics of similar entities
|
|
What is an entity set?
|
An entity set is the set of the entities, which conform to the definition of an entity type and therefore could be considered as instances of this type
|
|
What is a relationship?
|
A relationship is an association among two or more entities
|
|
What is a relationship type?
|
A relationship type is an abstract description of similar relationships among entities of the same entity types
|
|
What is a relationship set?
|
A relationship set is the set of the relationships, which conform to the definition of relationship type and therefore could be considered as instances of this type
|
|
What is an attribute?
|
An attribute is a characteristic (property) of an entity or a relationship
|
|
What types of values can attributes take?
|
Attributes may take one or more primitive or composite values
|
|
What is a key (or superkey)?
|
A key (or superkey) is a minimal set of one or more attributes, which collectively identify the individual entities and relationships in the extensions of entity and relationship types
|
|
What is a candidate key?
|
A candidate key is a distinct collection of attributes that may serve as a key
|
|
What is a primary key?
|
A primary key is a candidate key chosen by a database designer to be the key for an entity or relationship type
|