Explain Data Modeling Methodology And Concepts

• Apply data modeling concepts
• Identify supported data models
• Explain the role of the RBC case study in this course

Build A Logical Data Model

• Create entities, attributes, and keys
• Create relationships
• Verify your actions

Build A Physical Data Model

• Compare physical and logical data models
• Edit table properties
• Edit column properties
• Assign database views
• Create indexes
• Calculate volumetrics

Reverse‐Engineer And Validate A Data Model

• Create a data model from an existing system
• Validate the data model

Present A Data Model

• Create subject areas and ER diagrams
• Use the ODBC reporting functions
• Create Crystal Reports

Refine A Data Model

• Designer
• Resolve one-to-many relationship issues
• Resolve many-to-many relationship issues
• Construct generalization hierarchies
• Create user-defined domains
• Create data model templates

Apply Transformations

• Apply transformation concepts
• Execute transformations
• Create a column link

Generate And Synchronize Database Schemas

• Enforce referential integrity and enforce business rules
• Generate a schema using FE
• Synchronize a data model and a database