Exercise: Add Supernatural Key

  1. In the DSA right click Product table and choose Add Supernatural Key Field
  2. Type SNK_Product in the Name box
  3. Click the Add button next to Key store box
  4. In the Name box type Product
  5. Optionally choose a case insensitive Hashing Algorithm, if the source database is also case insensitive.
  6. Leave the remaining options at their default values and clisk OK button
  7. In the Business key selection list click ProductID and the Add button followed by OK button
  8. Notice the new field SNK_Product and its datatype.