Explore BrainMass
Share

Explore BrainMass

    Primary keys, candidate keys, and two dimensional tables

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Question 1
    Distinguish between the primary key and a candidate key. Provide an example of each.

    Question 2
    What requirements must a two-dimensional table satisfy in order to be a relation? Provide an example of a table that is a relation.

    © BrainMass Inc. brainmass.com October 10, 2019, 4:29 am ad1c9bdddf
    https://brainmass.com/business/management-information-systems/primary-keys-candidate-keys-and-two-dimensional-tables-462785

    Solution Preview

    Question 1

    The primary key is a candidate key that the IT professional has selected that acts to identify the rows in a table. The primary key is typically chosen based upon the amount of foreign key data that needs to be generated. The primary key is used for four distinct tasks, including identifying table rows, and then representing the rows into a relationship. The other two duties include organizing the relation of storage and for use in indexes to improve operational performance. A good use of a primary key would be a key internally generated "that has no meaning outside of the database system" (Chapple, 2012). This would then be used as an auto number to create a record identification, which would be automatically generated in specific order each time a new record is created by the user.

    The candidate ...

    Solution Summary

    This solution discusses primary and candidate keys, and also discusses the requirements needed for a two dimensional table in order to be a relation. References are provided for both questions.

    $2.19