Normalization is the process of organizing a database to reduce redundancy and improve data integrity.
Normalization also simplifies the database design so that it achieves the optimal structure composed of atomic elements (i.e. elements that cannot be broken down into smaller parts).
Also referred to as database normalization or data normalization, normalization is an important part of relational database design, as it helps with the speed, accuracy, and efficiency of the database.
Different database management systems define schema in their own way. This can make it difficult for database developers to work out exactly what a schema is – especially when switching between different DBMSs.
This article provides definitions used by the three leading database systems.
In database terms, a schema (pronounced “skee-muh” or “skee-mah”) is the organisation and structure of a database. Both schemas and schemata can be used as plural forms.
A schema contains schema objects, which could be tables, columns, data types, views, stored procedures, relationships, primary keys, foreign keys, etc.
A database schema can be represented in a visual diagram, which shows the database objects and their relationship with each other.
A basic schema diagram representing a small three-table database.
Above is a simple example of a schema diagram. It shows three tables, along with their data types, relationships between the tables, as well as their primary keys and foreign keys.
To reverse engineer a database in MySQL Workbench:
- Select Database > Reverse Engineer from the top menu of MySQL Workbench
- Set/review parameters for connecting to the DBMS then click Continue
- Enter password if required, then click OK
- The wizard will connect to the DBMS, fetch a list of databases, and check for any issues. Click Continue
- Select the database/s you would like to reverse engineer, then click Continue
- The wizard will retrieve all objects from the selected schema/s and check the results. Click Continue
- Select the database objects you’d like to have reverse engineered, then click Execute
- The wizard will now reverse engineer all selected objects and generate the EER diagram (behind the scenes). Click Continue
- A summary is displayed. Click Close
The EER diagram is now displayed on the screen.