What is First Normal Form ?

Repeating groups must beeliminated, Dependencies can be identified, All key attributesdefined,No repeating groups in table

What is Second Normal Form ?

The Table is already in1NF,Includes no partial dependencies–No attribute dependent on a portionof primary key, Still possible to exhibit transitivedependency,Attributes may be functionally dependent on non-keyattributes .

What is Third Normal Form?

The Table is already in 2NF, Contains no transitive dependencies .

What is Fact table?

Fact Table contains the measurements or metrics or facts of business process. If your business process is "Sales" , then a measurement of this business process such as "monthly sales number" is captured in the Fact table. Fact table also contains the foriegn keys for the dimension tables

What are conformed dimensions?

Conformed dimensions mean the exact same thing with every possible fact table to which they are joined Ex:Date Dimensions is connected all facts like Sales facts,Inventory facts..etc