Font size
WorksheetsCS10337 - Lecture # 7
Total questions: 10
Worksheet time: 6mins
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
In the airline flight management system demo, which of the following would be considered entities?
(Select all that apply)
Flight
Passenger
Aircraft
Booking
Pilot
