Database Design Concepts

Conceptual design is the first stage of database design.

• False

• True

Physical design comes before logical design in the database design process.

• True

• False

Normalization is used to eliminate data redundancy in database design.

• True

• False

Which diagram is commonly used in conceptual database design?

• Flowchart

• Gantt Chart

• Entity-Relationship Diagram

• Use Case Diagram

What does DBMS stand for?

• Database Management System

• Data Base Manipulation Software

• Digital Business Management System

• Database Maintenance Service

Which of the following is NOT typically part of conceptual design?

• Entity Identification

• Relationship Mapping

• Table Creation

• Attribute Definition

In an Entity-Relationship Diagram, what does a diamond shape typically represent?

• Entity

• Relationship

• Attribute

• Primary Key

Which of the following is an example of a one-to-many relationship?

• A student and their student ID

• A book and its ISBN

• A customer and their orders

• A country and its capital city

What is the main purpose of the logical design phase?

• To create a physical storage structure

• To translate the conceptual model into a database schema

• To identify entities and relationships

• To optimize query performance

Which of the following is NOT a typical step in database design?

• Requirements gathering

• Conceptual design

• User interface design

• Physical design