Question: I have five E-R model questions: Question 24 1. When converting an E-R model to a relational model, the table for a binary relationship can

I have five E-R model questions:

Question 24

1. When converting an E-R model to a relational model, the table for a binary relationship can be replaced by a foreign key provided the relationship is not

A.

many-to-many

B.

many-to-one

C.

one-to-many

D.

one-to-one

0.5 points

Question 31

1. In the E-R model, an attribute that can be broken down into smaller attributes is called

A.

composite

B.

null

C.

a superattribute

D.

derived

0.5 points

Question 34

1. In the EE-R model, completeness constraints tell us whether a specialization is

A.

total or partial

B.

union or category

C.

disjoint or overlapping

D.

predicate-defined or user-defined

0.5 points

Question 38

1. When an entity set is related to itself, we have a _______ relationship.

A.

extended

B.

optional

C.

mandatory

D.

recursive

0.5 points

Question 39

1. In the relational model, the table in which a foreign key appears as the primary key is called its

A.

root relation

B.

home relation

C.

child relation

D.

foreign relation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!