Home » RDBMS Server » Server Administration » I need to create 2 tables for below data how to map between the data values
I need to create 2 tables for below data how to map between the data values [message #666199] Thu, 19 October 2017 09:13 Go to next message
kubisztal
Messages: 1
Registered: October 2017
Junior Member
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.As few data entries are provided below if this is the case i need to enter 1000000 entries for database

 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

As the only option I tried is creating single table as cover_id and file As primary key.If that in the case i ll get many entries for database is there a way to normalize single table in to two tables without any anamolies.

please give any solution to map between these valuse
Re: I need to create 2 tables for below data how to map between the data values [message #666200 is a reply to message #666199] Thu, 19 October 2017 09:21 Go to previous messageGo to next message
BlackSwan
Messages: 25716
Registered: January 2009
Location: SoCal
Senior Member
I don't understand.

from where does the "requirement" that 2 tables are needed?

What is the source of the data?

What problem needs to be solved?

How to identify when correct solution has been posted here?
Re: I need to create 2 tables for below data how to map between the data values [message #666201 is a reply to message #666200] Thu, 19 October 2017 09:52 Go to previous message
cookiemonster
Messages: 12929
Registered: September 2008
Location: Rainy Manchester
Senior Member
We have no idea what this data represents, how it relates to anything else or what it is to be used for.

You're going to have to explain your issue in a lot more detail if you want any help with it.
Previous Topic: How to delete all data from the database
Next Topic: Block change tracking in standby database
Goto Forum:
  


Current Time: Tue Nov 21 20:02:51 CST 2017

Total time taken to generate the page: 0.01731 seconds