Management Information Systems (MIS) 3140 Final
Assessment Rated A+
1:1 Relationship - ANSWER-one entity in a 1:1 relationship can be related to only one
other entity, and vice versa. Rare in any relational database
1:M relationship - ANSWER-the norm for relational databases, one to many. Read more
info in book
Candidate Key - ANSWER-A minimal superkey; that is, a key that does not contain a
subset of attributes that is itself a superkey. Based on a full functional dependency
Cardinality - ANSWER-expresses the minimum and maximum number of entity
occurrences associated with one occurrence of the related entity. indicated by placing
the appropriate numbers beside the entities, using the format (x,y)
Comp - ANSWER-An attribute that can be further subdivided to yield additional
attributes. For example, a phone number such as 615-898-2368 may be divided into an
area code (615)
Completeness constraint - ANSWER-A constraint that specifies whether each entity
supertype occurrence must also be a member of at least one subtype. The
completeness constraint can be partial or total
composite attribute - ANSWER-An attribute that can be further subdivided to yield
additional attributes. For example, a phone number such as 615-898-2368 may be
divided into an area code (615)
Composite Key - ANSWER-Key that is composed of more than one attribute
Connectivity - ANSWER-used to describe the relationship classification
Data Dictionary - ANSWER-contains at least all of the attribute names and
characteristics for each table in the system. In short, it contains metadata—data about
data. Provides a detailed description of all tables in the database created by the user
and designer.
data redundancy - ANSWER-The duplication of data, or the storage of the same data in
multiple places. Leads to data anomalies, which can destroy the effectiveness of the
database
Derived attribute - ANSWER-an attribute whose value is calculated (derived) from other
attributes. The derived attribute need not be physically stored within the database;
Assessment Rated A+
1:1 Relationship - ANSWER-one entity in a 1:1 relationship can be related to only one
other entity, and vice versa. Rare in any relational database
1:M relationship - ANSWER-the norm for relational databases, one to many. Read more
info in book
Candidate Key - ANSWER-A minimal superkey; that is, a key that does not contain a
subset of attributes that is itself a superkey. Based on a full functional dependency
Cardinality - ANSWER-expresses the minimum and maximum number of entity
occurrences associated with one occurrence of the related entity. indicated by placing
the appropriate numbers beside the entities, using the format (x,y)
Comp - ANSWER-An attribute that can be further subdivided to yield additional
attributes. For example, a phone number such as 615-898-2368 may be divided into an
area code (615)
Completeness constraint - ANSWER-A constraint that specifies whether each entity
supertype occurrence must also be a member of at least one subtype. The
completeness constraint can be partial or total
composite attribute - ANSWER-An attribute that can be further subdivided to yield
additional attributes. For example, a phone number such as 615-898-2368 may be
divided into an area code (615)
Composite Key - ANSWER-Key that is composed of more than one attribute
Connectivity - ANSWER-used to describe the relationship classification
Data Dictionary - ANSWER-contains at least all of the attribute names and
characteristics for each table in the system. In short, it contains metadata—data about
data. Provides a detailed description of all tables in the database created by the user
and designer.
data redundancy - ANSWER-The duplication of data, or the storage of the same data in
multiple places. Leads to data anomalies, which can destroy the effectiveness of the
database
Derived attribute - ANSWER-an attribute whose value is calculated (derived) from other
attributes. The derived attribute need not be physically stored within the database;
