Week 4 - Database Design

Front

What is the first step in conceptual design?

Back

Data analysis and requirements.

Front

What is the purpose of entity relationship modeling and normalization?

Back

To define business rules and develop the conceptual model using ER diagrams.

Front

What is data model verification?

Back

It is one of the last steps in the conceptual design stage and is critical.

Front

What is distributed database design?

Back

It involves distributing database data and processes across the system, with portions known as database fragments residing in several physical locations.

Front

What is a database fragment?

Back

A subset of a database stored at a given location, which may consist of rows or columns from one or multiple tables.

Front

What is logical design in database design?

Back

The second stage in the database design process, aiming to design an enterprise-wide database based on a specific data model but independent of physical-level details.

Front

What is the focus of the physical design stage in database design?

Back

Determining the data storage organization and data access characteristics to ensure integrity, security, and performance.

Front

What is the last stage of the database design process?

Back

Physical design.