Machine-translated by Google. Questions are authored in English.
Top

Logical Database Design Questions and Answers

31.

Well-structured relations encourage anomalies of data.

Answer: B

Correct answer: False

Well-structured relations are precisely those that avoid anomalies. A relation containing redundancy admits insertion, deletion and update anomalies, and normalisation removes them by splitting the relation until every attribute depends on the key and nothing else.

Please log in or register to report this question.

32.

When mapping a regular entity into a relation which of the following is true?

Answer: A

Correct answer: One relation is created.

A regular entity maps directly to a single relation: its identifier becomes the primary key and its simple attributes become columns. Composite attributes contribute their components, and multivalued attributes are the exception, requiring a relation of their own.

Please log in or register to report this question.

Loading…

Other Subjects

Tags: Logical Database Design Questions and Answers || Logical Database Design MCQ Questions and Answers || Logical Database Design GK Questions and Answers || Logical Database Design GK MCQ Questions || Logical Database Design Multiple Choice Questions and Answers || Logical Database Design GK || GK on Logical Database Design || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database