Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
DB2-Secondary key usage help

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
kriz_cts

New User


Joined: 03 Aug 2005
Posts: 23

PostPosted: Thu Aug 18, 2005 6:31 pm    Post subject: DB2-Secondary key usage help
Reply with quote

Hi folks,
Can you explain the following table as to how cust-id is a secondary key?

table 'customer'
attributes-customer-no,cust-name,cust-location,cust-id,order-no....

primary key - customer-no

secondary key - cust-id

foreign key - order-no

ii)how can there be multiple rows retrieved if the secondary key is unique?
Back to top
View user's profile Send private message
References
Karthikt

Active User


Joined: 15 Aug 2005
Posts: 52

PostPosted: Thu Aug 18, 2005 6:51 pm    Post subject:
Reply with quote

The table is not seems to be in boye code normal form. I guess it is in the second normal where more than one independecies are identified.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1