OMIS 452 Exam 1 Questions with Correct Answers (Grade A+)
Question 1: Entity
Answer: Row, Record, or Instance
Question 2: Attribute
Answer: Column, Characteristic
Question 3: Relation
Answer: All 8 characteristics are met in a table in order to be a relation
Question 4: Functional Dependency
Answer: When one or more attributes determines the value of another attribute
Question 5: Determinant
Answer: NumberofBoxes determines CookieCost, NumberofBoxes is the determinant
Question 6: Candidate Key
Answer: is a determinant that determines all of the other columns in a relation. Identify a unique row in a
relation
Question 7: Primary Key
Answer: the chosen candidate key to be defined to the DBMS. (can be composite)
Question 8: Composite Key
Answer: when one or more columns are used to determine a particular row in a relationship
Question 9: Surrogate Key
Answer: is an artificial column that is added to serve as the primary key
Question 10: Foreign Key
Page 1
, Answer: is a column or composite of columns that is the primary key of a table that appears as an attribute
in another.
Question 11: Referential Integrity Constraint
Answer: a statement that limits the values of the foreign key by using constraints
Question 12: Entity Integrity Constraint
Answer: a fundamental requirement for the proper functioning of a relational database
Question 13: 8 Characteristics of Relations
Answer: Rows contain data about an entity Columns contain data about attributes of the entity All entries in
a column are of the same kind Each column has a unique name Cells of the table hold a single value Order
of the columns and rows are unimportant No two rows may be identical (keys)
Question 14: 1NF
Answer: when the set of conditions for a relation are met then it is said to be in 1NF
Question 15: 2NF
Answer: when the set of conditions for a relation are met, all non key attributes are determined by entire
primary key
Question 16: 3NF
Answer: when the set of conditions for a relation are met, all non key attributes are determined by entire
primary key, and there are no non-key attributes determined by another non-key attribute (Transitive
dependency)
Question 17: BCNF
Answer: if it is in 3NF, and every determinant is a candidate key
Question 18: 4NF
Answer: a relation in Boyce-Codd normal form in which there are no multivalued dependencies or in which
all attributes participate in a single multivalued dependency
Question 19: Multi-Valued Dependency
Page 2
Question 1: Entity
Answer: Row, Record, or Instance
Question 2: Attribute
Answer: Column, Characteristic
Question 3: Relation
Answer: All 8 characteristics are met in a table in order to be a relation
Question 4: Functional Dependency
Answer: When one or more attributes determines the value of another attribute
Question 5: Determinant
Answer: NumberofBoxes determines CookieCost, NumberofBoxes is the determinant
Question 6: Candidate Key
Answer: is a determinant that determines all of the other columns in a relation. Identify a unique row in a
relation
Question 7: Primary Key
Answer: the chosen candidate key to be defined to the DBMS. (can be composite)
Question 8: Composite Key
Answer: when one or more columns are used to determine a particular row in a relationship
Question 9: Surrogate Key
Answer: is an artificial column that is added to serve as the primary key
Question 10: Foreign Key
Page 1
, Answer: is a column or composite of columns that is the primary key of a table that appears as an attribute
in another.
Question 11: Referential Integrity Constraint
Answer: a statement that limits the values of the foreign key by using constraints
Question 12: Entity Integrity Constraint
Answer: a fundamental requirement for the proper functioning of a relational database
Question 13: 8 Characteristics of Relations
Answer: Rows contain data about an entity Columns contain data about attributes of the entity All entries in
a column are of the same kind Each column has a unique name Cells of the table hold a single value Order
of the columns and rows are unimportant No two rows may be identical (keys)
Question 14: 1NF
Answer: when the set of conditions for a relation are met then it is said to be in 1NF
Question 15: 2NF
Answer: when the set of conditions for a relation are met, all non key attributes are determined by entire
primary key
Question 16: 3NF
Answer: when the set of conditions for a relation are met, all non key attributes are determined by entire
primary key, and there are no non-key attributes determined by another non-key attribute (Transitive
dependency)
Question 17: BCNF
Answer: if it is in 3NF, and every determinant is a candidate key
Question 18: 4NF
Answer: a relation in Boyce-Codd normal form in which there are no multivalued dependencies or in which
all attributes participate in a single multivalued dependency
Question 19: Multi-Valued Dependency
Page 2
