Reference guides for Data representation in Tabular form

[dennis_oz]

Hi all,

I was looking for some blogs where it explains how data needs to be put tabular format for different business requirements . 

for example

eg : capturing contacts from a customer . But when we need to have this reported every month how it needs to be done , how to go about doing that .

use table 2 or use table 3 

customer	sms	phone	email
Mark
John

table 2
customer	sms_042021	phone_042021	email_042021	sms_052021	phone_052021	email_052021
Mark
John

table 3
customer	month	sms	phone	email
Mark	42021
Mark	52021
John	42021
John	52021

so looking for some blogs or documentation on similar scenarios.

sorry if I don't make sense . I did not know whether to post this message out there or not .. but I thought if I hold back there is nothing I am learning . I might as well ask an irrelevant question and be corrected on my approach that have this just kept in my mind .

thanks in advance !

[japelin]

It depends on what kind of data you currently have and what purpose you want to use the data for, but in general, normalized data is easier to work with.

Therefore, it is better to use table3. It is easy to extract monthly data.

[andreas_lds]

Difficult to suggest something without knowing the "different business requirements" you mention.

I would question then need to see old and maybe outdated contact information at all.

[Sajid01]

Hello
The following blogs will help you understand the concepts of database design 

https://en.wikipedia.org/wiki/Database_design 

https://en.wikipedia.org/wiki/Database_schema 

https://www.datavail.com/blog/an-introduction-to-database-design-from-logical-to-physical/ 

https://www.astera.com/type/blog/all-you-need-to-know-about-database-design/#:~:text=Database%20desi.... 

You can also look at some of  the sample databases that come with Microsoft Access and Microsoft SQL Server .
These resources will help how data needs to be put tabular format for different business. requirements.