Timedora
Free Online Flashcard Deck

Data Modeling Fundamentals and Model Levels Free Online Flashcards

Study Data Modeling Fundamentals and Model Levels with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.

12 cards
01
Front

What does a data model describe?

Back

A data model describes the information a system needs to store, its properties and relationships, and rules that help keep the data meaningful.

02
Front

What does it mean that a data model is an abstraction?

Back

A data model is an abstraction: it records facts relevant to a task rather than every detail of reality.

03
Front

What does a conceptual data model describe?

Back

A conceptual model names important business concepts and the relationships among them.

04
Front

What does a logical data model specify?

Back

A logical model specifies entities, attributes, identifiers, and rules without committing to a particular database product.

05
Front

What does a physical data model describe?

Back

A physical model describes how a chosen database implements the design, including tables, columns, keys, indexes, and storage details.

06
Front

How does a logical model differ from a physical model?

Back

A logical model defines entities, attributes, identifiers, and rules without selecting a database product; a physical model describes implementation in a chosen database.

07
Front

Which data-model level names business concepts and their relationships?

Back

The conceptual level identifies important business concepts and their relationships.

08
Front

Which level defines entities and attributes independently of a database product?

Back

The logical level specifies entities, attributes, identifiers, and rules without committing to a particular database product.

09
Front

Which data-model level includes tables, indexes, and storage details?

Back

The physical level describes database implementation details such as tables, columns, keys, indexes, and storage.

10
Front

At which level does “Customer places Order” express a business relationship?

Back

“Customer places Order” is a conceptual-level example: it names business concepts and their relationship.

11
Front

Besides information itself, what aspects of it does a data model represent?

Back

A data model represents information a system needs to store, including its properties and connections.

12
Front

What role do rules play in a data model?

Back

A data model includes rules that help keep the data meaningful.