Editing Database schema (section)

==Example of two schema integrations==
Suppose we want a mediated schema to [[data integration|integrate]] two travel databases, Go-travel and Ok-flight.

'''<code>Go-travel</code>''' has two relations:
<syntaxhighlight lang="text">
Go-flight(flight-number, time, meal(yes/no))
Go-price(flight-number, date, price)
</syntaxhighlight>

'''<code>Ok-flight</code>''' has just one relation:
<syntaxhighlight lang="text">
Ok-flight(flight-number, date, time, price, nonstop(yes/no))
</syntaxhighlight>

The overlapping information in Go-travel’s and Ok-flight’s schemas could be represented in a mediated schema:<ref name="source2" />
<syntaxhighlight lang="text">
Flight(flight-number, date, time, price)
</syntaxhighlight>