Question

rationship between primary key and foreign key

Answer 1

What do you mean by rationship

Answer 2

primary key (PK). A primary key is a unique value that identifies

a row in a table. In our example, ClientID is the primary key in the Client table. Primary Keys are also indexed in the database, making it faster for the database to search for a record.

2.The referred field ClientID which occurs in the Sales table is called the foreign key (FK). Hence, the foreign key identifies a column or set of columns in one (referencing) table that refers to a

column or set of columns in another (referenced) table. The “one” side of a relation is always the parent, and provides the PK attributes to be copied.