Skip to Content
0
Former Member
Aug 08, 2007 at 09:09 AM

table creatino primary keys which one to give

15 Views

hi below is the requirment for a table data can be as below

f1 f2 f3

100400 sherri.rhodes@avnet.com TECHNOLOGY HONG KONG LTD

100400 edie.osborn@amd.com TECHNOLOGY HONG KONG LTD

100400 ricky.leung@avnet.com TECHNOLOGY HONG KONG LTD

100550 sharonpeng@weikeng.com.tw WEIKENG INDUSTRIAL CO. LTD.

100550 vinnachiu@weikeng.com.tw WEIKENG INDUSTRIAL CO. LTD.

100550 ann@weikeng.com.tw WEIKENG INDUSTRIAL CO. LTD.

how shoud the design be and which one s hould i give primary keys

i suppose f1 a nd f3 should be givne as primary keys?

regards

Arora