Example: Parts Network
Scenario: Many vendors, each supplying one or more parts. Customers want a “one-stop” on-line shopping mall.
Approach: Parts ‘R Us defines a gestalt:
- Part(pid, sid, description, cost, units_avail)
- Each supplier defines a local “My_Parts” table with the same fields, and registers it into the gestalt.
- Customers query the Parts table, and queries reflect contents of all local My-Parts tables.