What is advantage of standardization?

Answer 1

Normalization provides numerous benefits to a database. Some of the major benefits include the following : * Greater overall database organization * Reduction of redundant data * Data consistency within the database * A much more flexible database design * A better handle on database security Organization is brought about by the normalization process, making everyone's job easier, from the user who accesses tables to the database administrator (DBA) who is responsible for the overall management of every object in the database. Data redundancy is reduced, which simplifies data structures and conserves disk space. Because duplicate data is minimized, the possibility of inconsistent data is greatly reduced. For example, in one table an individual's name could read STEVE SMITH, whereas the name of the same individual reads STEPHEN R. SMITH in another table. Because the database has been normalized and broken into smaller tables, you are provided with more flexibility as far as modifying existing structures. It is much easier to modify a small table with little data than to modify one big table that holds all the vital data in the database. Lastly, security is also provided in the sense that the DBA can grant access to limited tables to certain users. Security is easier to control when normalization has occurred. Data integrity is the assurance of consistent and accurate data within a database.

Answer 2

The advantage of standardization is that everybody is playing on the same playing field. For example, US and UK gallons are different quantities, so if you order 10 gallons of something from the UK, you might get more than you want because 10 UK gallons is 12 US gallons. The same difference applied to UK and US tablespoons, so you could make a mess if you followed a recipe.

In education, standardization of examinations makes sure everybody with the same degrees or qualifications are of the similar standards. How could Universities compare candidates if their school examinations were of different standards - some very difficult an others very easy?