MIME-Version: 1.0
References: 
 <CAJk5AtbgTVySFcrd=ws=zs7UUVJujZyCcKsnu2ySqEpKEbyj+A@mail.gmail.com>
In-Reply-To: 
 <CAJk5AtbgTVySFcrd=ws=zs7UUVJujZyCcKsnu2ySqEpKEbyj+A@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 10 Dec 2025 09:06:51 -0500
Message-ID: 
 <CANzqJaBOSJUJ+5u0LmSEvhm40mNOVwMb2pxmy+voN=LhFGdC2Q@mail.gmail.com>
Subject: Re: Data quality assessment
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ea4d340645998afe"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaBOSJUJ%2B5u0LmSEvhm40mNOVwMb2pxmy%2BvoN%3DLhFGdC2Q%40mail.gmail.com>
Precedence: bulk

--000000000000ea4d340645998afe
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Dec 10, 2025 at 12:44=E2=80=AFAM Raj <rajeshkumar.dba09@gmail.com> =
wrote:

> Hi team,
>
> Client is asking Data Quality Assesment report.
>
> What should I include in the report?
>

Part of Laurenz' "document everything exactly" is telling them that you use
foreign keys to eliminate the possibility of orphaned children, and that
the schema design is normalized so as to eliminate redundancy and
modification anomalies.

If, of course, there are FKs and the schema design is normalized.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000ea4d340645998afe
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Dec 10, 2025 at 12:44=E2=80=AFAM =
Raj &lt;<a href=3D"mailto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gm=
ail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container=
"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi te=
am,<div dir=3D"auto"><br></div><div dir=3D"auto">Client is asking Data Qual=
ity Assesment report.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Wh=
at should I include in the report?=C2=A0</div></div>
</blockquote></div><div><br clear=3D"all"></div><div>Part of Laurenz&#39; &=
quot;document everything exactly&quot; is telling them that you use foreign=
 keys to eliminate the possibility of orphaned children, and that the schem=
a design is normalized so as to eliminate redundancy and modification anoma=
lies.</div><div><br></div><div>If, of=C2=A0course, there are FKs and the sc=
hema design is normalized.</div><div><br></div><span class=3D"gmail_signatu=
re_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div di=
r=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil m=
e, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div><=
/div></div></div></div>

--000000000000ea4d340645998afe--