I. Short Answer. (10 Marks: 2 marks each) 1. What do you mean by weak entity sets? 2. An insertion anomaly occurs when we cannot insert some data into the database without inserting another entity first. If true, then why? 3. What are attributes? 4. Explain the term of primary key, candidate key, and super key. 5. Explain difference between 1:1 and 1: M relationship. II. Application 1. What is E-R model? What is the use of E-R model? Draw any E-R diagram of your choice. Specify different entities. their attributes, cardinalities and degrees of the relationships in the E-R model (Rubrics: 10 Marks - 2 mark for definition+2 marks for use +6 marks for the diagram with all specified criterias) 2. Consider the following relation for published books: BOOK (Book_title, Author_name, Book_type, List_price. Author_affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book_title Publisher, Book_type Book_type - List_price Author_name Author_affil a. What normal form is the relation in? Explain your answer. b. Apply normalization until you cannot decompose the relations further State the reasons behind each decomposition (Rubrics: 10 Marks 3 Marks for correct answer to question (a) with detailed explanation + 4 marks for correct nomatization a. What normal form is the relation in? Explain your answer. b. Apply normalization until you cannot decompose the relations further. State the reasons behind each decomposition (Rubrics: 10 Marks 3 Marks for correct answer to question (a) with detailed explanation + 4 marks for correct normalization + 3 marks for explanation of decomposition) 3. Apply Normalization (10 Marks) A table with the students and their grades in different topics. (Rubrics: 10 Marks marks for correct and complete normalizationt)