How can you establish a link between Primary and Foreign key explain with the help of an example?
Answers
Answered by
0
Answer:
Table Invoice
secuencial as number, primary key
date as date
value as real
one-to-many relationship 1 ---------- many
Table Invoicedetail
codproduct as number
quantity as real
price as real
total as real
secuencial, foreign key
Explanation:
The primary key is a field, or group of fields that uniquely identifies a record. No other record can have the same primary key.
In the context of relational databases, a foreign key or foreign key is a referential constraint between two tables.
Similar questions