Applied Structured Database in a Small Project

The growth of software application today has a lot of variety. The ease for software developers which provide an interest for all is to do self-taught learning. However, not all application developers are able to apply database theory in developed database systems. Database development needs to be normalized. Famous theoretical normalization for the database is known as BCNF Boyce-Codd normal form. This theory is actually very easy to understand but in the execution, application developers for small project application do not use the theory in the implementation of the database in their system. One of the reasons is the lack of understanding of normalization process. The simplest way to verify database normalization in a small project is with the use of ERD (Entity Relationship Diagram). This can be known by the same representation of the number of entities in the ERD by the number of tables in the database schema.