I have a table (lets say buyers) with 50k record in it
The thing is 45k record come from 3000 buyers (which I can normalize with a detail table) however I have no idea how to implement the other none regular buyers
what do you say?
should I accept the fact that I can not normalize this varchar (50) field?
The thing is 45k record come fromd 3000 buyers (which I can normalize with a detail table) however I have no idea how to implement the other none regular buyers
I'm not fully understand your requirement . Could you please explain more about that ?
Best Regards,
Nan Yu
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
I still don't see what you can't do. It seems you'll have a master table and 0 to n rows in the detail table. Or do you mean that a buyer belongs to 0 or 1 firm ?
I still don't see what you can't do. It seems you'll have a master table and 0 to n rows in the detail table. Or do you mean that a buyer belongs to 0 or 1 firm ?
Keep in mind we have no context at all and I still don't get which kind of data you are trying to store. IMO explain that rather in plain English (and just what you actually want to do rather than showing us a table and just telling us you can't do that).
For now it seems you have "buyers" (aka "customers") and "senders". If you have a n to n relation between them you'll have a 3rd table where you find couples of (buyer id, sender id) values...
Edit: or the problem is that you create a new row each time you have a new "sender" and it may be something repeated (FirmA 3times or not such as "SimpleLonelyCustomer..."). In this case how does it come that a new row is created for the same sender each
time rather than being reused ?
Member
90 Points
520 Posts
How to normalize a field with Stable/Variable input
Feb 25, 2019 04:24 PM|fatihbarut|LINK
Hi all,
I have a table (lets say buyers) with 50k record in it
The thing is 45k record come from 3000 buyers (which I can normalize with a detail table) however I have no idea how to implement the other none regular buyers
what do you say?
should I accept the fact that I can not normalize this varchar (50) field?
All-Star
18785 Points
3830 Posts
Microsoft
Re: How to normalize a field with Stable/Variable input
Feb 26, 2019 08:29 AM|Nan Yu|LINK
Hi fatihbarut,
I'm not fully understand your requirement . Could you please explain more about that ?
Best Regards,
Nan Yu
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
Member
90 Points
520 Posts
Re: How to normalize a field with Stable/Variable input
Feb 26, 2019 08:46 AM|fatihbarut|LINK
ok here is the pseudo master table
Id Sender
1 FirmA
2 FirmA
3 FirmA
4 FirmB
5 SimpleLonelyCustomerWithoutAnyFirmOrMoneyWhoWillNeverSendAnythingInTheFuture
6 AnotherSimpleLonelyCustomerWithoutAnyFirmOrMoneyWhoWillNeverSendAnythingInTheFuture
7 FirmC
8 FirmC
As you see, There are regular customers and irregulars in the table and I can not normalize this field using another detail table
Because the input of the sender field is variable (not comes from standard senders every time)
I can not make a detail table like this
Senders
Id Name
1 FirmA
2 FirmB
3 FirmC
All-Star
45840 Points
16682 Posts
Re: How to normalize a field with Stable/Variable input
Feb 26, 2019 08:56 AM|PatriceSc|LINK
Hi,
I still don't see what you can't do. It seems you'll have a master table and 0 to n rows in the detail table. Or do you mean that a buyer belongs to 0 or 1 firm ?
Member
90 Points
520 Posts
Re: How to normalize a field with Stable/Variable input
Feb 26, 2019 09:36 AM|fatihbarut|LINK
I updated my previous answer
All-Star
45840 Points
16682 Posts
Re: How to normalize a field with Stable/Variable input
Feb 26, 2019 11:59 AM|PatriceSc|LINK
Keep in mind we have no context at all and I still don't get which kind of data you are trying to store. IMO explain that rather in plain English (and just what you actually want to do rather than showing us a table and just telling us you can't do that).
For now it seems you have "buyers" (aka "customers") and "senders". If you have a n to n relation between them you'll have a 3rd table where you find couples of (buyer id, sender id) values...
Edit: or the problem is that you create a new row each time you have a new "sender" and it may be something repeated (FirmA 3times or not such as "SimpleLonelyCustomer..."). In this case how does it come that a new row is created for the same sender each time rather than being reused ?
Member
90 Points
520 Posts
Re: How to normalize a field with Stable/Variable input
Feb 26, 2019 01:53 PM|fatihbarut|LINK
It seems like my problem's solution. could you explain it little bit more
All-Star
45840 Points
16682 Posts
Re: How to normalize a field with Stable/Variable input
Feb 26, 2019 03:30 PM|PatriceSc|LINK
So you would tables such as :
1 Buyer 1
2 Buyer 2
3 Buyer 3
1 Firm A
2 Firm B
3 Firm C
And so a 3rd table telling which buyer bought to which firm maybe all along with a date or some other information :
BuyerId FirmId What OnWhichDate etc...
1 2
1 3
2 1
See perhaps http://www.tomjewett.com/dbdesign/dbdesign.php?page=manymany.php and scroll down to the end for another sample showing how products and orders are related through an OrderLine table.