2025/2026 IT214 NEWEST QUESTIONS
AND CORRECT ANSWERS | A+ GRADE
VERIFIED ANSWERS
In a database, a foreign key is defined as: Correct Answer
A data element/attribute within a data field of a data record
within a database table that is a primary key in another
database table.
Normalization ________ data duplication. What should be
the Correct Answer among the following to fill the blank:
Correct Answer eliminates
A table is said to be in the Third Normal Form when, it is in
the second normal form and it DOESN'T have transitive
dependency. Correct Answer TRUE
A table is in 1NF if it has primary key, non repeating
groups and the table cells must be of single value. Correct
Answer TRUE
First normal form (1NF) has one or more repeating
groups, no primary key and multi value cells. Correct
Answer FALSE:
Unnormalized form (UNF) has one or more repeating
groups, no primary key and multi value cells
,A function that has no partial functional dependencies is in
which form: Correct Answer 2NF
The table is in 2NF if it is in 1NF and no partial
dependencies exist.
A table is said to be in the Third Normal Form when, it is in
the second normal form and it HAS transitive dependency.
Correct Answer FALSE:
A table is said to be in the Third Normal Form when, it is in
the Second Normal form and it doesn't have Transitive
Dependency.
Specify for the following attributes if they are simple (SA)
or composite (CA) by writing SA or CA in the table below:
ATTRIBUTESA/CA
name[name] =
description[description] =
msrp[msrp] =
mpg[mpg] =
city mpg[citympg] =
hwy mpg[hwympg] =
photo file[photofile] = Correct Answer name[name] = SA
description[description] = SA
msrp[msrp] = SA
mpg[mpg] = CA
city mpg[citympg] = SA
hwy mpg[hwympg] = SA
photo file[photofile] = CA
, The entities that participate in a relationship are also
known as___. Correct Answer Participants
Several children may have the same father is an example
of___relationship type. Correct Answer many to one/ M:1
A relationship___indicates the number of entities or
participants associated with a relationship. Correct Answer
Degree
For the entity PERSON the attribute fullname is an
example of a unique values attribute. Correct Answer
FALSE:
A unique (value) attribute is an attribute that have a unique
(different) value or no value at all for all entity instances
(already defined or to be defined in the future). There are
two persons that have the same full name, therefore
fullname is not a unique attribute.
A required attribute is an attribute that must have a value
only for all entity instances already defined. Correct
Answer FALSE:
A required attribute is an attribute that must have a value
for all entity instances (already defined or to be defined in
the future)
For the entity PERSON the attribute middle_name is an
example of an optional attribute. Correct Answer TRUE:
AND CORRECT ANSWERS | A+ GRADE
VERIFIED ANSWERS
In a database, a foreign key is defined as: Correct Answer
A data element/attribute within a data field of a data record
within a database table that is a primary key in another
database table.
Normalization ________ data duplication. What should be
the Correct Answer among the following to fill the blank:
Correct Answer eliminates
A table is said to be in the Third Normal Form when, it is in
the second normal form and it DOESN'T have transitive
dependency. Correct Answer TRUE
A table is in 1NF if it has primary key, non repeating
groups and the table cells must be of single value. Correct
Answer TRUE
First normal form (1NF) has one or more repeating
groups, no primary key and multi value cells. Correct
Answer FALSE:
Unnormalized form (UNF) has one or more repeating
groups, no primary key and multi value cells
,A function that has no partial functional dependencies is in
which form: Correct Answer 2NF
The table is in 2NF if it is in 1NF and no partial
dependencies exist.
A table is said to be in the Third Normal Form when, it is in
the second normal form and it HAS transitive dependency.
Correct Answer FALSE:
A table is said to be in the Third Normal Form when, it is in
the Second Normal form and it doesn't have Transitive
Dependency.
Specify for the following attributes if they are simple (SA)
or composite (CA) by writing SA or CA in the table below:
ATTRIBUTESA/CA
name[name] =
description[description] =
msrp[msrp] =
mpg[mpg] =
city mpg[citympg] =
hwy mpg[hwympg] =
photo file[photofile] = Correct Answer name[name] = SA
description[description] = SA
msrp[msrp] = SA
mpg[mpg] = CA
city mpg[citympg] = SA
hwy mpg[hwympg] = SA
photo file[photofile] = CA
, The entities that participate in a relationship are also
known as___. Correct Answer Participants
Several children may have the same father is an example
of___relationship type. Correct Answer many to one/ M:1
A relationship___indicates the number of entities or
participants associated with a relationship. Correct Answer
Degree
For the entity PERSON the attribute fullname is an
example of a unique values attribute. Correct Answer
FALSE:
A unique (value) attribute is an attribute that have a unique
(different) value or no value at all for all entity instances
(already defined or to be defined in the future). There are
two persons that have the same full name, therefore
fullname is not a unique attribute.
A required attribute is an attribute that must have a value
only for all entity instances already defined. Correct
Answer FALSE:
A required attribute is an attribute that must have a value
for all entity instances (already defined or to be defined in
the future)
For the entity PERSON the attribute middle_name is an
example of an optional attribute. Correct Answer TRUE:
