ER Model & Relationships MCQs with Answers

In database terminology, what does the term 'entity' refer to?

• A.A type of database query
• B.A relationship between tables
• C.A collection of attributes only
• D.A single object or concept

Which diagram is commonly used to represent the structure and relationships within a database?

• A.Flowchart
• B.Entity Relationship Diagram
• C.Data Flow Diagram
• D.Gantt Chart

What type of relationship exists when one table record relates to another record in another table?

• A.Many to one
• B.One to many
• C.Many to many
• D.One to one

In an Entity-Relationship (E-R) diagram, what does a rectangle symbolize?

• A.Attribute
• B.Relationship
• C.Entity
• D.Cardinality

What is a one to many relationship in database terminology?

• A.When records in two tables have no relationship
• B.When multiple records relate to multiple records in another table
• C.When one record relates to exactly one record in another table
• D.When one record relates to multiple records in another table

Which database concept is used to create an association between related tables?

• A.Indexing
• B.Normalization
• C.Relationship
• D.Clustering

How many types of relationships exist in relational database design?

• A.Three
• B.Four
• C.Five
• D.Six

In database terminology, what is an attribute?

• A.A collection of related records
• B.A relationship between two tables
• C.A unique identifier for a record
• D.A characteristic of an entity

In a database management system, what is the term used for the table on the 'one' side of a one-to-many relationship?

• A.Parent
• B.Child
• C.Foreign
• D.Dependent

What is the primary purpose of establishing a relationship between two tables in a database?

• A.Ensure Data Integrity
• B.Increase Storage Capacity
• C.Speed Up Query Processing
• D.Improve User Interface