Which of these statements are TRUE regarding normalization? I. Repeating groups must be eliminated by ensuring that each row detines a single entity. II. A dependency of one non-prime attribute on another non-prime attribute is a partial dependency. III. Dependencies that are based on only a part of a composite primary key are called transitive dependencies. IV. Normalization works through a series of stages called normal forms. O A. I and IV OB.Ill and IV O C. Il and I D. I and I Consider the given table. The table shows the relation of students and the course taken. Table 1 MatrixNo Name Courses Taken CourseNo Department Semester 4568 Adura CS101 C.S. 1 EE545 E.E. 2 Phy325 Physics 1 4894 Emelia Phy101 Physics 1 Chem202 Chemistry 2 Math103 Math. 1 CS101 C.S. 4954 Alawi CS101 C.S. 1 Why do we consider given table is still in Unnormalized Form (UNF)? O A. Student named Alawi only have one course registered. O B. The composite attribyte (CS101, C.S. 1) is repeated. O C. It is difficult to store due to non-uniform size of the attributes. O D. MatrixNo 4568 has three course lines. A database language allows user to perform the following operation EXCEPT: O A. Perform simple and complex queries O B. Perform basic data management tasks. O C. Create database and relation structures OD. Design entity relationship diagram (ERD) Which of the following is TRUE about the specialization process? O A. Defining one or more subclasses of the superclass and forming superclass/subclass relationships. O B. Defining one or more superclasses of the subclass and forming superclass/subclass relationships O C. Defining one or more subclasses of the superclass and not forming superclass/subclass relationships O D. Defining one or more superclasses of the subclass and not forming superclass/subclass relationships