Forum

What can happen if ...
 
Notifications
Clear all

What can happen if a table is not properly normalized?


(@elias)
Illustrious Member
Joined: 5 months ago
Posts: 4277
Topic starter  

What can happen if a table is not properly normalized?


   
Quote
(@elias)
Illustrious Member
Joined: 5 months ago
Posts: 4277
Topic starter  

well, we are going to have some problems like

  • 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

(google says )

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.


   
ReplyQuote
Share: