How does knowledge of data structure can be useful to learn DBMS ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

How does knowledge of data structure can be useful to learn DBMS ?

Dbms

4th May 2019, 5:15 PM
Deepak Bhalode
Deepak Bhalode - avatar
11 Answers
+ 3
I learned about it long time ago, but back then data structure & ERD were taught in different scopes. Maybe you can teach me normalization to refresh my memory?
5th May 2019, 7:34 AM
Ipang
+ 3
There are different levels of normalization. A lot of resources are available in the Internet. I am busy building lessons on constructs. When I finish that, I will get into datastructs. Will include normalization (very interesting).
5th May 2019, 7:40 AM
Da2
Da2 - avatar
+ 3
Deepak Bhalode you are welcome
5th May 2019, 7:42 AM
Da2
Da2 - avatar
+ 2
Thank you
5th May 2019, 7:41 AM
Deepak Bhalode
Deepak Bhalode - avatar
+ 1
I presume you are using Relational DB. Familiarity of datastructs can help you normalize the tables
4th May 2019, 10:59 PM
Da2
Da2 - avatar
+ 1
Da2 Can you give us an example how to use data structure to normalize tables?
5th May 2019, 4:26 AM
Ipang
+ 1
Are you familiar with normalization
5th May 2019, 7:23 AM
Da2
Da2 - avatar
+ 1
It's a process and analysis to reduce redundancy in table data IIRC, so how data structure helps with normalization again?
5th May 2019, 7:25 AM
Ipang
+ 1
Tables are composed of different data types, understanding datastructs gives you a better picture of how tables are stored internally. Have you ever done normalization?
5th May 2019, 7:27 AM
Da2
Da2 - avatar
+ 1
You do not just analyse... you define how the data is stored into tables. Being familiar with datastructs helps you in defining what data goes to what table. It also helps you anticipate and define queries
5th May 2019, 7:33 AM
Da2
Da2 - avatar
+ 1
Currently m working on data structure through C. After that I want to learn DBMS by my own. That's why I need suggestion to strt learning in proper way to make required fundamental strong
5th May 2019, 7:34 AM
Deepak Bhalode
Deepak Bhalode - avatar