On Mon, Oct 20, 2025 at 10:07 AM Rich Shepard <[email protected]> wrote:
> On Mon, 20 Oct 2025, Michał Kłeczek wrote: > > > There is also another concern - do you want to make sure phone numbers > are > > not shared? > > Michal, > > Shared with whom? I run a solo professional services consultancy so there's > only me here the database. > 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. -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
