You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.
What should you create?
You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.
What should you create?
To implement a surrogate key for the retail store table, you should create a table that has an IDENTITY property. The IDENTITY property ensures a unique identifier for each row, which meets the requirements for a surrogate key. It generates a unique value automatically for each new row, making it efficient for both identifying records and joining tables in sales transaction datasets. This approach is commonly used in data warehousing to ensure unique and efficient identification of records without relying on the natural table data.
A surrogate key is a system-generated unique identifier that is used as a substitute for a natural key. In this case, the surrogate key will be used to account for changes to the retail store addresses. By creating a table with an IDENTITY property, you can ensure that a unique surrogate key is automatically generated for each row inserted into the table. The IDENTITY property assigns a unique value to the column automatically, incrementing by one for each new row. Using an IDENTITY column as the surrogate key will provide an efficient way to join and filter sales transaction records based on product ID, as required by the sales transaction dataset requirements.
A is the correct Answer !
Identity should be used.
Correct
is correct
Given answer is correct
CREATE TABLE RetailStore ( StoreID INT IDENTITY(1,1) PRIMARY KEY, StoreName NVARCHAR(100), Location NVARCHAR(100) );