Mikhail Gorbachev's policies of glasnost and perestroika had profound and unintended effects on the Soviet Union. In fact, many historians suggest these reforms led directly to the fall of communism and the breakup of the Soviet Union.
In SQL Server, you create a surrogate key by assigning an identity property to a column that has a number data type. A natural key is a naturally occurring descriptor of the data and one of a table's attributes that has no duplicate values. When you use a natural key as a table's primary key, each of the table's rows is uniquely identified.
There is only requirement for a surrogate Primary Key, which is that each row must have a unique value for that column. A Surrogate Key is also known as an artificial key or identity key. It can be used in data warehouses.A Surrogate Key should have the following characteristics:f there is no Surrogate Key on table then there is no need to create a unique index or sequence on a database table, so it helps us to reduce administrative overhead.Disadvantages of Natural Key. 1  A query join may become complex because the Natural Key can have one or more columns. 2  It is a reduced normalization form.