Database Design

These flashcards cover key concepts, definitions, and processes involved in database design and development.

In the Database development process, a Database designer must first __.

Define Database design Objectives.

Database designers collect user database requirements through __.

elicitation.

The logical design of the database includes defining __ and DB constraints.

tables

To minimize data redundancy, database designers __ the database.

Refine & Normalize

A __ is an assertion that must be true at all times in a database.

constraint

In cardinality, a One-to-Many relationship means that an entity on one side can have __ related entities.

many

A __ shows entities and the relationships among them in database design.

Entity-Relationship Diagram (ERD)

In Crow's Foot notation, the symbol 'O+' represents __.

Mandatory-Many.

The term __ refers to a detailed logical representation of data for an organization.

Entity-Relationship (E-R) model.

Attributes in an Entity-Relationship model are represented as __.

oval.