CS6400 - Exam 2
Study online at https://quizlet.com/_c2zc70
1. How to map enti- Create a relation for the entity type with the same name
ty types?
2. How to map a sin- ET will have B as an attribute
gle value proper-
ty, B, in a relation,
ET?
3. How to map an A becomes the primary key of ET
identifying prop-
erty, A, in a rela-
tion, ET?
4. How to map a ET will have D and E as attributes
composite prop-
erty type, C com-
posed of D and E,
in a relation, ET?
5. What happens to C gets lost and the meaning expressed by the relation is not as rich.
composite prop- By putting C in the relation, it loses the property of having atomic relations.
erty C when map-
ping to relations?
6. How to map Create a new relation, ET-F.
a multivalued
property type, F, The combination of A and F become a composite key
in a relation, ET?
A is a foreign key
For a given instance of ET, it will have a unique value of A.
7. How to map In either relation, add the PK of the other entity as a foreign key
1:1 relationship
, CS6400 - Exam 2
Study online at https://quizlet.com/_c2zc70
types with enti-
ties ET1 (PK A)
and ET2 (PK B)?
8. How to map Put the foreign key on the mandatory side so that for every instance of the
1:1 relationships mandatory participation side, it is related to the other entity.
with mandatory
participation?
9. How to map Assign the foreign key to the "many" side
1:M relationship
types?
10. How to map Create a relation for ET1
N:M relationship
types? Create a relation for ET2
Create a relation for the relationship between ET1 and ET2, which has FK to PK of
ET1 (A) and another FK to PK of ET2 (B)
11. How to map Create a relation ET1 with PK (A)
weak relation-
ships? ET1 is Create a relation ET2 with composite PK, A and B.
strong entity, ET2
A is an FK to ET1 in ET2
is weak entity
12. How to Create a relation for ET1 and ET2 with attributes of ET
map super-sub-
type relation-
ships (mandato-
ry/disjoint)?
ET is supertype
Study online at https://quizlet.com/_c2zc70
1. How to map enti- Create a relation for the entity type with the same name
ty types?
2. How to map a sin- ET will have B as an attribute
gle value proper-
ty, B, in a relation,
ET?
3. How to map an A becomes the primary key of ET
identifying prop-
erty, A, in a rela-
tion, ET?
4. How to map a ET will have D and E as attributes
composite prop-
erty type, C com-
posed of D and E,
in a relation, ET?
5. What happens to C gets lost and the meaning expressed by the relation is not as rich.
composite prop- By putting C in the relation, it loses the property of having atomic relations.
erty C when map-
ping to relations?
6. How to map Create a new relation, ET-F.
a multivalued
property type, F, The combination of A and F become a composite key
in a relation, ET?
A is a foreign key
For a given instance of ET, it will have a unique value of A.
7. How to map In either relation, add the PK of the other entity as a foreign key
1:1 relationship
, CS6400 - Exam 2
Study online at https://quizlet.com/_c2zc70
types with enti-
ties ET1 (PK A)
and ET2 (PK B)?
8. How to map Put the foreign key on the mandatory side so that for every instance of the
1:1 relationships mandatory participation side, it is related to the other entity.
with mandatory
participation?
9. How to map Assign the foreign key to the "many" side
1:M relationship
types?
10. How to map Create a relation for ET1
N:M relationship
types? Create a relation for ET2
Create a relation for the relationship between ET1 and ET2, which has FK to PK of
ET1 (A) and another FK to PK of ET2 (B)
11. How to map Create a relation ET1 with PK (A)
weak relation-
ships? ET1 is Create a relation ET2 with composite PK, A and B.
strong entity, ET2
A is an FK to ET1 in ET2
is weak entity
12. How to Create a relation for ET1 and ET2 with attributes of ET
map super-sub-
type relation-
ships (mandato-
ry/disjoint)?
ET is supertype
