Explain The Difference Between Alternate Key, Business Key, Foreign K

1.	Explain The Difference Between Alternate Key, Business Key, Foreign Key , Generated Key , Primary Key, Retained Key And Surrogate Key ?
Answer» ALTERNATE key is term also known as unique key. Business key is one or more columns in a dimension table that comprise the primary key in a SOURCE table in an operational system. Foreign key is one or more columns that are associated with a primary key or unique key in another table. A table can have one or more foreign keys. A foreign key is dependent upon its associated primary or unique key. In other words, a foreign key cannot exist without that primary or unique key. Generated keys is used to implement surrogate keys and retained keys, one or more columns that are used to uniquely identify a ROW in a table. A table can have only one primary key. One or more columns in a primary key cannot contain null values. Retained key is a numeric column in a dimension table that is the primary key of that table. Surrogate key is a column which contains unique integer values that are generated sequentially when rows are added and updated. In the associated fact table, the surrogate key is included as a foreign key in order to connect to specific dimensions.

Explain The Difference Between Alternate Key, Business Key, Foreign Key , Generated Key , Primary Key, Retained Key And Surrogate Key ?

Answer»

ALTERNATE key is term also known as unique key.
Business key is one or more columns in a dimension table that comprise the primary key in a SOURCE table in an operational system.
Foreign key is one or more columns that are associated with a primary key or unique key in another table. A table can have one or more foreign keys. A foreign key is dependent upon its associated primary or unique key. In other words, a foreign key cannot exist without that primary or unique key.
Generated keys is used to implement surrogate keys and retained keys, one or more columns that are used to uniquely identify a ROW in a table. A table can have only one primary key. One or more columns in a primary key cannot contain null values. Retained key is a numeric column in a dimension table that is the primary key of that table.
Surrogate key is a column which contains unique integer values that are generated sequentially when rows are added and updated. In the associated fact table, the surrogate key is included as a foreign key in order to connect to specific dimensions.