Re: Arrays vs separate tables

On Mon, Oct 20, 2025 at 10:07 AM Rich Shepard <rshepard(at)appl-ecosys(dot)com>
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!