Setting up a database diagram, need to associate people with ownership of data

Started by jmkeuning, September 20, 2017, 02:35:23 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jmkeuning

I am setting up a database diagram, it's pretty typical - tables with parent and foreign keys.

I am doing this so I can diagram who owns data in our organization, and who requests data. So there are like 10 directors. The IT director own the table with the Active Directory information, but the employee IDs in that table are in a table owned by HR. The table with the office numbers and phone extension is owned by Facilities, but of course a company directory is going to contain data from IT, HR, and Facilities.

I'd like to hang a person or name tag off of every table, but I figured I would ask how you suggest doing it!

Yacine

It depends on what you mean by

Quote from: jmkeuning on September 20, 2017, 02:35:23 PM
... I'd like to hang a person or name tag off of every table, ...

One hurdle could be that the tables have different ID systems (phone register may have only names, Active Directory may have IDs that differ from the employee IDs, etc.). The first step would be to unify them by replacing the tables by queries, that generate one common and uniform ID concept for the whole system.
Yacine