CS10337 - Lecture # 7

Data modeling is done after the database tables are created in MySQL.

• True

• False

A conceptual data model focuses on entities and relationships without including physical database details.

• True

• False

Data modeling improves communication between technical and business teams.

• True

• False

Normalization is unrelated to data modeling because it deals only with physical implementation.

• True

• False

In a data model, a one-to-many relationship means that one record in a table can relate to multiple records in another.

• True

• False

Which of the following are key objectives of data modeling?
(Select all that apply)

• Clarity

• Accuracy

• Performance tuning of SQL queries

• Communication

• Security enforcement

Which of the following best describes the role of data modeling?

• To define how data is physically stored in MySQL

• To visually represent entities, attributes, and relationships before implementation

• To optimize query performance using indexes

• To enforce data security through user permissions

Which of the following are common relationship types used in data modeling?
(Select all that apply)

• One-to-One

• One-to-Many

• Many-to-Many

• Circular-to-Linear

During the data modeling process, which of the following are typical steps?
(Select all that apply)

• Identify entities and attributes

• Establish relationships

• Draw the ER diagram

• Write SQL queries for each relationship

• Apply normalization

10. In the airline flight management system demo, which of the following would be considered entities?
    (Select all that apply)

• Flight

• Passenger

• Aircraft

• Booking

• Pilot