Explain why normal forms were defined. What problems are solved by using them? Provide an example table that violates at least one normal form and explain how you would rebuild this table to make it...

ASSIGNMENT QUESTIONS
1. The Normal Forms
In the architecture of database management systems, several criteria have been devised to improve table organization and reduce the number of anomalies. A table is said to have reached its natural shape after it has been properly structured (or a stage of normalization).
Problems that are resolved using normalized data:
Data normalization entails more than just rearranging the stored information in a database in light of the growing importance of data to all types of commercial enterprises. The following is a list of some of its primary advantages:
· Reduces unnecessary data.
· Ensures that the database has consistent data across all fields.
· Design of the database that is more adaptable Increased database security.
· A more efficient and effective execution of data.
· Improved database organization on a global scale.
A firm has the ability to acquire any and all data it needs from any source. Without data normalization, much of it will be useless to the company.
2. If we take into consideration the first normal form:
If a relation has a composite or multi-valued attribute, the connection is out of the first normal form; otherwise, the relation is in the first normal form. A relation is said to be in first normal form if each of the attributes that it contains is a single valued attribute. ("First Normal Form (1NF) of Database Normalization | Studytonight", 2022)
Rules of first normal form are:
1. Single valued attributes
2. Attribute domain should not change
3. Unique name for attributes/columns
4. Order does not matter
Example:
The fact that all of our column names are distinct from one another, that we recorded the data in the order...