introduction to Database Management System

Question 5 Assume that the two tables BookAdoption and TextBook are not in the database instead we have the table BookAdoption_TextBook (cNo, semester, bookid, title, publisher, author). The primary key attributes are underlined. bookID is unique for all the books. a) [1.5 pt] Give an example of an update anomaly, if there is any. Justify your answer in no more than 2 lines. there exist an upout anomaly as if the Publisher of the Book changes then the published Colum will be update b) [1.5 pt] Give an example of a deletion anomaly, if there is any. Justify your answer in no more than 2 lines if the information Data is Deleted for Last Semester then only information of that semester will be deleted, but it only book is is there along with the semester then that book info will store in another table - so there exist delete anomaly c) [1 pt] Does the functional dependency cNo, semester, bookID title, publisher hold? Answer yes or no. Justify your answer. Write no more than 2 lines. No, it's not hold