Answer to Problem 2.2

The determinants of the Employee relation are [id] and [ssn]. The candidate identifiers are [[id], [ssn]]. Either [id] or [ssn] can be the primary identifier (but not both). You simply have to choose one.

Return to first normal form document.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License