How to create Data dictionary or query

Hi,
I need to a way on how to query my sql server database on the following
by my client who know nothing on database query. I need to give them
a simple easy using tool for them to check
01) of any changes that other user modify, which related table is affected
02) if data is modify, what business rule is affected
03) any deletion, which related table is related or affected
Anyone done similar stuff on this before, is it related
to data dictionary ?
Please advise and assist me on how to go about doing it.
Thank youHi
If you are using a tool to design your database then this information should
be in there. The tool will dictate how easily this meta data can be used or
exported. You may want to hold this in separate tables within your database
or may use of SQL Server's extended properties (see Property Management in
the SQL Server Architecture section of Books online).
John
"Vladimir Sim" wrote:

> Hi,
> I need to a way on how to query my sql server database on the following
> by my client who know nothing on database query. I need to give them
> a simple easy using tool for them to check
> 01) of any changes that other user modify, which related table is affected
> 02) if data is modify, what business rule is affected
> 03) any deletion, which related table is related or affected
> Anyone done similar stuff on this before, is it related
> to data dictionary ?
> Please advise and assist me on how to go about doing it.
> Thank you
>
>