Database Design for Mere Mortals®: 25th Anniversary Edition by Michael J. Hernandez

Database Design for Mere Mortals®: 25th Anniversary Edition by Michael J. Hernandez

Author:Michael J. Hernandez
Language: eng
Format: epub
Publisher: Addison-wesley
Published: 2021-08-15T00:00:00+00:00


Choose a candidate key that incorporates part of the table name within its own name. For example, a candidate key with a name such as SALES INVOICE NUMBER is a good choice for the SALES INVOICES table.

Examine the candidate keys and choose one to serve as the primary key for the table. The choice is largely arbitrary—you can choose the one that you believe most accurately identifies the table’s subject or the one that is the most meaningful to everyone in the organization. For example, consider the EMPLOYEES table again in Figure 8.5.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.