i need to create 2 tables for below data how to map between the data values.As my data values are each of them are not unique
cover_id , file , TestCase
256 , /x/eng/rlse/DOT//prod/common/raidv2/ric.c , test1
469 , /x/eng/rlse//prod/common/raidv2/rm.c , test1
179 , /x/eng/rlse/common/raidv2/rm_buffer.c , test1
163 , /x/eng/rlse//common/raidv2/rm_nvram.c , test1
83 , /x/eng/rlse/common/raidv2/scrub.c , test1
139 , /x/eng//common/raidv2/sparecore.c , test1
256 , /x/eng/rlse/DOT//prod/common/raidv2/ric.c , test2
130 , /x/eng/rlse//prod/common/raidv2/rm.c , test2
17 , /x/eng/rlse/common/raidv2/rm_buffer.c , test2
179 , /x/eng/rlse//common/raidv2/rm_nvram.c , test1
What I have tried:
As the only option I tried is creating single table as cover_id and file As primary key.If that in the case i need to enter 100000 entries is there any normalized way where i can create two tables