Many legacy systems require normalization.
- Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization.
- Include in your discussion a detailed example on how each factor would eliminate data redundancy.
Post from Austyn you have to reply back
Hello professor and classmates,
Hello everyone! I hope everyone is having a fabulous day and staying safe.
Normalization associates with a method utilized in database design to decrease redundancies of the data that is stored. In reality, it’s practiced to optimally create a database by reducing redundant data through the usage of an optimally normalized set of tables. Nevertheless, some constituents must be examined to design such tables. First, consider dropping repeating groups. This can be accomplished by migrating recurrent groups into separate tables that save the recurrent groups from improving high-speed access.
The second factor is the set of values connected to various records, which must be put in separate tables before recounting the tables formed within a foreign key. For instance, rather than creating tables with a long list of vendors, it would be more suitable to put vendors’ data in a separate table. This will reduce data redundancy correlated to repeating groups.
An example to enhance the design of a database system evaluating primary key assignments is the first method that is recommended. This is mainly for the proper organization of relationships and table structures. This includes recognizing how some entities influence the performance of the database. Refining primary keys as needed for data granularity is an additional essential method. This method consists of utilizing the granularity of low fundamental atomic values within a database.
I hope you all have a wonderful and blessed day!