我需要为下面的数据创建2个表，如何在数据值之间进行映射

问题描述

我需要为下面的数据创建2个表如何在数据值之间进行映射。由于我的数据值都不是唯一的

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

我尝试过：



作为唯一的opti在我尝试创建单个表作为cover_id和文件作为主键。如果在我需要输入100000条目的情况下有任何规范化的方式，我可以创建两个表

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

推荐答案

CoverID     INT
Filepath    NVARCHAR
TestCaseID  INT, foreign key to Table2

表2：

Table2:

ID          INT, IDENTITY
caseName    NVARCHAR

这篇关于我需要为下面的数据创建2个表，如何在数据值之间进行映射的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！