CIT1214_Topic 2_MCQ

What does ER stand for in database modeling?

• Entity-Reference

• Entity-Record

• Entity-Relationship

• Entity-Relation

Which of the following is NOT a phase in the database design process?

• Logical Design

• Conceptual Design

• Physical Design

• Data Collection

What is the primary purpose of an ER model?

• To visualize data structure

• To create tables

• To store data

• To manage data access

In an ER diagram, what does a rectangle represent?

• Value set

• Attribute

• Entity type

• Relationship type

Which notation is best suited for high-level modeling and teaching?

• Crow's Foot Notation

• UML Notation

• Chen ERD

• Relational Model

What type of relationship is 'Works_on' between Employee and Project?

• One-to-One

• One-to-Many

• Many-to-Many

• Many-to-One

What is a weak entity?

• An entity with no attributes

• An entity that cannot be identified independently

• An entity with multiple keys

• An entity that has a unique key

Which of the following is an example of an attribute?

• Employee

• Department

• Project

• Salary

What is the first step in the database design process?

• Logical Design

• Requirements Collection

• Conceptual Design

• Physical Design

What does the term 'cardinality' refer to in an ER model?

• The number of instances in a relationship

• The number of entities

• The number of relationships

• The number of attributes