BJ.47 DB 테이블 설계 잘못하면 어떤 문제가 생길 수 있을까요?

#design #table #database #easycode Databases are crucial in the backend. Especially once designed and data begins to accumulate, it's not easy to restructure them. That's why initial database schema design is so crucial. Today, we'll focus on the problems that can arise from poor table design! 00:00 Intro 00:10 Duplicate data problems caused by poor design: insertion anomalies 08:08 Duplicate data problems caused by poor design: deletion anomalies 09:48 Duplicate data problems caused by poor design: update anomalies 11:07 Spurious tuples problems caused by poor design 15:55 Problems caused by an increase in null values 17:09 How to design a good database schema 17:42 Sometimes tables aren't split to improve database query performance 18:03 Conclusion