MIS 3140 FINAL EXAM STUDY GUIDE
primary key (PK) - Answers - In the relational model, an identifier composed of one or
more attributes that uniquely identifies a row. Also, a candidate key selected as a
unique entity identifier
key - Answers - In the relational model, an identifier composed of one or more attributes
that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier
New Logical View of Data - Answers - The relational data model changed all of that by
allowing the designer to focus on the logical representation of the data and its
relationships, rather than on the physical storage details.
Determination (key) - Answers - the state in which knowing the value of one attribute
makes it possible to determine the value of another
Composite Key - Answers - Key that is composed of more than one attribute
Super Key - Answers - a key that can uniquely identify any row in the table. In other
words, this key functionally determines every attribute in the row.
Candidate Key - Answers - 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
Entity Integrity - Answers - the condition in which each row (entity instance) in a table
has its own unique identity
foreign key (FK) - Answers - the primary key of one table that has been placed into
another table to create a common attribute. Used to ensure referential integrity
Referential Integrity - Answers - A condition by which a dependent table's foreign key
must have either a null entry or a matching entry in the related table
UNION (RSO) - Answers - an operator used to merge (append) two tables into a new
table, dropping the duplicate rows
Intersect (RSO) - Answers - an operator used to yield only the rows that are common to
two union-compatible tables
Select (RSO) - Answers - an operator used to select a subset of rows. Also known as
RESTRICT
Project (RSO) - Answers - an operator used to select a subset of columns
primary key (PK) - Answers - In the relational model, an identifier composed of one or
more attributes that uniquely identifies a row. Also, a candidate key selected as a
unique entity identifier
key - Answers - In the relational model, an identifier composed of one or more attributes
that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier
New Logical View of Data - Answers - The relational data model changed all of that by
allowing the designer to focus on the logical representation of the data and its
relationships, rather than on the physical storage details.
Determination (key) - Answers - the state in which knowing the value of one attribute
makes it possible to determine the value of another
Composite Key - Answers - Key that is composed of more than one attribute
Super Key - Answers - a key that can uniquely identify any row in the table. In other
words, this key functionally determines every attribute in the row.
Candidate Key - Answers - 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
Entity Integrity - Answers - the condition in which each row (entity instance) in a table
has its own unique identity
foreign key (FK) - Answers - the primary key of one table that has been placed into
another table to create a common attribute. Used to ensure referential integrity
Referential Integrity - Answers - A condition by which a dependent table's foreign key
must have either a null entry or a matching entry in the related table
UNION (RSO) - Answers - an operator used to merge (append) two tables into a new
table, dropping the duplicate rows
Intersect (RSO) - Answers - an operator used to yield only the rows that are common to
two union-compatible tables
Select (RSO) - Answers - an operator used to select a subset of rows. Also known as
RESTRICT
Project (RSO) - Answers - an operator used to select a subset of columns
