Re: Need help in database design

On 12/23/24 08:55, David G. Johnston wrote:
> On Mon, Dec 23, 2024, 09:54 Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     On 12/23/24 08:46, Divyansh Gupta JNsThMAudy wrote:
>      > Also as you ask how 50 pairs turns into 50 column so each column
>     will be
>      > a key and the value of that key will store inside their respective
>      > column for each row
> 
>     My problem with understanding this is 50 pairs = 100 values, I don't
>     understand how that can fit in 50 columns that can only handle 1 value
>     each. You need to provide some example data showing what you want to
>     achieve. It does not need to be the full 50, just something to show the
>     process.
> 
> 
> 
> Because the column name is the same as a dictionary key...

Aah, got it thanks.

> 
> David J.
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com