- Posts: 3957
What can happen if a table is not properly normalized?
- ekatsa
- Topic Author
- Offline
- Admin
Less
More
3 weeks 10 hours ago #3272
by ekatsa
What can happen if a table is not properly normalized? was created by ekatsa
What can happen if a table is not properly normalized?
Please Log in to join the conversation.
- ekatsa
- Topic Author
- Offline
- Admin
Less
More
- Posts: 3957
3 weeks 10 hours ago - 3 weeks 10 hours ago #3273
by ekatsa
Replied by ekatsa on topic What can happen if a table is not properly normalized?
well, we are going to have some problems like
Without normalization, database systems can be inaccurate, slow, and inefficient and they might not produce the data you expect. We use the normalization process to design efficient and functional databases. By normalizing, we store data where it logically and uniquely belongs.
- redundant info
- not proper ability to update, delete, insert, e.t.c. data
- more disk space and database space
- not accurate answers of queries
- and more
Without normalization, database systems can be inaccurate, slow, and inefficient and they might not produce the data you expect. We use the normalization process to design efficient and functional databases. By normalizing, we store data where it logically and uniquely belongs.
Last edit: 3 weeks 10 hours ago by ekatsa.
Please Log in to join the conversation.
Time to create page: 0.193 seconds