Data Modeling

Question 1

Data Model

Answer 1

Simple representation (usually graphical) of real-world data structures: characteristics, relations, constraints, transformations, and other constructs.

Question 2

Constraint

Answer 2

Restriction placed on the data

Ensure data integrity

Question 3

Business Rule

Answer 3

Brief, precise, unambiguous description of a policy, procedure, or principle within an organization.

Question 4

Schema

Answer 4

Conceptual organization of entire database as viewed by database admnistrator.

Question 5

Subschema

Answer 5

Defines a portion of the database “seen” by application programs.

Question 6

RDBMS

Answer 6

Relational Database Management System

Hides the complexities of the relational model from the user by managing all of the physical details.

Question 7

End-User Interface

Answer 7

Allows end user to interact with data

Question 8

ERM

Answer 8

Entity Relationship Model

Graphical tools to show relational data.

Question 9

OODM

Answer 9

Object-Oriented Data Model

Both data and its relationships are contained in a single structure (object)

Question 10

ERDM

Answer 10

Extended Relational Data Model

Merges OODM features with simpler relationship database structure.

Question 11

XML

Answer 11

Extensible Markup Language

Standard for efficient exchange of structured, semistructured, and unstructured data.

Question 12

3Vs

Answer 12

Volume - amount of data stored
Velocity - speed that data grows and need to process quickly
Variety - multiple data formats