The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is

Related MCQs

• If every non-key attribute is functionally dependent on the primary key, then the relation will be in:
• A primary key when combined with a foreign key create
• An attribute of one table matching the primary key of another table, is called as
• The primary key is selected from the:
• When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
• If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?
• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?
• Relationships could be of the following type:
• Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?