OMIS 452 Exam 1 Questions and Answers
Save
3
Terms in this set (122)
Entity Row, Record, or Instance
Attribute Column, Characteristic
Relation All 8 characteristics are met in a table in order to be a relation
When one or more attributes determines the value of another
Functional Dependency
attribute
NumberofBoxes determines CookieCost, NumberofBoxes is the
Determinant
determinant
is a determinant that determines all of the other columns in a
Candidate Key
relation. Identify a unique row in a relation
the chosen candidate key to be defined to the DBMS. (can be
Primary Key
composite)
when one or more columns are used to determine a particular
Composite Key
row in a relationship
Surrogate Key is an artificial column that is added to serve as the primary key
is a column or composite of columns that is the primary key of a
Foreign Key
table that appears as an attribute in another.
, a statement that limits the values of the foreign key by using
Referential Integrity Constraint
constraints
a fundamental requirement for the proper functioning of a
Entity Integrity Constraint
relational database
Rows contain data about an entity
Columns contain data about attributes of the entity
All entries in a column are of the same kind
8 Characteristics of Relations 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)
when the set of conditions for a relation are met then it is said to
1NF
be in 1NF
when the set of conditions for a relation are met, all non key
2NF
attributes are determined by entire primary key
when the set of conditions for a relation are met, all non key
attributes are determined by entire primary key, and there are no
3NF
non-key attributes determined by another non-key attribute
(Transitive dependency)
BCNF if it is in 3NF, and every determinant is a candidate key
a relation in Boyce-Codd normal form in which there are no
4NF multivalued dependencies or in which all attributes participate in
a single multivalued dependency
Save
3
Terms in this set (122)
Entity Row, Record, or Instance
Attribute Column, Characteristic
Relation All 8 characteristics are met in a table in order to be a relation
When one or more attributes determines the value of another
Functional Dependency
attribute
NumberofBoxes determines CookieCost, NumberofBoxes is the
Determinant
determinant
is a determinant that determines all of the other columns in a
Candidate Key
relation. Identify a unique row in a relation
the chosen candidate key to be defined to the DBMS. (can be
Primary Key
composite)
when one or more columns are used to determine a particular
Composite Key
row in a relationship
Surrogate Key is an artificial column that is added to serve as the primary key
is a column or composite of columns that is the primary key of a
Foreign Key
table that appears as an attribute in another.
, a statement that limits the values of the foreign key by using
Referential Integrity Constraint
constraints
a fundamental requirement for the proper functioning of a
Entity Integrity Constraint
relational database
Rows contain data about an entity
Columns contain data about attributes of the entity
All entries in a column are of the same kind
8 Characteristics of Relations 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)
when the set of conditions for a relation are met then it is said to
1NF
be in 1NF
when the set of conditions for a relation are met, all non key
2NF
attributes are determined by entire primary key
when the set of conditions for a relation are met, all non key
attributes are determined by entire primary key, and there are no
3NF
non-key attributes determined by another non-key attribute
(Transitive dependency)
BCNF if it is in 3NF, and every determinant is a candidate key
a relation in Boyce-Codd normal form in which there are no
4NF multivalued dependencies or in which all attributes participate in
a single multivalued dependency
