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

Report message to a moderator

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: 26766
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?

Report message to a moderator

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: 13959
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.

Report message to a moderator

Previous Topic: user_tab_modifications not showing data for new table
Next Topic: How to delete all data from the database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 14:01:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.