On Mon, 20 Oct 2025, Ron Johnson wrote:
Multiple contacts at the same client company. If, for whatever reason, the phone number changes you've got to update X rows in your contacts table, whereas only one row needs to be updated when the schema meets 1NF. This eliminates update anomalies.
Ron, Not an issue: the companies table has a 'phone' column while the people table has both 'direct_phone' and 'cellphone' columns. And, the locations table has a 'loc_phone' column because many industrial companies have multiple facilities. Regards, Rich
