Insertion anomaly: Suppose a new course WEBDEV is to be inserted in the relation.It results in certain database anomalies when the relation is updated. The partial dependency in the above relation creates redundancy. They are not functionally dependent on complete key. The non-key attributes NAME, DEPT and MONFEE are functionally dependent on a part of primary key STUD_ID. The functional dependencies in this relation are as follows: STUD_ID à NAME, DEPT, MONFEE
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |