Example of Two Schema Integrations
Example: Suppose we want a mediated (database) schema to integrate two travel databases, Go-travel and Ok-travel.
Go-travel has three relations:
Go-flight(f-num, time, meal)
Go-price(f-num, date, price)
f-num is the flight number and meal is a boolean.
Ok-travel has just one relation:
Ok-flight(f-num, date, time, price, nonstop)
'nonstop' is a boolean.
The overlapping information in Ok-travel’s and Go-travel’s schemas could be represented in a mediated schema:
Flight(f-num, date, time, price)
Read more about this topic: Schema Object