Accounting for all the people
We're all people, whether we're employees, supervisors, or customers. Why do so many databases store different categories of people in separate tables? Databases segregate customers, employees, and vendors into separate tables, even though each of these groups has numerous common attributes. Everyone has a first and last name, an address and phone number—or more likely, several—and some unique identifier to make data management and people administration easier.
In ...