Entity Relationship (ER) Modeling Questions

MCQ bookmark_border

41.

The total participation by entities is represented in E-R diagram as

A

Dashed line

B

Double line

C

Double rectangle

D

Circle

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

42.

Given the basic ER and relational models, which of the following is INCORRECT?

A

An attribute of an entity can have more than one value

B

An attribute of an entity can be composite

C

In a row of a relational table, an attribute can have more than one value

D

In a row of a relational table, an attribute can have exactly one value or a NULL value

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

43.

Which of the following indicates the maximum number of entities that can be involved in a relationship?

A

Minimum cardinality

B

Maximum cardinality

C

ERD

D

Greater Entity Count

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

44.

In E-R diagram generalization is represented by

A

Ellipse

B

Dashed ellipse

C

Rectangle

D

Triangle

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

45.

What is a relationship called when it is maintained between two entities?

A

Unary

B

Binary

C

Ternary

D

Quaternary

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

46.

Which of the following is a low level operator?

A

Insert

B

Update

C

Delete

D

Directory

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

47.

Key to represent relationship between tables is called

A

Primary key

B

Secondary Key

C

Foreign Key

D

None of the mentioned

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

48.

A window into a portion of a database is

A

Schema

B

View

C

Query

D

Data dictionary

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

49.

A primary key is combined with a foreign key creates

A

Parent-Child relation ship between the tables that connect them

B

Many to many relationship between the tables that connect them

C

Network model between the tables that connect them

D

None of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

50.

The entity set person is classified as student and employee. This process is called _________

A

Generalization

B

Specialization

C

Inheritance

D

Constraint generalization

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion