please solve both question correctly

If you have adjusted this table form this roll_no name subject 101 Akon 103 Ckon Bkon OS, CN Java C, C++ 102 TO THIS roll_no name subject 101 Akon OS 101 Akon CN 103 Ckon Java 102 Bkon CH 102 Bkon The Table is now in First Normal Form Fourth Normal Form Third Normal Form Second Normal Form Removing a partial Dependency Let's create another table for Subject, which will have subject_id and subject_name fields and subject_id will be the primary key. subject_id 1 subject_name Java C++ Php 2 3 another table Score, to store the marks obtained by students in the respective subjects. We will also be saving name of the teacher who teaches that subject along with marks. score_id student_id subject_id marks teacher 1 10 1 70 Java Teacher 2 10 2. 75 C++ Teacher 11 1 80 Java Teacher . 3 To fix the partial dependency we The simplest solution is to remove columns teacher from Score table and add it to the Subject table. Hence, the Subject table will become: subject_id subject_name teacher 1 Java Java Teacher 2. C++ C++ Teacher 3 Php Php Teacher And our Score table is now in the second normal form, with no partial dependency. score_id student_id subject_id marks 1 10 1 70 2. 10 N 75 3 11 1 80 These are no in normal form. O Second Fourth First Boyce and Codd