Home » MCQs » DBMS MCQs

DBMS ER-Diagram Reduction to Table Multiple-Choice Questions (MCQs)

DBMS ER-Diagram Reduction to Table MCQs: This section contains DBMS ER-Diagram Reduction to Table Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on February 16, 2022

1. You can represent the database using the ___.

1. Tables
2. Notations
3. Database
4. Fields

Answer: B) Notations

Explanation:

You can represent the database using the notations.

Discuss this Question

---

2. An entity or relationship set may be represented in a database as a ___.

1. Table
2. Field
3. Database
4. Entity

Answer: A) Table

Explanation:

An entity or relationship set may be represented in a database as a table.

Discuss this Question

---

3. What are some important points to convert ER Diagrams into tables?

1. Tables are created from entity types.
2. Whenever an attribute is single-valued, it becomes a column for the table.
3. Primary keys represent key attributes of entity types.
4. All of the above

Answer: D) All of the above

Explanation:

Some important points to convert ER Diagrams into tables are -

1. Tables are created from entity types.
2. Whenever an attribute is single-valued, it becomes a column for the table.
3. Primary keys represent key attributes of entity types.

Discuss this Question

---

4. A separate table represents the ___ attribute.

1. Single-valued
2. Double-valued
3. Multivalued
4. None of the above

Answer: C) Multivalued

Explanation:

A separate table represents the multivalued attribute.

Discuss this Question

---

5. Components represent an attribute of a ___.

1. Simple
2. Combined
3. Composite
4. Intrinsic

Answer: C) Composite

Explanation:

Components represent an attribute of a composite.

Discuss this Question

---

6. Which attributes aren't considered in a table?

1. Core
2. Composite
3. Derived
4. None

Answer: C) Derived

Explanation:

Derived attributes aren't considered in a table.

Discuss this Question

---

7. How many rules are there for reducing the ER Diagram into a table?

1. 3
2. 4
3. 5
4. 6

Answer: D) 6

Explanation:

There are 6 rules for reduction of ER Diagram into a table.

Discuss this Question

---

8. Entity type's key attribute is represented by -

1. Foreign Key
2. Composite Key
3. Alternate Key
4. Primary Key

Answer: D) Primary Key

Explanation:

Entity type's key attribute is represented by Primary Key.

Discuss this Question

---

9. Which type of attributes become the column for the table.

1. Single-valued
2. Double-valued
3. Multivalued
4. None

Answer: A) Single-valued

Explanation:

Single-valued attributes become the column for the table.

Discuss this Question

---

10. What cannot be represented in a tabular form?

1. Entity set
2. Relationship Set
3. Dataset
4. None

Answer: D) None

Explanation:

All entity set, relationship set and dataset can be represented in a tabular form.

Discuss this Question

---

---