Entity Relationship (ER) Modeling Questions

MCQ bookmark_border

31.

The entity relationship set is represented in E-R diagram as

A

Double diamonds

B

Undivided rectangles

C

Dashed lines

D

Diamond

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

32.

The Rectangles divided into two parts represents

A

Entity set

B

Relationship set

C

Attributes of a relationship set

D

Primary key

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

33.

Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality

A

One to many

B

One to one

C

Many to many

D

Many to one

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

34.

R diagrams by labeling the lines that connect ___________ to __________

A

Diamond , diamond

B

Rectangle, diamond

C

Rectangle, rectangle

D

Diamond, rectangle

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

35.

An entity set that does not have sufficient attributes to form a primary key is termed a __________

A

Strong entity set

B

Variant set

C

Weak entity set

D

Variable set

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

36.

For a weak entity set to be meaningful, it must be associated with another entity set, called the

A

Identifying set

B

Owner set

C

Neighbour set

D

Strong entity set

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

37.

Weak entity set is represented as

A

Underline

B

Double line

C

Double diamond

D

Double rectangle

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

38.

If you were collecting and storing information about your music collection, an album would be considered a(n) _____

A

Relation

B

Entity

C

Instance

D

Attribute

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

39.

information stored about a specific album?

A

Relation

B

Instance

C

Table

D

Column

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

40.

Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them.

A

Entity

B

Attribute

C

Relation

D

Value

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion