is a set of meaningful associations among entity types
Anonymous Quiz
13%
attribute
79%
relationship type
8%
entity type
is a group of objects with the same properties, which are identified by the enterprise as having an independent existence
Anonymous Quiz
11%
attribute
7%
relationship type
82%
entity type
property or characteristic of an entity type (often corresponds to a field in a table)
Anonymous Quiz
9%
Entities
85%
Attributes
5%
Relationships
–link between entities (corresponds to primary key-foreign key equivalencies in related tables)
Anonymous Quiz
3%
Entities
5%
Attributes
92%
Relationships
A definable thing—such as a person, object, concept or event—that can have data stored about it.
Anonymous Quiz
86%
Entities
12%
Attributes
2%
Relationships
An entity set that do not have sufficient attributes to form a primary key
Anonymous Quiz
4%
Strong entity
96%
Weak entity
An entity is considered ........ if its tables are existence dependent. That is it can not exist without relationship with another entity.
Anonymous Quiz
18%
Strong entity
82%
Weak entity
A .......... key is composed of two or more attributes, but it must be
minimal
minimal
Anonymous Quiz
7%
Foreign
15%
Candidate
77%
composite
A property or characteristic of an entity. Often shown as an oval or circle.
Anonymous Quiz
10%
Entities
85%
Attributes
6%
Relationships
are those that consist of a hierarchy of attributes Sub-attributes spring from an attribute
Anonymous Quiz
67%
Composite attributes
4%
Simple attributes
14%
DERIVED ATTRIBUTE
10%
Multi-valued Attribute
5%
complex Attribute
More than one attribute value is denoted, such as multiple phone numbers for a person
Anonymous Quiz
8%
Composite Attribute
8%
Complex Attribute
84%
Multi-valued Attribute
Attributed is calculated or otherwise derived from another attribute, such as age from a birthdate
Anonymous Quiz
3%
Composite Attribute
4%
Simple (Scalars) Attribute
93%
Derived Attribute