Question: PK is defined in context of a table ( entity ) so that it must uniquely identify a row in the table. I.e . ,
PK is defined in context of a tableentity so that it must uniquely identify a row in the table. I.e if i give you the value for PK it should return one and only one row from that table. PK can be a single attribute or a combination of attributes.
FK: is defined as an attribute in one relation which must be a Pkor part of PK in another relation. It is used to join reference tables.
Given the following relations identify PK and FK of each relation
CUSTOMER custID custname, custaddress, custbalance
Now let's assume a new attribute accountID is added
CUSTOMERACCOUNTcustid acctid custbalance
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
