In the table above, we have data of 4 Computer Sci. rollno name branch hod office_tel 401 Akon CSE Mr. To understand these anomalies let us take an example of a Student table. Insertion, Updation and Deletion Anomalies are very frequent if database is not normalized. If a table is not properly normalized and have data redundancy then it will not only eat up extra memory space but will also make it difficult to handle and update the database, without facing data loss. If you want you can skip the video, as the concept is covered in detail, below the video. The video below will give you a good overview of Database Normalization. Ensuring data dependencies make sense i.e data is logically stored.Normalization is used for mainly two purposes, It is a multi-step process that puts data into tabular form, removing duplicated data from the relation tables. Normalization is a systematic approach of decomposing tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion, Update and Deletion Anomalies. ER Model: Generalization and SpecializationÄatabase Normalization is a technique of organizing the data in the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |