Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started