How to create an ERD based on a dataset with limited attributes?

Ask the Community
1

My dataset only contains 4 columns (Area_code, Area, Year, Profit), how can I create an ERD out of that? I have been struggling for so long, someone please help. Thanks in advance

2

Hi @ann ,

I’m Huy Le from the dbdiagram team.

With dbdiagram, you can create a diagram and use DBML syntax to visualize your ERD.

This is an example of a table in DBML

Table my_table {
  area_code integer
}

Thanks.

3

Hi @huyleminh Huy Le, thanks for your answer. I do know the format on how to create an ERD, just that the dataset I got has too few columns/info, so I am not sure what should the ERD looks like or how should I connect the attributes.
Can you provide me with the code for the ERD for my dataset/ how the ERD should be like? I appreciate your help.

4

Hi @ann ,

Currently, I think your blocker is how to specify the datatype for your columns. Since I do not know about your business requirements, so I cannot help you find the most appropriate solution.

But I will try to help you; you can try this DBML

Table profits {
  Area_code int
  Area varchar(255) 
  Year int
  Profit decimal(15,2)
}