Designing the relational database on the example of a shop of cellular phones based on the principles of normalization

The article discusses the design of a relational database on the example of a cell phone store based on the principles of normalization. During the design of the database, the problem of data redundancy arises, which will require additional memory resources to store a variety of data. The process of reduction to normal form will allow eliminating duplication of data, working with data of simple types. This paper provides an example of designing in MySQL using the special tool PhpMyAdmin version 4.7.7. This product is included in OpenServer - a software package for working with databases and creating websites. The selected DBMS allows you to design a database to meet the requirements of normal forms. Thus, the designed database in PHPMyAdmin will satisfy three requirements applicable to the database: completeness, integrity, non-redundancy (data duplication exclusion). This DBMS provides with the help of a graphical interface a quick process of bringing tables to the requirements of normal forms.