Macromedia dreamweaver 8-using dreamweaver Manual De Usuario
Database design basics
989
In a one-to-many database relationship, a single row in one table is related to several rows in
the another table. You can define this kind of relationship by including a foreign key in the
table providing the many rows—in the above example, the shareholders table. A foreign key is
a column containing values matching those in the primary key column of another table. Your
aircraft table’s primary key is called
the another table. You can define this kind of relationship by including a foreign key in the
table providing the many rows—in the above example, the shareholders table. A foreign key is
a column containing values matching those in the primary key column of another table. Your
aircraft table’s primary key is called
ac_serial
. Therefore, including a foreign key called
ac_serial
in the shareholders table would define a “one-aircraft-to-many-shareholders”
relationship.
With your knowledge of the client’s feature request and of the company’s business rules and
policies, you decide to define the following one-to-many relationships in your database:
policies, you decide to define the following one-to-many relationships in your database:
■
Each aircraft can have many shareholders
■
Each aircraft has many bookings
■
Each aircraft has many itineraries
■
Each shareholder has many itineraries
■
Each itinerary can have many flights (or legs)