Data model design considerations

In this section, we will briefly discuss various design considerations you should consider while designing a data model for the various databases discussed in the previous section. The following aspects need to be considered while designing a data model:

• Normalized versus denormalized: Normalization is a data organization technique. It is used to reduce redundancy in a relationship or set of relationships. This is highly used in RDBMS, and it is always a best practice in RDBMS to create a normalized data model. In a normalized data model, you store a column in one of the tables (which is most suitable), rather than storing the same column in multiple tables. When fetching data, if you need the data of that column, you can join the tables to fetch that column. The following diagram shows an example of normalized data modeling using the crows-feet notation:

Figure 2.11 – Normalized data modeling

In the preceding...