Let’s take an example to understand this.Įxample: Suppose a manufacturing company stores the employee details in a table named employee that has four attributes: emp_id for storing employee’s id, emp_name for storing employee’s name, emp_address for storing employee’s address and emp_dept for storing the department details in which the employee works. These are – Insertion, update and deletion anomaly. There are three types of anomalies that occur when the database is not normalized. Let’s discuss about anomalies first then we will discuss normal forms with examples. Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly, update anomaly & deletion anomaly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |