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. Total Questions 40 Question Types Multiple Choice Competencies Tested Data Relationships and CardinalityLogical vs. Physical Data ModelingRules of Data NormalizationModeling Terms & ConceptsPrimary & Foreign Key Identifiers Tasks Tested Identifying CardinalitiesRelating Components to their SubcomponentsHierarchies in RelationshipsDealing with Common Data ElementsRecursionOrganizational RelationshipsAssigning a Unique IdentifierAssigning KeysPhysical ObjectConceptual/Logical Data ModelingPhysical Data ModelingIdentifying Components of a Conceptual/Logical Data ModelGathering RequirementsAppropriate Level of Data NormalizationNormalization RuleIdentifying Key DependencyModeling Multiple Optional AddressesAttribute DependencyExisting Structures for Data NormalizationBenefits of Data NormalizationModeling Multi-Valued KeysDetermining AttributesDistinguishing Between the Components of a ModelPhysical DatabaseEntity InstancePrimary KeyDescribe a Logical/Conceptual Data ModelDiscovering Entity TypesAssigning AttributesAssociative EntityDesignating Unique IdentifiersSubject AreaGenerating the DDLEntityDiagram for Logical Data ModelData Modeling StandardWorking from an Existing Physical DesignDomainsConcatenated Key
