DATABASE CHAPTER 4 MIS 380 QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+||BRAND NEW
A candidate key is an attribute, or combination of attributes, that
uniquely identifies a row in a relation. (True/False) Ans✓✓✓True
A cascading delete removes all records in other tables associated with
the record to be deleted. (True/False) Ans✓✓✓True
A constraint between two attributes is called a(n): Ans✓✓✓functional
dependency
A referential integrity constraint is a rule that maintains consistency
among the rows of two relations. Ans✓✓✓True/False
A functional dependency between two or more nonkey attributes is
called a: Ans✓✓✓transitive dependency.
A primary key is an attribute that uniquely identifies each row in a
relation. (True/False) Ans✓✓✓True
A primary key that consists of more than one attribute is called a:
Ans✓✓✓composite key
, A primary key whose value is unique across all relations is called a(n):
Ans✓✓✓enterprise key
A relation is in first normal form if it has no more than one multivalued
attribute. (True/False) Ans✓✓✓false
A relation that contains no multivalued attributes and has nonkey
attributes solely dependent on the primary key but contains transitive
dependencies is in which normal form? Ans✓✓✓second
A rule that states that each foreign key value must match a primary key
value in the other relation is called the: Ans✓✓✓referential integrity
constraint.
A two-dimensional table of data sometimes is called a: Ans✓✓✓relation
All of the following are the main goals of normalization EXCEPT:
Ans✓✓✓minimize data redundancy.
simplify the enforcement of referential integrity.
*maximize storage space.*
make it easier to maintain data.
DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY
GRADED A+||BRAND NEW
A candidate key is an attribute, or combination of attributes, that
uniquely identifies a row in a relation. (True/False) Ans✓✓✓True
A cascading delete removes all records in other tables associated with
the record to be deleted. (True/False) Ans✓✓✓True
A constraint between two attributes is called a(n): Ans✓✓✓functional
dependency
A referential integrity constraint is a rule that maintains consistency
among the rows of two relations. Ans✓✓✓True/False
A functional dependency between two or more nonkey attributes is
called a: Ans✓✓✓transitive dependency.
A primary key is an attribute that uniquely identifies each row in a
relation. (True/False) Ans✓✓✓True
A primary key that consists of more than one attribute is called a:
Ans✓✓✓composite key
, A primary key whose value is unique across all relations is called a(n):
Ans✓✓✓enterprise key
A relation is in first normal form if it has no more than one multivalued
attribute. (True/False) Ans✓✓✓false
A relation that contains no multivalued attributes and has nonkey
attributes solely dependent on the primary key but contains transitive
dependencies is in which normal form? Ans✓✓✓second
A rule that states that each foreign key value must match a primary key
value in the other relation is called the: Ans✓✓✓referential integrity
constraint.
A two-dimensional table of data sometimes is called a: Ans✓✓✓relation
All of the following are the main goals of normalization EXCEPT:
Ans✓✓✓minimize data redundancy.
simplify the enforcement of referential integrity.
*maximize storage space.*
make it easier to maintain data.
