What is a foreign key? (i) A foreign key is a primary key of a relatio

Back to the 2018 paper

Module 1: Database System Architecture

20182m

What is a foreign key?
(i) A foreign key is a primary key of a relation which is an attribute in another relation
(ii) A foreign key is a superkey of a relation which is an attribute in more than one other relations
(iii) A foreign key is an attribute of a relation that is a primary key of another relation
(iv) A foreign key is the primary key of a relation that does not occur anywhere else in the schema

Search Google Ask AI

Similar questions

Database Management SystemKey to represent relationship between tables is called (i) primary key (ii) secondary key (iii) foreign key (iv) None of the above20202m DATABASE MANAGEMENT SYSTEMThe relational model feature is that there - (i) is no need for primary key data (ii) is much more data independence than some other database models (iii) are explicit relationships among records (iv) are tables with many dimensions20212m Database Management SystemWith example discuss candidate key, super key, primary key and foreign key.20227m Database Management SystemA relational database developer refers to a record as (i) a criterion (ii) a relation (iii) a tuple (iv) an attribute20202m

PreviousWhat is an instance of a database? (i) The logical design of the database system (ii) The entire set of attributes of the database put together in a single relation (iii) The state of the database system at any given point of time (iv) The initial values inserted into the database immediately after its creation NextTo include integrity constraint in an existing relation use (i) create table (ii) modify table (iii) alter table (iv) drop table