In respect to this becoming a data mart, this is a very small insight into how it will eventually end up.

The reason for first & last name in both tables...