uCertify

Data Modeling

(UOP-DSC530.AO1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Data Modeling Concepts and Relational Model Component

  • Data-Centric Design
  • Anatomy of a Data Model
  • Importance of Data Modeling
  • Measures of a Good Data Model
  • How Data Models Fit Into Application Development
  • Data Modeling Participants
  • Conceptual and Logical Model Components
  • Physical Model Components
2

Data and Process Modeling and Organizing Database Project Work

  • Data Model Diagramming Alternatives
  • Process Models
  • Unified Modeling Language (UML)
  • Relating Entities and Processes
  • The Traditional Life Cycle
  • Nontraditional Life Cycles
  • The Project Triangle
3

Conceptual Data Modeling and Logical Database Design Using Normalization

  • The Conceptual Modeling Process
  • Creating the Model
  • Evaluating the Model
  • The Need for Normalization
  • Applying the Normalization Process
  • Denormalization
  • Practice Problems
4

Beyond Third Normal Form and Physical Database Design

  • Advanced Normalization
  • Resolving Supertypes and Subtypes
  • Generalizing Attributes
  • Alternatives for Reference Data
  • The Physical Design Process
  • Designing Tables
  • Integrating Business Rules and Data Integrity
  • Adding Indexes for Performance
  • Designing Views
5

Alternatives for Incorporating Business Rules and for Handling Temporal Data

  • The Anatomy of a Business Rule
  • Implementing Business Rules in Data Models
  • Limitations on Implementing Business Rules in Data Models
  • Functional Classification of Business Rules
  • Temporal Data Structures
  • Calendar Data Structures
  • Business Rules for Temporal Data
6

Modeling for Analytical Databases and Enterprise Data

  • Data Warehouses
  • Data Marts
  • Modeling Analytical Data Structures
  • Loading Data into Analytical Databases
  • Enterprise Data Management
  • The Enterprise Data Model

1

Data Modeling Concepts and Relational Model Component

  • Creating a Conceptual Model
  • Creating a Physical Data Model
  • Creating a Logical Data Model
  • Modifying a Conceptual Model
2

Data and Process Modeling and Organizing Database Project Work

  • Drawing of a Conceptual Model with Nested Subtypes
3

Conceptual Data Modeling and Logical Database Design Using Normalization

  • Creating a Conceptual Model for the Employee Management System
  • Analyzing Normalization in Academic Tracking Database
  • Creating a Data Model in Second Normal Form
  • Creating a Data Model in First Normal Form
4

Beyond Third Normal Form and Physical Database Design

  • Creating a Data Model in Fourth Normal Form
  • Creating a Complex Logical Data Model
  • Converting a Logical Data Model into a Physical Data Model
  • Creating a Physical Data Model ERD
  • Creating a Data Model in Third Normal Form
5

Alternatives for Incorporating Business Rules and for Handling Temporal Data

  • Modeling Business Rules in a Logical Data Model
  • Adding History to Data Models
6

Modeling for Analytical Databases and Enterprise Data

  • Designing a Star Schema Fact Table
  • Developing an Enterprise Conceptual Model

Related Courses

All Courses