Curriculum
- 1 Section
- 11 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics11
- 1.1DATA MODELING THEORY & CONCEPTS ABOUT MODEL-BASED DESIGN ABOUT DATA MODELING ABOUT DATA MODEL DIAGRAMS ADVANCED MODELING METHODOLOGIES
- 1.2BUILDING AN INITIAL DATA MODEL PRINCIPLES OF DATA MODELING BUILDING THE MODEL IDENTIFYING ENTITIES IDENTIFYING ATTRIBUTES IDENTIFYING RELATIONSHIPS A SIMPLE MODELING SCENARIO
- 1.3DRAWING A MODEL USING SOFTWARE ENGINEERING TOOLS ABOUT DATA MODELING TOOLS DRAWING A DATA MODEL DIAGRAM
- 1.4INCREASING THE ACCURACY OF THE MODEL STARTING WITH A CONCEPTUAL MODEL SUPPLEMENTING THE REQUIREMENTS REFINING THE RELATIONSHIP DEFINITIONS
- 1.5FINDING & FIXING ATTRIBUTE MISTAKES CAPTURING MISSING ATTRIBUTE DETAILS CHARACTER NUMERIC DATE CORRECTING ATTRIBUTE DEFINITIONS UNIQUE IDENTIFIERS UNIT OF MEASURE ATTRIBUTES
- 1.6SEMANTIC & OBJECT ORIENTED MODELING OF ENTITIES & RELATIONSHIPS DEFINING SUPERTYPES & SUBTYPES ENTITY NAME PROBLEMS NAMING STANDARDS SPECIALIZATION & GENERALIZATION SUBTYPE CONSTRAINTS DEFINING RELATIONSHIP ARCS
- 1.7SEMANTIC & OBJECT ORIENTED MODELING OF DOMAINS & TYPES DEFINING DOMAINS DEFINING TYPES COLLECTION TYPES
- 1.8TIME-DEPENDENCY & STATE-DEPENDENCY ABOUT TIME & STATE TIME-DEPENDENT SUB-MODEL PERSON / INDIVIDUAL ROLES SUB-MODEL
- 1.9CLASSIC STRUCTURES & PATTERNS MASTER-DETAIL-DETAIL M:N RECURSION (BILL-OF-MATERIALS) ORGANIZATION UNIT HIERARCHY ENTITY LOCATIONS ENTITY CONTACTS
- 1.10LOGICAL / PHYSICAL MODEL TRANSFORMATION ABOUT PHYSICAL DATA MODELS PHYSICAL RELATIONAL TRANSFORMATION MODEL TRANSFORMATION EXAMPLE AUTOMATIC TRANSFORMATION SUPERTYPE TRANSFORMATION
- 1.11RDBMS IMPLEMENTATION OF THE PHYSICAL MODEL REVERSE ENGINEER A PHYSICAL MODEL ABOUT THE RELATIONAL DATABASE RELATIONAL DATABASE OBJECTS FORWARD ENGINEER A PHYSICAL MODEL