Data normalization
Data normalizationIf you want to create a relational database, you first need to define a table.But if you simply collect the items you need, the same data will be duplicatedand the database will be difficult to use. To prevent such problems, the workof splitting and simplifying the table is called "Data normalization"."Data normalization" is step-by-step, generally from first to third normalization.For example, unnormalized table is as follows. First normalized tableHowever, in the first normalized table, the same values are used unnecessarily, it makes the database inefficient. Therefore, the second normalization isperformed.Second normalized tables※The point of second normalization・Create
0
