Search Term

Relational Data Modeling 28 pages

Aggregate Table (Summary Table)
Association Table (Bridge, Cross)
Cardinality
(Integrity) (Constraints|action assertions)
Generic Data Model
Data Model
Denormalization Methods (Changing the Database Design to Reduce the Number of Joins)
Denormalization
Entity-Relationship Diagram (ERD)
Entity Relationship Model (3NF)
Foreign Key Constraint (one-to-many relationship)
Foreign Key
(Xref|Cross-reference|Lookup) table
Many-to-many Relationship (Two-way relationship)
Normal Forms
Database Normalization
One-to-many / May-to-one Relationship
One-to-One Relationship
Primary Key Constraint
Primary key
Recursive Relationship
Refactoring
Referential Integrity (cascade)
Relationship
Schema
Unique (Constraint|Key)
View selection problem (recommending the best aggregation tables) - Data Warehousing
Visualization

Home
Data
Type
Tabular data
Modeling
Entity Relationship Model

Relational Data Modeling - Entity Relationship Model (3NF)

Table of Contents

Articles Related

Articles Related

Dimensional Data Modeling - Dimensional Schemas
Data Warehouse - Persistent layer (Fundamental Layer | Operational Data Store - ODS)
Data Warehouse - Data Models

Recommended Pages

Data Warehouse - Data Models

In the data warehousing environment, you can find several relational data models. The staging area is a temporary layer where data can persisted in order to assist the data integration in the persistence...

Data Warehouse - Persistent layer (Fundamental Layer | Operational Data Store - ODS)

A persistent layer is a data warehouse layer where data is persisted (ie never deleted). A persistent layer is also known as: a fundamental layer an operational data store (ODS) an enterprise...

Dimensional Data Modeling - Dimensional Schemas

This section is dimensional data modeling, That is the building of a cube (hypercube) A dimensional schema is a schema based on dimension. The dimensional schema can modeled: in a relational...

Share this page:

Data (State)
Data (State)
DataBase
Data Processing
Data Quality
Data Structure
Data Type
Data Warehouse
Data Visualization
Data Partition
Data Persistence
Data Concurrency

Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Modeling
Process
Logical Data Modeling
Relational Modeling
Dimensional Modeling
Automata

Data Type
Number
Time
Text
Collection
Relation (Table)
Cube
Tree
Key/Value
Graph
Spatial
Color
Log

Measure Levels
Order
Nominal
Discrete
Distance
Ratio

Code
Compiler
Lexical Parser
Grammar
Function
Testing
Debugging
Shipping
Data Type
Versioning
Design Pattern

Infrastructure
Operating System
Monitoring
Cryptography
Security
File System
Network
Process (Thread)
Computer
Infra As Code

Marketing
Advertising
Analytics
Email

Web
Html
Dom
Http
Url
Css
Javascript
Selector
Browser
Web Services
OAuth

Contact
[email protected]
Privacy Policy
Status