Home › GATE CSE › computerscience › Database Management Systems › A foreign key is the relational analogue of
A foreign key is the relational analogue of
Awriting a vendor's GST number on your invoice to point at a vendor
Bwriting your own Aadhaar number on every form you fill out
Cissuing a fresh passport for every visa application
Dleaving the phone field blank when the number is unknown
Answer & Solution
Correct answer: A. writing a vendor's GST number on your invoice to point at a vendor
A foreign key points outward to a primary key in another relation, like a GST number on an invoice points to a vendor entry in the registry. Aadhaar-on-your-own-form is closer to a primary key; passport-per-visa describes denormalisation; a blank phone field is a NULL.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment