FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A regular dimension relationship represents the relationship between dimension tables and a fact table in a traditional star schema design.

Detailed explanation-2: -As a rule, each foreign key of the fact table must have its counterpart in a dimension table. Additionally, any table in a dimensional database that has a composite key must be a fact table. This means that every table in a dimensional database that expresses a many-to-many relationship is a fact table.

Detailed explanation-3: -With a many-to-many dimension, values are distinct summed, which means that they do not aggregate more than once to the All member. In order to support a many-to-many dimension relationship, a primary key-foreign key relationship must be defined in the data source view between all the tables that are involved.

Detailed explanation-4: -A fact table sits at the center of a star schema database, and each star schema database only has a single fact table. The fact table contains the specific measurable (or quantifiable) primary data to be analyzed, such as sales records, logged performance data or financial data.

Detailed explanation-5: -A star schema can have any number of dimension tables. The branches at the end of the links connecting the tables indicate a many-to-one relationship between the fact table and each dimension table.