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 table(entity) 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 Pk(or 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 (cust_ID, cust_name, cust_address, cust_balance)
Now let's assume a new attribute account_ID is added
CUSTOMER_ACCOUNT(cust_id, acct_id, cust_balance)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!