Data Modeling Concepts Assessment

$16.00

Data Modeling Concepts Assessment

$16.00
description

The Data Modeling Concepts test is meant to determine a programmer's design experience in both conceptual/logical and physical data modeling. This test is relevant for a candidate that has functional knowledge in Information Technology relevant to programming, design, or management of applications, and it addresses concepts that are unique to Data Modeling applications. This test does not examine a candidate's knowledge of any specific application.

 

Number of questions 40
Competencies tested Data Relationships and Cardinality
Logical vs. Physical Data Modeling
Rules of Data Normalization
Modeling Terms & Concepts
Tasks tested Identifying Cardinalities
Relating Components to their Subcomponents
Hierarchies in Relationships
Dealing with Common Data Elements
Recursion
Organizational Relationships
Assigning a Unique Identifier
Assigning Keys
Physical Object
Conceptual/Logical Data Modeling
Physical Data Modeling
Identifying Components of a Conceptual/Logical Data Model
Gathering Requirements
Appropriate Level of Data Normalization
Normalization Rule
Identifying Key Dependency
Modeling Multiple Optional Addresses
Attribute Dependency
Existing Structures for Data Normalization
Benefits of Data Normalization
Modeling Multi-Valued Keys
Determining Attributes
Distinguishing Between the Components of a Model
Physical Database
Entity Instance
Primary Key
Describe a Logical/Conceptual Data Model
Discovering Entity Types
Assigning Attributes
Associative Entity
Designating Unique Identifiers
Subject Area
Generating the DDL
Entity
Diagram for Logical Data Model
Data Modeling Standard
Working from an Existing Physical Design
Domains
Concatenated Key