Database Modeling and Design MCQs with Answers
Practice important Database Modeling and Design MCQs with answers and explanations.
Multiple Choice Questions
Q121: In an ERD, what does an entity represent?
- A: An attribute
- B: A property
- C: A real-world object
- D: A process
View Answer
C
Q122: What is an attribute in the context of an ERD?
- A: A relationship between entities
- B: A property of an entity
- C: A class in a database
- D: A graphical representation
View Answer
B
Q123: What is the smallest storage unit of any database?
- A: Column
- B: Entity
- C: Attribute
- D: Row
View Answer
C
Q124: What is the purpose of relationships in an ERD?
- A: To describe entities
- B: To connect data among entities
- C: To visualize attributes
- D: To store data
View Answer
B
Q125: In a school database, which of the following can be considered an entity?
- A: Exams
- B: Timetable
- C: Student
- D: Attendance
View Answer
C
Q126: The word "entity" is derived from the Latin word "en," meaning ______.
- A: being
- B: existence
- C: life
- D: object
View Answer
A
Q127: What is an entity set?
- A: A collection of similar types of entities
- B: A single attribute
- C: A data model
- D: A database design
View Answer
A
Q128: What is the function of an Entity-Relationship Diagram (ERD)?
- A: Visualizes the business data
- B: Defines system processes
- C: Stores large amounts of data
- D: Executes business logic
View Answer
A
Q129: What does an Entity Relationship Diagram (ERD) represent in database design?
- A: Entity, Relationship, and Attributes types
- B: Logic gates
- C: Arithmetic operations
- D: Sorting algorithms
View Answer
A
Q130: Which of the following is an entity in the building apartment renting scenario?
- A: FLOOR
- B: DOOR
- C: CEILING
- D: CUSTOMER
View Answer
D