Physical data model for the TFG Academy example. It shows a subset of the tables as they are included in the TFG Academy database. These three entities are used and expanded in the other two layers logically and conceptually.

Street address information for customers, employees, and vendors.

Types of addresses stored in the Address table.

Source of the ID that connects vendors, customers, and employees with address and contact information.

Cross-reference table mapping customers, vendors, and employees to their addresses.

Where to send a person email.

Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.

Telephone number and type of a person.