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 ___.
- Tables
- Notations
- Database
- 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 ___.
- Table
- Field
- Database
- 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?
- Tables are created from entity types.
- Whenever an attribute is single-valued, it becomes a column for the table.
- Primary keys represent key attributes of entity types.
- All of the above
Answer: D) All of the above
Explanation:
Some important points to convert ER Diagrams into tables are -
- Tables are created from entity types.
- Whenever an attribute is single-valued, it becomes a column for the table.
- Primary keys represent key attributes of entity types.
Discuss this Question
4. A separate table represents the ___ attribute.
- Single-valued
- Double-valued
- Multivalued
- 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 ___.
- Simple
- Combined
- Composite
- Intrinsic
Answer: C) Composite
Explanation:
Components represent an attribute of a composite.
Discuss this Question
6. Which attributes aren't considered in a table?
- Core
- Composite
- Derived
- 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?
- 3
- 4
- 5
- 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 -
- Foreign Key
- Composite Key
- Alternate Key
- 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.
- Single-valued
- Double-valued
- Multivalued
- 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?
- Entity set
- Relationship Set
- Dataset
- None
Answer: D) None
Explanation:
All entity set, relationship set and dataset can be represented in a tabular form.
Discuss this Question