Data Modeling Concepts

  • $10.00


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
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Data Relationships and Cardinality
Logical vs. Physical Data Modeling
Modeling Terms & Concepts
Rules of Data Normalization
Tasks tested Appropriate Level of Data Normalization
Assigning a Unique Identifier
Assigning Attributes
Assigning Keys
Associative Entity
Attribute Dependency
Benefits of Data Normalization
Concatenated Key
Conceptual/Logical Data Modeling
Data Modeling Standard
Dealing with Common Data Elements
Describe a Logical/Conceptual Data Model
Designating Unique Identifiers
Determining Attributes
Diagram for Logical Data Model
Discovering Entity Types
Distinguishing Between the Components of a Model
Domains
Entity
Entity Instance
Existing Structures for Data Normalization
Gathering Requirements
Generating the DDL
Hierarchies in Relationships
Identifying Cardinalities
Identifying Components of a Conceptual/Logical Data Model
Identifying Key Dependency
Modeling Multi-Valued Keys
Modeling Multiple Optional Addresses
Normalization Rule
Organizational Relationships
Physical Data Modeling
Physical Database
Physical Object
Primary Key
Recursion
Relating Components to their Subcomponents
Subject Area
Working from an Existing Physical Design
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)