Skip to content

Latest commit

 

History

History
24 lines (17 loc) · 977 Bytes

README.md

File metadata and controls

24 lines (17 loc) · 977 Bytes

Database Configuration Helper

A helper to ease the configuration of Entity Framework Cire database projects when using the IEntityTypeConfiguration pattern.

In most Enterprise Software solutions database schemas and database design patterns usually comprise of the Star Schema or Snowflake Schema design patterns.

erDiagram
    CUSTOMER }|..|{ DELIVERY-ADDRESS : has
    CUSTOMER ||--o{ ORDER : places
    CUSTOMER ||--o{ INVOICE : "liable for"
    DELIVERY-ADDRESS ||--o{ ORDER : receives
    INVOICE ||--|{ ORDER : covers
    ORDER ||--|{ ORDER-ITEM : includes
    PRODUCT-CATEGORY ||--|{ PRODUCT : contains
    PRODUCT ||--o{ ORDER-ITEM : "ordered in"
Loading

Generally in these types of schema there are two types of table types to describe the entities:

  1. fact-type tables - describe business events
  2. dimension-type tables - describe business entities