Database normalization E R M

Responsible Database normalization E R M on Foco campus.es , campus.net , Moodle 2.8  -Spain -Based in Madrid ,Salamanca,Jaen
Solid skills acquired through experience or education; the theoretical or practical understanding of a subject.Database schema

https://docs.moodle.org/dev/Database_schema_introduction

 
****************************************************************************************
Course_modules_database

RolesDatabase

user-tables-with-relations

Users_and_profiles_erd
Database normalization, or simply normalisation, is the process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy.

Normalization involves decomposing a table into less redundant (and smaller) tables without losing information, and then linking the data back together by defining foreign keys in the old table referencing the primary keys of the new ones. The objective is to isolate data so that additions, deletions, and modifications of an attribute can be made in just one table and then propagated through the rest of the database using the defined foreign keys.

MySQL_Workbench_Visual_Design_Mac

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *